Tus lej xov tooj, lossis hnub tseem ceeb, yog tus lej Excel siv los suav hnub thiab sijhawm nkag mus rau hauv daim ntawv ua haujlwm. Tus naj npawb serial yog suav los ntawm manually lossis raws li cov qauv uas suav nrog hnub suav. Excel nyeem lub khoos phis tawj lub moos kom taug qab lub sijhawm uas tau dhau mus txij li hnub pib hnub pib.
Cov ntaub ntawv hauv phau ntawv qhia no siv rau Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, thiab Excel rau Mac.
Ob Lub Hnub Uas Muaj Cai
Los ntawm lub neej ntawd, cov qauv ntawm Excel uas khiav ntawm Windows khaws hnub tim raws li tus nqi sawv cev rau cov hnub tag nrho txij thaum ib tag hmo Lub Ib Hlis 1, 1900, ntxiv rau cov teev, feeb, thiab vib nas this rau hnub tam sim no.
Versions ntawm Excel uas khiav ntawm Macintosh computers default rau ib qho ntawm ob lub hnub tim nram qab no:
- Excel rau Mac versions 2019, 2016, thiab 2011: Lub sijhawm ua haujlwm hnub tim yog 1900 hnub system uas lav hnub sib raug zoo nrog Excel rau Windows.
- Excel 2008 thiab cov laus dua: Cov txheej txheem hnub qub pib thaum Lub Ib Hlis 1, 1904 thiab raug xa mus rau hnub tim 1904.
Txhua tus qauv ntawm Excel txhawb ob lub hnub tim thiab nws tuaj yeem hloov pauv ntawm ib qho mus rau lwm qhov.
Serial Number Piv txwv
Hauv xyoo 1900, tus lej xov tooj 1 sawv cev rau Lub Ib Hlis 1, 1900, 12:00:00 sawv ntxov thaum tus lej 0 sawv cev rau hnub tsis tseeb Lub Ib Hlis 0, 1900.
Hauv xyoo 1904, tus lej xov tooj 1 sawv cev rau Lub Ib Hlis 2, 1904, thaum tus lej 0 sawv cev rau Lub Ib Hlis 1, 1904, 12: 00: 00 a.m.
Times stored as Decimals
Sijhawm hauv ob lub tshuab raug khaws cia ua tus lej lej ntawm 0.0 thiab 0.99999, qhov twg:
- 0.0 is 00:00:00 (teev:minutes:seconds)
- 0.5 is 12:00:00 (12 p.m.)
- 0.99999 is 23:59:59
Qhia hnub thiab sijhawm hauv tib lub xovtooj hauv daim ntawv ua haujlwm, muab cov lej suav thiab lej ntawm tus lej.
Piv txwv li, hauv 1900 system, 12 teev tsaus ntuj. Lub ib hlis ntuj 1, 2016, yog serial tooj 42370.5 vim hais tias nws yog 42370 thiab ib nrab hnub (lub sij hawm muab khaws cia raws li ib feem ntawm ib tug tag nrho hnub) tom qab lub ib hlis ntuj 1, 1900. Ib yam li ntawd, nyob rau hauv 1904 system, tus naj npawb 40908.5 sawv cev rau 12 p.m. Lub ib hlis ntuj 1, 2016.
Serial Number Siv
Ntau qhov haujlwm uas siv Excel rau cov ntaub ntawv khaws cia thiab suav siv hnub thiab sijhawm hauv qee txoj kev. Piv txwv li:
- Ib txoj haujlwm ntev uas suav cov hnub ntawm hnub tam sim no thiab yav dhau los siv NETWORKDAYS muaj nuj nqi.
- Kev xam nyiaj qiv uas txiav txim siab hnub tom ntej uas siv EDATE muaj nuj nqi.
- Daim ntawv teev sijhawm uas suav lub sijhawm dhau los ntawm lub sijhawm pib thiab xaus, nrog rau cov teev, thiab sijhawm ua haujlwm ntxiv raws li qhov tsim nyog siv cov qauv uas ntxiv lossis rho tawm hnub thiab sijhawm.
- Lub sijhawm stamping ib daim ntawv ua haujlwm nrog hnub tim thiab lub sijhawm tam sim no nrog cov keyboard shortcuts uas nyeem tus lej tam sim no.
- Hloov kho hnub tim thiab lub sijhawm thaum twg ib daim ntawv ua haujlwm qhib lossis rov suav nrog cov haujlwm tam sim no thiab TODAY.
Tsuas yog ib hnub siv tau rau ib phau ntawv ua haujlwm. Yog tias hnub tim system rau phau ntawv ua haujlwm uas muaj cov hnub hloov pauv, cov hnub hloov pauv los ntawm plaub xyoos thiab ib hnub vim lub sijhawm sib txawv ntawm ob lub hnub tim.
Hloov qhov Default Date System
Txhawm rau teeb tsa hnub rau phau ntawv ua haujlwm hauv Excel khiav ntawm Windows PC:
- Qhib phau ntawv ua haujlwm hloov pauv.
- Xaiv File. Tsuas yog hauv Excel 2007, qhov twg koj xaiv lub Office khawm.
- Xaiv Options txhawm rau qhib Excel Options dialog box.
- Xaiv Advanced nyob rau sab laug tes ntawm lub dialog box.
-
Nyob rau hauv Thaum xam cov nqe lus no, xaiv lossis tshem tawm Siv 1904 hnub system checkbox.
Image - Xaiv OK txhawm rau kaw lub thawv sib tham thiab rov qab mus rau phau ntawv ua haujlwm.
Txhawm rau teeb tsa hnub rau phau ntawv ua haujlwm hauv Excel rau Mac:
- Qhib phau ntawv ua haujlwm hloov pauv.
- Xaiv qhov Excel menu.
- Xaiv Preferences los qhib Excel Preferences dialog box.
-
Nyob hauv cov qauv thiab cov npe, xaiv Calculation.
-
Nyob rau hauv Thaum Xam Cov Phau Ntawv Ua Haujlwm, xaiv lossis tshem tawm Siv 1904 hnub system checkbox.
Image - Kaw lub Excel Preferences dialog box.
Vim li cas Ob Hnub Ua Haujlwm?
PC versions of Excel (Windows thiab DOS operating systems) pib siv 1900 hnub system rau kev sib raug zoo nrog Lotus 1-2-3, qhov kev pab cuam nrov tshaj plaws nyob rau lub sijhawm.
Qhov teeb meem yog thaum Lotus 1-2-3 tsim, xyoo 1900 tau npaj ua xyoo leap thaum qhov tseeb tsis yog. Yog li ntawd, cov kauj ruam programming ntxiv yuav tsum tau kho qhov yuam kev. Cov qauv tam sim no ntawm Excel khaws 1900 hnub system rau kev sib raug zoo nrog cov ntawv ua haujlwm tsim nyob rau hauv cov ntawv dhau los ntawm qhov kev pab cuam.
Vim tias tsis muaj Macintosh version ntawm Lotus 1-2-3, thawj versions ntawm Excel rau Macintosh tsis tas yuav txhawj xeeb txog cov teeb meem kev sib raug zoo. Hnub tim 1904 tau raug xaiv los zam cov teeb meem programming ntsig txog qhov teeb meem 1900 uas tsis yog xyoo dhau los.
Ntawm qhov tod tes, nws tau tsim qhov teeb meem sib raug zoo ntawm cov ntawv ua haujlwm tsim hauv Excel rau Windows thiab Excel rau Mac. Qhov no yog vim li cas txhua yam tshiab ntawm Excel siv 1900 hnub system.
