½Ð±Ð¤å¦r¤é´Á®æ¦¡Âà´«¦è¤¸®æ¦¡&®É¶¡pºâ
- ©«¤l
- 105
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 240
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2024-12-24
|
½Ð±Ð¤å¦r¤é´Á®æ¦¡Âà´«¦è¤¸®æ¦¡&®É¶¡pºâ
½Ð±Ð¥ý¶i~
Q1¡B¤å¦r®æ¦¡0900101¡A¦³¤°»ò¨ç¼ÆÅܦ¨20010101ªº¦è¤¸¦~®æ¦¡¶Ü?
Q2¡B¿é¤J¬Y¤@®É¶¡ÂI¡A¦³¤°»ò¨ç¼Æ¥i¦Û°Ê¥[0.5hr¡A©Î1hr? (¨Ò:¿é¤J01:00, ¥i¥H¦Û°Êºâ¥X01:30©Î 02:00)
¦pªþ¥ó»¡©ú~
¤é´Á&®É¶¡°ÝÃD.zip (11.44 KB)
|
|
|
|
|
|
|
- ©«¤l
- 552
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 578
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-2-8
- ³Ì«áµn¿ý
- 2024-7-9
|
¦^´_ 1# chi830
§Ú¥u·|²Ä¤@Ó¡A¦ý¤£ª¾¹ï¤£¹ï
=(MID(D2,1,3)+1911)&"/"&MID(D2,4,2)&"/"&MID(D2,6,2) |
|
|
|
|
|
|
- ©«¤l
- 105
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 240
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2024-12-24
|
¦^´_ 2# lpk187
ÁÂÁÂlpk187¥ý¶i~²Ä¤@ÃD¥¿¦p±z©Òµª¡A¬Ookªº¡AÁÂÁÂò ^_^ |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 1# chi830
Q1:
=TEXT(C2+19110000,"0000!/00!/00")
©Î
=TEXT(C2+19110000,"0000!/00!/00")*1 |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
Q2:
n¥[0.5¤p®É
=A1+"0:30"
©Î
=A1+0.5/24
n¥[1.0¤p®É
=A1+"1:00"
©Î
=A1+1/24 |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 161
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-9-16
- ³Ì«áµn¿ý
- 2017-2-19
|
²Ä¤@ÃD, Åܦ¨¦è¤¸¦~¼ÆȤé´Á®æ¦¡ :
=--TEXT(C2+19110000,"00-00-00") |
|
|
|
|
|
|
- ©«¤l
- 105
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 240
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2024-12-24
|
ÁÂÁÂML089 & JBY ¥ý¶i~
2¦ìªº¤è¦¡¤]³£¬O¥i¦æªº~·PÁ±z̳á^^ |
|
|
|
|
|
|