Zowonjezera za Nambala yamtundu ndi Tsiku lachidule mu Excel

Nambala yojambulidwa kapena tsiku lachidule ndi nambala yomwe Excel ikugwiritsira ntchito powerengera masiku ndi nthawi yowonjezera pa tsamba, kaya pamanja kapena chifukwa cha mayina okhudzana ndi kuwerengetsera tsiku.

Excel imawerenga mawonekedwe a makompyuta kuti iwonetsetse nthawi imene yadutsa kuyambira tsiku loyambira.

Machitidwe Awiri Otha Posachedwapa

Mwachisawawa, maofesi onse a Excel amene amayendetsa pawindo la Windows , asungire tsikuli ngati mtengo woimira masiku onse kuyambira pakati pa usiku January 1, 1900, kuphatikizapo nambala ya maola, maminiti, ndi masekondi kwa tsiku lomwelo.

Versions ya Excel yomwe imagwira pa makompyuta a Macintosh osasintha kukhala imodzi mwa machitidwe awiri.

• Kuchokera mu Excel 2011, kusakhulupirika kwadongosolo ndi dongosolo la 1900 lomwe limatsimikizira kuti tsikuli likugwirizana ndi Excel kwa Windows.
• Kwa Excel 2008 ndi kalembedwe za Excel (Macintosh), dongosolo lokhazikika la tsiku limayamba pa January 1, 1904, ndipo limatchedwa dongosolo la 1904 .

Mabaibulo onse a Excel othandizira masiku onse ndi kusintha kuchokera pa njira imodzi kupita kwina akugwiritsidwa ntchito mosavuta pogwiritsa ntchito pulogalamuyi.

Zitsanzo za Nambala Zakale

Mu dongosolo la 1900, nambala yoyamba ikuyimira January 1, 1900, 12:00:00 m'mawa ndipo nambala 0 ikuimira tsiku lopanda pake January 0, 1900.

Mu dongosolo la 1904, nambala yoyamba 1 imayimira January 2, 1904, pamene nambala 0 ikuimira January 1, 1904, 12:00:00 am

Nthawi Imasungidwa ngati Zoipa

Nthawi muzochitika zonsezi zimasungidwa ngati nambala ya chiwerengero pakati pa 0.0 ndi 0.99999, kumene

• 0.0 ndi 00:00:00 (maola: mphindi: masekondi);
• 0,5 ndi 12:00:00 (12 koloko);
• 0.99999 ndi 23:59:59.

Kuti muwonetse masiku ndi nthawi mu selo limodzi pa tsamba, phatikizani nambala ndi magawo akumaliza a nambala.

Mwachitsanzo, m'chaka cha 1900, 12 koloko pa January 1, 2016, ndi nambala ya 42370.5 chifukwa ndi 42370 ndi theka la masiku (nthawi zimasungidwa ngati magawo a tsiku lonse) pambuyo pa January 1, 1900.

Mofananamo, mu 1904, chiwerengero cha 40908.5 chikuyimira 12 koloko pa 1 January, 2016.

Zochita za Nambala Zakale

Ntchito zambiri, kapena sizinthu zambiri, zomwe zimagwiritsa ntchito Excel pofuna kusungirako deta ndi kuwerengetsera, gwiritsani ntchito masiku ndi nthawi mwanjira ina. Mwachitsanzo:

• Ntchito yayitali ya nthawi yayitali ingafunikire kuwerengera chiwerengero cha masiku pakati pa masiku amasiku ano ndi apitalo kapena kudziwa tsiku lomwe liripo masiku ambiri m'tsogolo pogwiritsira ntchito ntchito monga NETWORKDAYS ndi EDATE
• Timesheets amawerengera nthawi yomwe yapita nthawi ndi nthawi komanso nthawi, nthawi ndi nthawi, ndi nthawi yowonjezera yomwe ikufunika kugwiritsa ntchito malemba omwe akuwonjezera kapena kuchotsa masiku ndi nthawi.
• Nthawi yosindikiza pepala limodzi ndi tsiku ndi nthawi yeniyeni yowonjezera ikhoza kuchitidwa ndi zidule zam'bokosi zomwe mukuwerenga nambala yatsopano .

Kusintha tsiku lowonetsedwa ndi / kapena nthawi iliyonse pamene tsamba lamasamba likutsegulidwa kapena kukonzedweratu ndi ntchito MASIKU NDI MASIKU ano .

Chifukwa Chachiwiri Tsiku Liti?

Mwachidule, ma PC a Excel ( Windows ndi DOS machitidwe), poyamba amagwiritsa ntchito dongosolo la 1900 chifukwa chogwirizana ndi Lotus 1-2-3 , pulogalamu yotchuka kwambiri ya spreadsheet panthawiyo.

Vuto ndi izi ndikuti pamene Lotus 1-2-3 inalengedwa, chaka cha 1900 chinakonzedweratu ngati chaka chothawa, pamene kwenikweni sichinali. Zotsatira zake, mapulogalamu owonjezera amayenera kutengedwa kuti athetse vutolo.

Zotsatira zamakono za Excel zimasunga dongosolo la masiku 1900 chifukwa chogwirizana ndi malemba omwe apangidwa m'matembenuzidwe apitalo.

Popeza panalibe Macintosh ya Lotus 1-2-3 , Mabaibulo oyambirira a Excel Macintosh sanafunikire kukhala okhudzidwa ndi zofanana ndi chaka cha 1904 chisankho chinasankhidwa kupeŵa mavuto a pulogalamu yokhudzana ndi chaka cha 1900 chomwe sichinachitike.

Kumbali ina, idapanga mgwirizano pakati pa maofesi omwe anakhazikitsidwa ku Excel kwa Windows ndi Excel kwa Mac, ndipo chifukwa chake onse atsopano a Excel amagwiritsa ntchito dongosolo la 1900.

Kusintha Mchitidwe Wosasintha wa Tsiku

Zindikirani : Njira imodzi yokhayo ingagwiritsidwe ntchito pa bukhuli. Ngati tsiku loti likhale ndi buku la ntchito lomwe lili ndi masiku, lasinthidwa ndi zaka zinayi ndi tsiku limodzi chifukwa cha kusiyana kwa nthawi pakati pazinthu ziwiri zomwe zatchulidwa pamwambapa.

Kuyika ndondomeko ya tsiku la buku la Excel 2010 ndi zotsatira zina:

1. Tsegulani kapena kusinthanso ku bukhu la ntchito kuti lisinthidwe;
2. Dinani pa Fayilo Fayilo kuti mutsegule Fayilo menu;
3. Dinani pa Zosankha mu menyu kuti mutsegule Zokambirana za Excel Options ,
4. Dinani Patsogolo mu gulu lamanzere la bokosi;
5. Pansi pa Kuwerengera gawo ili lolembedwa mu dzanja lamanja, sankhani kapena kanizani kugwiritsa ntchito bokosi loyang'ana nthawi ya 1904 ;
6. Dinani OK kuti mutseke bokosilo ndikubweranso ku bukhuli.

Kuyika pulogalamu yamasiku a buku la Excel 2007:

1. Tsegulani kapena kusinthanso ku bukhu la ntchito kuti lisinthidwe;
2. Dinani ku Boma la Office kuti mutsegule menyu ya Office ;
3. Dinani pa Zosankha mu menyu kuti mutsegula Excel Options dialog box;
4. Dinani Patsogolo mu gulu lamanzere la bokosi;
5. Pansi pa Kuwerengera gawo ili lolembedwa mu dzanja lamanja, sankhani kapena kanizani kugwiritsa ntchito bokosi loyang'ana nthawi ya 1904 ;
6. Dinani OK kuti mutseke bokosilo ndikubweranso ku bukhuli.