Inombolo ye-serial okanye umhla we-serial yile nombolo eyenziwa ngu-Excel ekubaleni iintsuku kunye namaxesha angene kwiphepha lokusebenzela, ngokubhaliweyo okanye ngenxa yeziqulatho ezibandakanya izibalo zomhla.
I-Excel ifunda inkqubo yekhomputha yenkqubo yekhompyutha ukwenzela ukugcina umkhondo wexesha eliye laphela ukususela kumhla wokuqalisa komhla.
Iinkqubo ezimbini zeeNsuku eziNokwenzeka
Ngokungagqibekanga, zonke iinguqu ze-Excel ezisebenza kwi- Windows operating system, gcina usuku njengenani elimele inani leentsuku ezipheleleyo ukususela phakathi kobusuku ngoJanuwari 1, 1900, kunye neyure yeeyure, imizuzu kunye nemizuzwana yosuku lwangoku.
Iingcombolo ze-Excel ezisebenza kwiikhompyutheni ze-Macintosh zingagqibekanga kwisinye sezixhobo zomhla ezimbini.
- Ukususela kwi-Excel ka-2011, inkqubo yexesha elingagqibekanga yinkqubo yohlobo lwe- 1900 eqinisekisa ukuhambelana nomhla ne-Excel ye-Windows.
- I-Excel 2008 kunye neenguqu zokuqala ze-Excel (i-Macintosh), inkqubo yokuqalisa yokuqalisa iqala ngoJanuwari 1, 1904, kwaye ibizwa ngokuba yinkqubo yohlobo lwe- 1904 .
Zonke iinguqulelo zenkxaso ye-Excel zombini iinkqubo zosuku kunye nokutshintsha ukusuka kwinkqubo enye ukuya kwelinye kwenziwa ngokulula usebenzisa iinkqubo zenkqubo.
Imizekelo yeeNombolo
Kwiminyaka ye-1900, inombolo ye-serial ibonisa uJanuwari 1, 1900, ngo-12: 00 ntambama ngelixa inani le-0 limela umhla wokukhohlisa uJanuwari 0, 1900.
Kwindlela ye-1904, inombolo ye-serial ibonisa uJanuwari 2, 1904, ngelixa inombolo 0 ibonisa uJanuwari 1, 1904, ngo-12: 00 ntambama
Ixesha eligcinwe njengeSigxina
Amaxesha kwimizi mibini igcinwe njengeenombolo zokugqibela phakathi kwe-0.0 kunye ne-0.99999, apho
- I-0.0 ngu-00: 00: 00 (iiyure: imizuzu: imizuzwana);
- 0.5 nge 12:00:00 (12 pm);
- 0.99999 ngu 23:59:59.
Ukubonisa imihla kunye namaxesha kwiseli efanayo kwiphepha lokusebenzela, udibanise i-integer kunye nesahlulo sokugqibela senani.
Ngokomzekelo, kwinkqubo ye-1900, ngo-12 ntambama ngoJanuwari 1, 2016, inombolo ye-serial 42370.5 kuba i-42370 kunye neentsuku zesiqingatha (amaxesha agcinwe njengamaqhezu omhla opheleleyo) emva koJanuwari 1, 1900.
Ngokufanayo, kwinkqubo ye-1904, inombolo ye-40908.5 imele i-12 ntambama ngoJanuwari 1, 2016.
Ukusetyenziswa kweNombolo yeSerial
Uninzi, ukuba akuninzi, iiprojekthi ezisebenzisa i-Excel yokugcina idatha kunye nokubala, sebenzisa imihla kunye namaxesha ngandlela-thile. Umzekelo:
- Iprojekthi yexesha elide ingadinga ukubala inani leentsuku phakathi kwimihla yangoku kwaye idlulileyo okanye ufumane usuku oluninzi kwixesha elizayo usebenzisa imisebenzi efana ne-NETWORKDAYS kunye no- EDATE
- Ixesha lexesha lexesha libala ixesha elidlulileyo phakathi kwexesha kunye nokuqala nokuphela, kunye neeyure, zixesha elidlulileyo xa kudingekile usebenzisa iifomula ezongeza okanye zishiye iintsuku namaxesha.
- Ixesha lokutshintshela iphepha lokusebenzela kunye nomhla kunye nexesha langoku liyakwenziwa ngeendlela ezimfutshane zokufunda iifayile ezifunda inombolo ye-serial yangoku .
Ukuhlaziya umhla obonisiweyo kunye / okanye ixesha naluphi na iphepha lokusebenzela livuliwe okanye lilungiswa kwakhona NGEMINYE nemisebenzi ye- TODAY .
Zizathu Zini Zomhla WeeNkqubo?
Ngokufutshane, iinguqu zePC ze-Excel (iinkqubo ze- Windows kunye ne- DOS zokusebenza), ekuqaleni zasebenzisa inkqubo yohlobo lwe-1900 ngenxa yokuhambelana neLote 1-2-3 , iprogram ye-spreadsheet ethandwa kakhulu ngexesha.
Ingxaki ngolu hlobo kukuba xa uLotus 1-2-3 idalwe, unyaka we-1900 wawuqulunqwe njengonyaka wokuqhafaza, xa kwakungenjalo. Ngenxa yoko, amanyathelo enkqubo eyongezelelweyo ayimfuneko ukuba athathwe ukulungisa iphutha.
Iinguqulelo zangoku ze-Excel zigcina inkqubo yosuku lwe-1900 ngenxa yokuhambelana neesekhredithi ezenziwe kwiinguqulelo zangaphambilini zeprogram.
Ekubeni kwakungenayo inguqulelo ye-Macintosh yeLotus 1-2-3 , iinguqu zokuqala ze-Excel ze-Macintosh zazingadingeki zixhalabise ngemicimbi yokuhambelana kwaye inkqubo yohlobo lwe-1904 yonyulwa ukuba ikhuphe iingxaki zenkqubo ezihambelana no-1900.
Ngakolunye uhlangothi, lenze idibansi yokuhambelana phakathi kwamaphepha asetshenzisiweyo kwi-Excel ye- Windows kunye ne-Excel ye-Mac, yingakho zonke iinguqulelo ze-Excel zisebenzisa i-1900 system system.
Ukutshintshwa kweNkqubo yeDethi yokuPhatha
Qaphela : Inkqubo enye yosuku ingasetyenzwa kwincwadi nganye yomsebenzi. Ukuba isicwangciso somhla kwincwadi yokusebenzela esele iqulethe imihla iguquliwe, loo mihla iyaguquka ngeminyaka emine nangomnye owodwa ngenxa yokungafani kwexesha phakathi kweenkqubo ezimbini ezikhankanywe ngasentla.
Ukusetha inkqubo yosuku kwincwadi yokusebenzela kwi-Excel 2010 kunye neenguqulelo ezilandelayo:
- Vula okanye utshintshe kwincwadi yokusebenzela ukuba utshintshwe;
- Cofa kwifayile yefayile ukuvula imenyu yefayile ;
- Cofa kwiNketho kwimenyu ukuvula ibhokisi yencoko yebhokisi ye - Excel ,
- Cofa kwi- Advanced kwiqela lekhohlo lebhokisi yencoko;
- Ngaphantsi kwexesha Xa ubala le ncwadana yencwadi kwiphaneli lesandla sokunene, khetha okanye cima ifowuni yohlobo lwe-1904 yosuku lokuhlola;
- Cofa u-OK ukuvala ibhokisi yencoko kwaye ubuyele kwincwadi yokusebenzela.
Ukusetha inkqubo yosuku kwincwadi yokusebenzela kwi-Excel 2007:
- Vula okanye utshintshe kwincwadi yokusebenzela ukuba utshintshwe;
- Cofa kwi-Button ye-Office ukuvula imenyu ye- Office ;
- Cofa kwiNketho kwimenyu ukuvula ibhokisi yencoko yebhokisi ye- Excel ;
- Cofa kwi- Advanced kwiqela lekhohlo lebhokisi yencoko;
- Ngaphantsi kwexesha Xa ubala le ncwadana yencwadi kwiphaneli lesandla sokunene, khetha okanye cima ifowuni yohlobo lwe-1904 yosuku lokuhlola;
- Cofa u-OK ukuvala ibhokisi yencoko kwaye ubuyele kwincwadi yokusebenzela.