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

½Ð°Ý¤@­Ó®É¶¡®æ¦¡...

½Ð°Ý¤@­Ó®É¶¡®æ¦¡...

¦U¦ì¤j¤j¦n ¬¡­¶Ã¯2.rar (53.25 KB)
¦pªG®æ¦¡¬°ºâ¥X¬O104:00:00~·N«ä¦³104¤p®É..§Ú­n¦p¦ó¨ú¥X³o104¤p®É¥Îhour¨ç¼Æ¤£¦æ,,,¦]¬°§ÚÁÙ­n­¼¤W®ÉÁ~¡ã¡ã¨D¨ó§U¡H¡H
yvonne

¦³¤H¥i¥HÀ°À°¦£¶Ü
yvonne

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2022-3-20 09:51 ½s¿è

­q³q¥Î®æ¦¡=TEXT(K2,"[H]")*212

OR=K2*24*212
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¥»©«³Ì«á¥Ñ ¼B¤j­G ©ó 2022-3-22 10:40 ½s¿è

Hello, afu

¦pªG±zªº­È¤w¬O104:00:00ªº¸Ü, ´N¬O¨Ï¥Îhcm¤jªº°µªk.
¦pªG±zªº­È¬O¤G­Óªº®É¶¡®t, «Øij¨Ï¥Î«ü¥O:: DateDiff("h",datetime1,datetime2)  ´N¤£»Ý­n¦A¤@¦¸Âà´«.

Thanks ~
·s¤â¤W¸ô¡A½Ð¦h¥]²[¡C

TOP

¦^´_ 3# hcm19522


    ·PÁ¤j¤j¬Û§U
yvonne

TOP

¦^´_ 4# ¼B¤j­G


     DateDiff("h",datetime1,datetime2)...¨S¬Ý¹L³o­Ó«ü¥O
yvonne

TOP

¦^´_ 6# afu9240


https://support.microsoft.com/zh-tw/office/datediff-%E5%87%BD%E6%95%B8-e6dd7ee6-3d01-4531-905c-e24fc238f85f
·s¤â¤W¸ô¡A½Ð¦h¥]²[¡C

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD