ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

®É¶¡¨ç¼Æ

®É¶¡¨ç¼Æ

½Ð±Ð¤j¤j­Ì,
¨ç¼Æªº­pºâ, ¦pam10:00~pm17:00, ­pºâ¦X¦@®É¼Æ, ¨ç¼Æ, ÁÂÁÂ!!

¦^´_ 1# ©P¤j°¶

C1=(B1-A1)*24
TIME.rar (1.6 KB)

TOP

¦^´_ 2# register313
ÁÂÁ¤j¤j¦^À³,
a1¬°8:00am~b1¬°11am, c1¬°14:00pm,d1¬°19pm, ½Ð±Ð¤j¤j, ­Y§â³o¨Ç®É¶¡¥[Áo¨ç¼Æ´N¦p¦ó¼g, ½Ð«ü¾É. ·P®¦..

TOP

¦^´_ 3# ©P¤j°¶


=SUM(A1:D1)   ³æ¦ì:¤é

TOP

¦^´_ 4# register313
¤£¦¨¥\. ¥i§_°µ­Ó½d¨Ò, ÁÂÁÂ!

TOP

¦^´_ 5# ©P¤j°¶

¬O­n³o¼Ë¶Ü?
­pºâ: A1~B1ªº¤p®É¼Æ+C1~D1ªº¤p®É¼Æ
¤½¦¡: =(B1-A1+D1-C1)*24  

TIME.rar (1.9 KB)

TOP

¦^´_ 6# register313
§Ú¸£®ü¤¤¥u·|¤@¤é12¤p®É, ¨S·Q°_24¤p®É¤~¹ï,
¦AÁ¹L¤j¤j,

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD