Nomoro ea serial kapa letsatsi la serial ke palo eo Excel e e sebelisang ha ho baloa matsatsi le linako tse kenang leqepheng la lipampiri, ka letsoho kapa ka lebaka la litlhaloso tse amanang le lipalo tsa letsatsi.
Excel e bala oache ea tsamaiso ea k'homphieutha e le ho boloka tlaleho ea nako e fetileng ho tloha letsatsing la qala la tsamaiso ea letsatsi.
Mekhoa e 'meli ea Matsatsi a Letsatsi
Ka linako tsohle, liphetolelo tsohle tsa Excel tse tsamaisang tsamaiso ea Windows , boloka letsatsi e le letlotlo le emelang matsatsi a feletseng ho tloha bohareng ba mantsiboea ka la 1 January, 1900, hammoho le palo ea lihora, metsotso le metsotsoana bakeng sa letsatsi la kajeno.
Liphetolelo tsa Excel tse tsamaisang lik'homphieutheng tsa Macintosh li fetohile ho e 'ngoe ea litsamaiso tse peli tsa letsatsi.
- Ho tloha Excel 2011, mokhoa o sa fellang oa letsatsi ke mokhoa oa letsatsi la 1900 o tiisang hore letsatsi le lumellana le Excel bakeng sa Windows.
- Bakeng sa liphetolelo tsa Excel tsa 2008 le tsa pejana (Macintosh), tsamaiso ea letsatsi la ho qetela e qala ka la 1 January, 1904, 'me e bitsoa tsamaiso ea letsatsi la 1904 .
Liphetolelo tsohle tsa Excel ts'ehetso ea letsatsi le ts'ebetso le ho fetoha ho tloha tsamaiso e 'ngoe ho ea ho e' ngoe li etsoa habonolo ha li sebelisa likhetho tsa lenaneo.
Mehlala ea Serial Number
Lenaneong la 1900, nomoro ea 1 ea mohala e emela January 1, 1900, 12:00:00 hoseng ha palo ea 0 e emela letsatsi la bohata la January 0, 1900.
Tsamaiso ea 1904, nomoro ea 1 ea likarolo e emela January 2, 1904, ha nomoro ea 0 e emela January 1, 1904, 12:00:00 hoseng
Linako li bolokiloe e le lihlahisoa
Linako likarolong tsena ka bobeli li bolokiloe e le linomoro tsa morao pakeng tsa 0.0 le 0.99999, moo
- 0.0 ke 00:00:00 (lihora tse: metsotso: metsotsoana);
- 0.5 ke 12:00:00 (12:00);
- 0.99999 ke 23:59:59.
Ho bonts'a matsatsi le linako ka sele e le 'ngoe lethathamong la lipatlisiso, kopanya likarolo tse ngata tsa dipalo.
Ka mohlala, tsamaisong ea 1900, ka 12 mantsiboea ka la 1 January, 2016, ke serial number 42370.5 hobane ke 42370 le halofo matsatsi (linako li bolokiloe e le likaroloana tsa letsatsi le feletseng) ka mor'a la 1 January, 1900.
Ka mokhoa o ts'oanang, tsamaisong ea 1904, nomoro ea 40908.5 e emela ka 12 mantsiboea ka la 1 January, 2016.
Linomoro tsa Linomoro tsa Serial
Merero e mengata, kapa e mengata, e sebelisang Excel bakeng sa polokelo ea polokelo le lipalo, sebelisa matsatsi le linako ka tsela e itseng. Ka mohlala:
- Morero oa nako e telele o ka 'na oa hloka ho bala palo ea matsatsi pakeng tsa matsatsi a hona joale le a fetileng kapa ho tseba letsatsi le lengata haholo nakong e tlang le sebelisa mesebetsi e kang NETWORKDAYS le EDATE
- Timesheets e lekanya nako e fetileng pakeng tsa linako le ho qala le ho qetela, hammoho le lihora tse ngata, ke nako e fetang e hlokahalang ho sebelisa litlhaloso tse eketsang kapa tsa ho tlosa matsatsi le linako.
- Nako ea ho hatisa leqephe le letsatsi le nako ea morao tjena li ka etsoa ka mekhabiso ea li-keyboard e balang nomoro ea morao-rao .
Ho hlahisa letsatsi le bonts'oa nako kapa nako kapa nako ha leqephe la lipampiri le buloa kapa le khutlisetsoa morao ka mesebetsi ea SONA le ea TODAY .
Ke Hobane'ng ha Litsela Tse peli Tsa Letsatsi
Ka bokhutšoanyane, liphetoho tsa PC tsa Excel ( Windows le DOS tsamaiso ea ts'ebetso), qalong li sebelisitse tsamaiso ea letsatsi la 1900 ka lebaka la ho lumellana le Lotus 1-2-3 , lenaneo le tsebahalang haholo la spreadsheet ka nako eo.
Bothata ba sena ke hore ha Lotus 1-2-3 e bōptjoa, selemo sa 1900 se ne se hlophisitsoe ka selemo sa selemo, ha e le hantle e ne e se sona. Ka lebaka leo, lenaneo le eketsehileng le nka mehato e hlokahalang bakeng sa ho lokisa phoso.
Liphetolelo tsa morao-rao tsa Excel li boloka tsamaiso ea letsatsi la 1900 ka lebaka la ho lumellana le lipampiri tse entsoeng liphetolelong tse fetileng tsa lenaneo.
Kaha ho ne ho se na tlhahiso ea Macintosh ea Lotus 1-2-3 , liphetolelo tsa pele tsa Excel bakeng sa Macintosh ha lia ka tsa hlola li ameha ka litaba tse lumellanang le 'me tsamaiso ea letsatsi la 1904 e khethiloe ho qoba mathata a lenaneo a amanang le selemo sa 1900 se sa lekaneng.
Ka lehlakoreng le leng, e entse ts'ebetso e lumellanang pakeng tsa lipampiri tse entsoeng ka Excel bakeng sa Windows le Excel bakeng sa Mac, ke kahoo tsohle liphetolelo tse ncha tsa Excel li sebelisang tsamaiso ea letsatsi la 1900.
Ho fetola Sesebelisoa sa Letsatsi le sa Tsitsang
Tlhokomeliso : Tsamaiso e le 'ngoe feela ea letsatsi e ka sebelisoa bukeng ka' ngoe. Haeba letsatsi la letsatsi la buka ea mosebetsi e se e ntse e na le matsatsi a fetotsoe, matsatsi ao a fetoloa ke lilemo tse 'nè le letsatsi le le leng ka lebaka la phapang ea nako pakeng tsa litsamaiso tse peli tsa letsatsi tse boletsoeng ka holimo.
Ho beha tsamaiso ea letsatsi bakeng sa buka ea mosebetsi ho Excel 2010 le liphetolelo tse latelang:
- Bula kapa o fetisetsa bukeng ea mosebetsi ho fetoha;
- Tobetsa Fateng tab ho bula menu ea menu;
- Tobetsa ho Dikgetho ho menu ho bula lebokose la lihlooho tsa lebokose la Excel ,
- Tobetsa ho Ets'ele pele ka lehlakoreng le letšehali la lebokose la lebokose;
- Tlas'a Ha o bala karolo ena ea buka ea matsoho ka letsohong le letona, khetha kapa u hlakole lebokose la ho sebelisa letsatsi la 1904 la tsamaiso ea letsatsi ;
- Tobetsa OK ho koala lebokose la lebokose le ho khutlela bukeng ea mosebetsi.
Ho beha tsamaiso ea letsatsi bakeng sa buka ea mosebetsi Excel 2007:
- Bula kapa o fetisetsa bukeng ea mosebetsi ho fetoha;
- Tobetsa ho Button ea Office ho bula menu ea Office ;
- Tobetsa ho Dikgetho ho menu ho bula lebokose la lihlooho tsa lebokose la Excel ;
- Tobetsa ho Ets'ele pele ka lehlakoreng le letšehali la lebokose la lebokose;
- Tlas'a Ha o bala karolo ena ea buka ea matsoho ka letsohong le letona, khetha kapa u hlakole lebokose la ho sebelisa letsatsi la 1904 la tsamaiso ea letsatsi ;
- Tobetsa OK ho koala lebokose la lebokose le ho khutlela bukeng ea mosebetsi.