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

¨D´«ºâ¯Z§O¡B¤é´Á¡B¶g§O

1) ¯Z§O
=IF(MOD(TEXT(A2,"hh:mm")-"20:00",1)<0.5,"©]¯Z","¤é¯Z")

2) ¤é´Á
=INT(A2)-(HOUR(A2)<8)

3) ¶g§O
="W"&ROUNDUP((C2+1-"2021/1/1"+MOD("2021/1/1"-2,7))/7,)

...7/5 08:00~7/12 08:00 À³¬° W28¶g, ­Y§Aªººâªk¤£¦P, ¦Û¦æ¥h½Õ¾ã
¥¿½T°Ï¶¡À³¬° 7/5 08:00~7/12 07:59(³oºâ 7/11) ---  7/12 08:00 À³ºâ¨ì 7/12

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD