Uhlolojikelele lweNombolo yocingo kanye nosuku lwangaphakathi ku-Excel

Inombolo ye-serial noma idethi ye-serial yinombolo i-Excel isebenzisa ekubaleni izinsuku nezinkathi zangena ephepheni lokusebenzela, ngesandla noma ngenxa yemibandela ebandakanya izibalo zosuku.

I-Excel ifunda iwashi yesistimu yekhompyutheni ukuze ilandele isikhathi senani eliye laphela kusukela ngosuku lokuqala lusuku lwesistimu.

Izinhlelo Zosuku Lwezibili Ezibonakalayo

Ngokuzenzakalelayo, zonke izinguqulo ze-Excel ezigijima ohlelweni lwe - Windows , ligcina usuku njengenani elimelela inani lezinsuku ezigcwele kusukela phakathi kwamabili January 1, 1900, kanye nenombolo yamahora, imizuzu, nemizuzwana yosuku lwamanje.

Izilinganiso ze-Excel ezisebenzayo kumakhompyutha we-Macintosh zihlelekile kwesinye sezikhathi ezimbili zedethi.

• Kusukela ku-Excel 2011, uhlelo lokusungula usuku luyi-system ye- 1900 eqinisekisa ukuhambisana nosuku nge-Excel ye-Windows.
• Kwezinguqulo ze-Excel 2008 nezingaphambilini ze-Excel (i-Macintosh), uhlelo lwesikhathi oluzenzakalelayo luqala ngoJanuwari 1, 1904, futhi lubizwa ngokuthi uhlelo lwezinsuku ezingu - 1904 .

Zonke izinguqulo ze-Excel ukwesekwa kokubili izinhlelo zosuku futhi ukushintsha kusuka kwesinye isimiso kuya kwesinye kwenziwa kalula ngokusebenzisa izinketho zohlelo.

Izibonelo Zezinombolo Zenombolo

Kuhlelo lwe-1900, inombolo ye-serial 1 imelela uJanuwari 1, 1900, 12:00:00 ekuseni ngenkathi inombolo engu-0 imelela usuku lokukhohlisa uJanuwari 0, 1900.

Kuhlelo lwe-1904, inombolo ye-serial 1 imelela uJanuwari 2, 1904, kanti inamba 0 imelela uJanuwari 1, 1904, 12:00 ekuseni

Ama-Times agcinwe njengezinqununu

Izikhathi kuzo zombili izinhlelo zigcinwe njengezinombolo zamadesimali phakathi kuka-0.0 no-0.99999, lapho

• 0.0 ngu-00: 00: 00 (amahora: imizuzu: imizuzwana);
• 0.5 yi-12: 00: 00;
• 0.99999 ngu-23:59:59.

Ukuze ubonise izinsuku namaxesha esitokisini esifanayo kushidi lokusebenzela, hlanganisa izingxenye eziningi nezinombolo zesimanje.

Isibonelo, ohlelweni luka-1900, ngo-12: 00 ngoJanuwari 1, 2016, inombolo ye-serial 42370.5 ngoba i-42370 nezinsuku eziyi-half (izikhathi zigcinwe njengezingxenyana zosuku olugcwele) emva kukaJanuwari 1, 1900.

Ngokufanayo, ohlelweni luka-1904, inombolo engu-40908.5 imelela ngo-12: 00 ngoJanuwari 1, 2016.

Ukusebenzisa Izinombolo Zenombolo

Eziningi, uma kungenjalo, amaphrojekthi asebenzisa i-Excel yokugcina idatha nokubala, sebenzisa izinsuku nezinkathi ngendlela ethile. Ngokwesibonelo:

• Iprojekthi yesikhathi eside ingadingeka ukubala inani lezinsuku phakathi kwezinsuku zamanje nezedlule noma unqume usuku olunezinsuku eziningi esikhathini esizayo usebenzisa imisebenzi njenge-NETWORKDAYS no- EDATE
• Ama-Timesheet abala isikhathi esiphelile phakathi nesikhathi sokuqala nokuphela, kanye namahora, angaphezu kwesikhathi esidingekayo usebenzisa amafomu afaka noma asusa amadethi nezikhathi.
• Isikhathi esithinta ishidi lokusebenza nosuku namanje wamanje kungenziwa ngamashothikhathi wekhibhodi efunda inombolo ye-serial yamanje .

Ibuyekeza usuku olubonisiwe kanye / noma isikhathi noma nini lapho ishidi lokusebenzela livuliwe noma lihlelwa kabusha ngemisebenzi YENYAKA NAMANYE .

Kungani kusetshenziswa izinhlelo ezimbili zosuku?

Ngamafuphi, izinguqulo ze-PC ze-Excel (izinhlelo zokusebenza ze- Windows ne- DOS ), ekuqaleni zisebenzise uhlelo lwesikhashana lwe-1900 ukuze luhambisane no- Lotus 1-2-3 , uhlelo lwesipredishithi ethandwa kakhulu ngaleso sikhathi.

Inkinga ngalokhu yukuthi lapho uLotus 1-2-3 idalwa, unyaka we-1900 uhlelwe njengonyaka onyakazayo, lapho empeleni kwakungekho. Ngenxa yalokho, izinyathelo ezengeziwe zokuhlela zidinga ukuthathwa ukuze zilungiswe iphutha.

Izinguqulo zamanje ze-Excel zigcina uhlelo lwesikhashana lwe-1900 ngenxa yokuhambisana namaphepha okusebenzela adalwe izinguqulo zangaphambilini zesimiso.

Njengoba kwakungekho inguqulo ye-Macintosh ye- Lotus 1-2-3 , izinguqulo zokuqala ze-Excel ze-Macintosh akudingeki zikhathazeke ngezindaba ezihambisanayo futhi uhlelo losuku luka-1904 lukhethiwe ukugwema izinkinga zokuhlela ezihlobene nonyaka we-1900 ongeyena unyaka.

Ngakolunye uhlangothi, lwakhiqiza udaba lokuhambisana phakathi kwamashidi akhishwe ku-Excel ye- Windows ne-Excel ye-Mac, yingakho zonke izinguqulo ezintsha ze-Excel zisebenzisa uhlelo lwesikhashana lwe-1900.

Ukushintsha uhlelo lokuzenzakalela lusuku

Qaphela : Uhlelo olulodwa kuphela lusuku lungasetshenziswa kubhukwana ngalinye. Uma uhlelo lwamanje lwencwadi yokusebenzela oluvele luqukethe izinsuku luguqulwa, lezo zinsuku zishintsha iminyaka emine kanye nosuku olulodwa ngenxa yokwahlukana kwesikhathi phakathi kwezinhlelo ezimbili zedethi okukhulunywe ngenhla.

Ukusetha uhlelo lwesikhashana kubhuku lokusebenzela ku-Excel 2010 nezinguqulo zamuva:

1. Vula noma ushintshela kubhuku lokusebenzela ukuthi lishintshwe;
2. Chofoza kuthebhu yefayela ukuvula imenyu yefayela ;
3. Chofoza kuzinketho kwimenyu ukuvula ibhokisi lengxoxo ye- Excel ,
4. Chofoza ku- Okuthuthukisiwe kwipaneli lesokunxele lesibhokisi;
5. Ngaphansi kokubala lesi sigaba sencwadi yokusebenzela ngakwesokudla, khetha noma usule ibhokisi lokuhlola lesistimu yosuku lwe-1904 ;
6. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela encwadini yokusebenzela.

Ukusetha isistimu yosuku kubhuku lokusebenzela ku-Excel 2007:

1. Vula noma ushintshela kubhuku lokusebenzela ukuthi lishintshwe;
2. Chofoza kwi-Button ye-Office ukuvula imenyu ye- Office ;
3. Chofoza kuzinketho kwimenyu ukuvula ibhokisi lengxoxo ye- Excel ;
4. Chofoza ku- Okuthuthukisiwe kwipaneli lesokunxele lesibhokisi;
5. Ngaphansi kokubala lesi sigaba sencwadi yokusebenzela ngakwesokudla, khetha noma usule ibhokisi lokuhlola lesistimu yosuku lwe-1904 ;
6. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela encwadini yokusebenzela.