Lambarka taxan ama taariikhda taxanaha waa lambarka Excel uu ku isticmaalo xisaabinta taariikhda iyo wakhtiyada loo galiyay waraaqo shaqeed, mid ahaan manhaj ahaan ama natiijada qaababka ku lug leh xisaabinta taariikhda.
Excel wuxuu akhriyaa saacadda nidaamka kombiyuutarka si uu ula socdo xaddiga waqtiga ee laga soo bilaabo taariikhda taariikhda bilawga nidaamka.
Laba Nidaamyada Taariikhda Suurtogalka ah
By default, dhammaan versions of Excel ee ku ordi on nidaamka Windows operating, taariikhda taariikh ahaan u dhigo qiimaha matalaya tirada maalmaha buuxa tan iyo bartamihii Janaayo 1, 1900, iyo tirada saacadaha, daqiiqadaha, iyo daqiiqadaha loogu talagalay maanta.
Versions of Excel oo ka shaqeeya kombiyuutarada Macintosh ayaa ku xiran mid ka mid ah laba nidaamyo taariikheed.
- Tan iyo Excel 2011, nidaamka taariikhda taariikhda default waa habka taariikhda taariikhda 1900 kaas oo damaanad qaadaya taariikhda u dhiganta leh Excel ee Windows.
- Wixii Excel 2008 iyo noocyada hore ee Excel (Macintosh), nidaamka taariikhda taariikhda aasaasiga ahi wuxuu bilaabmaa Janaayo 1, 1904, waxaana loo yaqaan nidaamka taariikhda 1904 .
Dhamaan noocyada Excel waxay taageeraan labada nidaamyo taariikheed iyo isbedelka nidaamka halbeegga ah si fudud ayaa loo sameeyaa iyada oo la isticmaalayo ikhtiyaarka barnaamijka.
Tusaalooyinka Serial Number
Nidaamka 1900, lambarka taxanaha 1 wuxuu ka dhigan yahay Jeen 1, 1900, 12:00:00 am halka lambarka 0 uu matalayo taariikhda khiyaaliga ah Jannaayo 0, 1900.
Nidaamka 1904, lambarka taxanaha 1 wuxuu u taagan yahay Janaayo 2, 1904, halka lambarka 0 uu u dhigan yahay Janawari 1, 1904, 12:00:00 am
Wakhtiyada loo kaydiyay sida Decimals
Waqtiyada labadaba waxaa lagu kaydiyaa tirooyinka jajab tobanle inta u dhaxaysa 0.0 iyo 0.99999, halkaa
- 0.0 waa 00:00:00 (saacado: daqiiqo: ilbiriqsi);
- 0.5 waa 12:00:00 (12 galabnimo);
- 0.99999 waa 23:59:59.
Si aad u muujiso taariikhaha iyo wakhtiyada unugyada isku midka ah ee waraaqaha shaqada, isku dar qeybta tirada iyo tirada boqolleyda.
Tusaale ahaan, nidaamka 1900, 12ka duhurnimo January 1, 2016, waa lambarka taxan 42370.5 maxaa yeelay waa 42370 iyo maalmo badh (waqtiyada ayaa lagu kaydiyaa jajabyada maalin buuxda) kadib Jeenawari 1, 1900.
Sidoo kale, nidaamka 1904, lambarka 40908.5 wuxuu u taagan yahay 12 pm 1da Janaayo, 2016.
Nambarka Calaamadaha
Dad badan, haddii aysan ahayn, mashaariicda isticmaala Excel ee kaydinta xogta iyo xisaabinta, waxay isticmaalaan taariikhaha iyo waqtiyada qaarkood. Tusaale ahaan:
- Mashruuca muddada dheer waxaa laga yaabaa inuu u baahdo inuu tiriyo maalmaha maalmaha u dhaxeeya waqtigan iyo taariikhda la soo dhaafay ama go'aaminaya taariikh maalmo badan ah mustaqbalka iyadoo la adeegsanayo hawlaha sida NETWORKDAYS iyo EDATE
- Timesheets ayaa xisaabiya wakhtigii ka soo wareegay bilawga iyo bilawga iyo dhammaadka wakhtiga, iyo weliba saacadaha, waa wakhti dheeraad ah marka loo baahdo iyadoo la adeegsanayo hababka lagu daro ama kala gooyo taariikhaha iyo waqtiyada.
- Waqtiga shaabadaynta waraaqaha leh taariikhda iyo wakhtiga hadda la qaban karo waxaa la samayn karaa maab-dhiska gaaban ee akhriya lambarka taxan ee hadda .
Soo cusbooneysiinta taariikhda la soo bandhigay iyo / ama waqti kasta mar kasta oo waraaq looqoro la furo ama dib loogu celiyo hawlaha NOW iyo TODAY .
Waa maxay sababta Labada Taariikhda Date?
Si kooban, PC versions of Excel (Nidaamyada hawlgalka Windows iyo DOS ), markii hore ayaa la isticmaalay nidaamka taariikhda 1900 si ay ula qabsadaan loona soo koobi karo Lotus 1-2-3 , barnaamijka ugu caansan ee barnaamijka.
Dhibaatada tan la mid ah waa markii la abuuray Lotus 1-2-3 , sanadka 1900 ayaa la qorsheeyay sida sanadka soo noqnoqda, marka dhab ahaantii aysan ahayn. Natiijo ahaan, tallaabooyin dheeraad ah oo barnaamijka loo baahan yahay in la qaado si loo saxo qaladka.
Qoraallada hadda jira ee Excel waxay haysaa nidaamka taariikhda 1900 si ay ula jaan-qaadaan waraaqaha shaqada ee laga sameeyay barnaamijyada hore.
Maadaama aysan jirin Macintosh version ee Lotus 1-2-3 , qaababka hore ee Excel ee Macintosh uma baahnayn in ay ka walwalaan arrimaha la qabsashada iyo nidaamka taariikhda 1904 ayaa loo doortay si looga fogaado dhibaatooyinka barnaamijka ee la xiriira 1900 ee aan sanadka soo xaadirin.
Dhanka kale, waxay abuurtay arrin la isku waafaqsan yahay waraaqaha shaqada ee loo sameeyay Excel ee Windows iyo Excel ee Mac, taas oo ah sababta dhammaan noocyada cusub ee Excel isticmaalaan nidaamka taariikhda 1900.
Bedelida Habka Date Date
Fiiro gaar ah : Hal nidaam taariikh ayaa loo isticmaali karaa halkii buug-shaqo. Haddii nidaamka taariikhda ee buug-shaqo-u-yaal oo horayba u dhacay taariikhda isbeddelka, taariikhahaasi waxay ku wareegayaan afar sano iyo hal maalin sababtoo ah farqiga u dhexeeya labada nidaamka taariikheed ee kor ku xusan.
Si aad u dejiso nidaamka taariikhda buug-hawleedka ee Excel 2010 iyo wixii ka dambeeya:
- Furan ama u beddeli buugga shaqada si loo baddalo;
- Riix tabarka Faylka si aad u furto File menu;
- Riix ' Options' ee menu si aad u furto sanduuqa xulasho ee Excel ,
- Ku dhaji horumarsan ee guddi-bidix ee sanduuqa wada-hadalka;
- Marka la xisaabinayo qaybta buuggan ee buug -gacmeedka midigta, dooro ama nadiifi Isticmaalka nidaamka taariikhda taariikhda taariikhda 1904 ;
- Guji OK si aad u xirto sanduuqa wada hadalada oo ku soo celi buugga hawlgalka.
Si aad u dejiso nidaamka taariikhda buug-hawleedka ee Excel 2007:
- Furan ama u beddeli buugga shaqada si loo baddalo;
- Guji Xafiiska Dameerka si aad u furto Xafiiska Office ;
- Riix ' Options' ee menu si aad u furto sanduuqa xulasho ee Excel ;
- Ku dhaji horumarsan ee guddi-bidix ee sanduuqa wada-hadalka;
- Marka la xisaabinayo qaybta buuggan ee buug -gacmeedka midigta, dooro ama nadiifi Isticmaalka nidaamka taariikhda taariikhda taariikhda 1904 ;
- Guji OK si aad u xirto sanduuqa wada hadalada oo ku soo celi buugga hawlgalka.