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

¦p¦ó±N¼Æ¦rÂà´«¦¨®É¶¡¨Ã°µ¹Bºâ

¦p¦ó±N¼Æ¦rÂà´«¦¨®É¶¡¨Ã°µ¹Bºâ

¤ñ¦p
±N36Âà´«¦¨0:36¡A»P7:00¥[Á`«áÅܦ¨7:36
±N71Âà´«¦¨1:11¡A»P8:00¥[Á`«áÅܦ¨9:11

¥»¨Ó·Q¸ÕTEXT¨ç¼Æ¡A¦ý¤£ª¾®æ¦¡¸Ó«ç»ò¿é¤J
¨ºÃ䦳¸ê®Æ¥i¥H°Ñ¦Ò¶Ü?
(¨S¸Õ¦¨¥\¡A¤£ª¾³o¬O¤£¬O¤@­Ó¸Ñ¨Mªº¤èªk)

¥»©«³Ì«á¥Ñ register313 ©ó 2012-6-25 14:11 ½s¿è

¦^´_ 1# vvcvc

1.jpg
2012-6-25 13:58

C2=A2+B2/60/24  ¦Û­q®æ¦¡hh:mm
©Î
C2=TEXT(A2+B2/60/24,"hh:mm")

TOP

§c¡AÁÂÁÂ
­ì¨Ó¬O§Ú¤Ö°£24¤~ºâ¤£¥X¹ïªºµ²ªG
(¬ðµMı±o³o°ÝÃD¦n¹³¬O¨Ó¾xªº)

TOP

EXCEL ªº¼Æ­È1¡A­Y Âà´«¦¨¤Ñªí¥Ü¡G1¤Ñ=24¤p®É¡C

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD