Chirongwa cheNhamba yeSerial uye Serial Date muExcel

Nhamba ye serial kana seried date ndiyo nhamba iyo Excel inoshandisa mukuverenga mazuva uye nguva dzakapinda mupepa rekushandura, zvinyorwa kana kuti semugumisiro wezvinyorwa zvine chokuita nekuverenga kwemazuva.

Excel inoverenga iyo kombiyuta yemaawa yehurongwa kuitira kuchengeta nhamba yehuwandu hwekufamba kwenguva kubvira musi wekutanga musi wezuva.

Maviri Mazuva Anogona Kuitika

Nokusingaperi, zvese zvinyorwa zveExcel zvinoshandisa paWindows operating system, chengetedza zuva senhamba inomiririra nhamba yezuva rakakwana kubva pakati pousiku January 1, 1900, pamwe chete nhamba yeawa, maminitsi, nemaminitsi ezuva ranhasi.

Zvinyorwa zveExcel iyo inotanga pamakombiyuta eMacintosh kusinganzwisisi kune imwe yezvigadziro zvezuva.

• Kubvira paExcel 2011, iyo yakaipa zuva system ndiyo ye 1900 system system iyo inofunga kuti zuva rinoenderana neExpcel yeWindows.
• Kune Excel 2008 uye zvekare zvekare zveExcel (Macintosh), kushandiswa kwezuva rinotanga kunotanga musi waJanuary 1, 1904, uye kunonzi inonzi 1904 zuva rekuita .

Zvose shanduro dzeEexcel dzinotsigira zuva rekugadzirisa zuva uye kushanduka kubva kune imwe nzira kuenda kune imwe zvinoshandiswa nyore nyore kushandisa sarudzo dzarongwa.

Serial Number Mienzaniso

Mumutambo we1900, nhamba ye serial inomiririra January 1, 1900, 12:00:00 am asi nhamba 0 inomiririra zuva risingafungi musi waJanuary 0, 1900.

Mune 1904 system, nhamba ye serial inomiririra musi waJanuary 2, 1904, asi nhamba 0 inomirira January 1, 1904, 12:00:00 am

Nguva Dzakachengetwa Sezvokudya

Nguva muzvikamu zvose zviri kuchengetwa semadhora ekupedzisira pakati pe 0.0 ne 0.99999, kupi

• 0.0 is 00:00:00 (maawa: maminitsi: masekondi);
• 0.5 is 12:00:00 (12 pm);
• 0.99999 is 23:59:59.

Kuti uratidze mazuva uye nguva mune imwe sero mune pepa rekushanda, shandisai integer uye zvikamu zvepakati zvechiverengero.

Somuenzaniso, mugore ra1900, 12 pm musi waJanuary 1, 2016, iri serial nhamba 42370.5 nokuti 42370 nehafu yenguva (nguva dzinochengeterwa sezvikamu zvezuva rose) mushure meJanuary 1, 1900.

Saizvozvowo, muna 1904, nhamba 40908.5 inomiririra 12 masikati munaJanuary 1, 2016.

Serial Number Uses

Zvizhinji, kana zvisingaiti, mapurogiramu anoshandisa Excel yekuchengetedza deta uye kuverenga, shandisa mazuva uye nguva neimwe nzira. Semuyenzaniso:

• Yenguva refu purogiramu inogona kudikanwa kuverenga nhamba yemazuva pakati pemazuva ano uye apfuura kana kusarudza zuva rine mazuva akawanda munguva yemberi uchishandisa mabasa akadai seNETWORKDAYS uye EDATE
• Timesheets vanoverenga nguva yakapera pakati pekutanga uye nguva yekupedzisira, uyewo maawa, ndiyo nguva yakawedzerwa sezvinodiwa uchishandisa mazano anowedzera kana kubvisa nguva nemazuva.
• Nguva inopedzisa pepa rekuita nezuva uye nguva iripo ikozvino inogona kuitwa nemidhecheni yebhobhoyo inoverenga nhamba ye serial ino .

Kudzokorora zuva rakaratidzwa uye / kana nguva chero pese pepa rekushandura rakazarurirwa kana kurongedzwa neZVO uye NEMHANYA mabasa.

Nei Tichifanira Kusangana Nhasi?

Nenguva pfupi, PC dzeExcel ( Windows neDOS system) dzinotanga kushandiswa panguva ye 1900 nokuda kwekuenderana neLotus 1-2-3 , purogiramu yepadheseti yakakurumbira panguva iyoyo.

Dambudziko neizvi nderokuti kana Lotus 1-2-3 yakasikwa, gore ra1900 rakarongerwa segore rekutsvaga, apo chaizvoizvo raisava. Somugumisiro, kuwedzera kwezvirongwa zvinotora zvinoda kutorwa kuti zvigadzirise kukanganisa.

Current versions of Excel rinochengetedza zuva rekare ra1900 nokuda kwekuenderana nemashandi ekugadzirwa kwekare mumashanduro apfuura epurogiramu.

Sezvo pakanga pasina Macintosh version yeLotus 1-2-3 , mavhesi okutanga eExcel for Macintosh aisafanira kuve nehanya nehutano hwehutano uye 1904 zuva remasikati rakasarudzwa kuti rirege matambudziko ekugadzirisa akaenzana negore re1900 risati rapera.

Kune rumwe rutivi, yakagadzira kuwirirana kwepakati pakati pebasa rakagadzirwa muExcel for Windows neExcel for the Mac, ndicho chikonzero nei zvitsva zvese zveExpcel zvichishandisa hurongwa hwemazuva 1900.

Kushandura Dhiyo Dhizha Dhizha

Cherechedza : Inongo imwe chete yezuva inogona kushandiswa nebhuku rimwe nerimwe rebhuku. Kana zuva rekushandisa rebhuku rebasa iro ratova nemasikati rakashandurwa, zuva idzodzo rinoshandiswa nemakore mana uye rimwe zuva nekuda kwenguva yakasiyana pakati pemazuva maviri ehurongwa hunotaurwa pamusoro apa.

Kugadzirisa hurongwa hwezuva rebhuku rebhuku muExpcel 2010 uye zvinyorwa zvekare:

1. Vhura kana kushandura kubhuku rebasa kuti richinje;
2. Dzvanya paDhiyabhorosi tab kuti uzarure Firimu menyu;
3. Dzvanya pane Zvimwe zviri mu menyu kuti uzarure Excel Options dialog box ,
4. Dzvanya paZvikudziridza muruboshwe-jongwe rebhokisi rebhokisi;
5. Pasi paAkaverenga chikamu chebhuku rino mubhuku rekurudyi, sarudza kana tsvina Ushandise 1904 zuva system check box;
6. Dhura OK kuti uvhare bhokisi rebhokisi uye dzokera kubhuku rebhuku.

Kugadzirisa hurongwa hwezuva rebhuku rebhuku muExcel 2007:

1. Vhura kana kushandura kubhuku rebasa kuti richinje;
2. Dzvanya paIfisi Button kuti uzarurire Office menu;
3. Dzvanya pane Zvimwe zviri mu menyu kuti uzarure Excel Options dialog box;
4. Dzvanya paZvikudziridza muruboshwe-jongwe rebhokisi rebhokisi;
5. Pasi paAkaverenga chikamu chebhuku rino mubhuku rekurudyi, sarudza kana tsvina Ushandise 1904 zuva system check box;
6. Dhura OK kuti uvhare bhokisi rebhokisi uye dzokera kubhuku rebhuku.