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

[µo°Ý] ½Ð±Ð¨â­Óif¨ç¼Æ¦X¨Ö

[µo°Ý] ½Ð±Ð¨â­Óif¨ç¼Æ¦X¨Ö

²Ä1­Ó  (IF(J2="¦¨¥\",(ROUND((HOUR(S2-Q2)+(MINUTE(S2-Q2))/60),2))*60))


²Ä2­Ó  (IF(J2="¥¢±Ñ",(ROUND((HOUR(D2-S2)+(MINUTE(D2-S2))/60),2))*60))

½Ð±Ð¸Ó¦p¦ó¦X¨Ö,½Ð°ª¤âÀ°¦£,ÁÂÁÂ~

·PÁÂhuijuang ¤jÀ°¦£,°ÝÃD¸Ñ¨M¤F,ÁÂÁÂ

TOP

¦pªGJ2¥u¦³¦¨¥\©Î¥¢±Ñªº¸Ü
=IF(J2="¦¨¥\",(ROUND((HOUR(S2-Q2)+(MINUTE(S2-Q2))/60),2))*60,(ROUND((HOUR(D2-S2)+(MINUTE(D2-S2))/60),2))*60)

¦pªGJ2°£¤F¦¨¥\©M¥¢±Ñ¤§¥~ÁÙ¦³¨ä¥Lªº¸Ü

=IF(J2="¦¨¥\",(ROUND((HOUR(S2-Q2)+(MINUTE(S2-Q2))/60),2))*60,if(J2="¥¢±Ñ",(ROUND((HOUR(D2-S2)+(MINUTE(D2-S2))/60),2))*60,""))
°Ê©À¦¨¦]¿n¦]¦¨ªG by huijuang

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD