Lambar serial ko kwanan wata shine lambar da Excel ke amfani da shi wajen ƙayyade kwanakin da lokutan shiga cikin takardun aiki, ko dai da hannu ko kuma sakamakon sakamakon da ya shafi lissafin kwanan wata.
Excel ta karanta tsarin tsarin kwamfutar ta kwamfutar don kiyaye yadda yawancin lokaci ya ɓace tun lokacin kwanan wata na kwanan wata.
Kwanan Wata Kwanan Wata Kwanan Wata Kwanan Wata
Ta hanyar tsoho, duk sassan Excel da ke gudana kan tsarin tsarin Windows , adana kwanan azaman darajar da ke wakiltar adadin kwanaki cikakke tun daga tsakiyar Janairu 1, 1900, tare da adadin sa'o'i, minti, da kuma seconds don kwanan yau.
Ayyukan Excel da ke gudana kan kwamfutar kwakwalwa na Macintosh zuwa daya daga cikin kwanakin kwanakin biyu.
- Tun da Excel 2011, tsarin kwanan wata shi ne tsarin zamani na 1900 wanda ya tabbatar da kwanan wata tare da Excel don Windows.
- Don Excel 2008 da kuma versions na Excel (Macintosh) na baya, tsarin kwanan wata ya fara ranar 1 ga watan Janairu, 1904, kuma ana kiran shi tsarin tsarin 1904 .
Duk ƙa'idar Excel ta goyi bayan tsarin kwanan wata da sauyawa daga tsarin daya zuwa wancan yana iya sauƙin yin amfani da zaɓin shirin.
Lambar Serial Samfura
A cikin tsarin 1900, lambar serial 1 tana wakiltar Janairu 1, 1900, 12:00:00 na safe yayin da lambar ta 0 ta wakilci kwanan nan ranar da aka kashe ranar Janairu, 1900.
A cikin tsarin 1904, lambar serial 1 tana wakiltar ranar 2 ga watan Janairu, 1904, yayin da lambar 0 tana wakiltar Janairu 1, 1904, 12:00 am
Lokaci An Ajiye a matsayin Dima
Lokaci a cikin duka sassan biyu an adana a matsayin lambobi masu yawa tsakanin 0.0 da 0.99999, inda
- 0.0 ne 00:00:00 (hours: minti: seconds);
- 0.5 ne 12:00:00 (12 am);
- 0.99999 ne 23:59:59.
Don nuna kwanakin da lokuta a cikin tantanin salula a cikin takardun aiki, hada haɗin lamba da ƙayyadaddun nau'i na lamba.
Alal misali, a cikin tsarin 1900, 12 a ranar 1 ga Janairu, 2016, lambar serial ne 42370.5 domin yana da 42370 da rabi-rabi (lokutan an ajiye shi a matsayin ɓangarori na cikakke rana) bayan Janairu 1, 1900.
Hakazalika, a cikin tsarin 1904, lamba 40908.5 tana wakiltar 12 na yamma a ranar 1 ga Janairu, 2016.
Lambar Serial Ana amfani
Mutane da yawa, idan ba haka ba, ayyukan da suke amfani da Excel don ajiyar bayanai da lissafi, yi amfani da kwanakin da lokuta a wani hanya. Misali:
- Tsarin lokaci na tsawon lokaci yana iya buƙatar ƙidaya yawan kwanakin tsakanin kwanakin yanzu da kwanakin da suka gabata ko ƙayyade kwanan wata da yake da yawa a nan gaba ta amfani da ayyuka kamar NETWORKDAYS da EDATE
- Lokaci yana ƙididdige lokacin da ke tsakanin lokaci da farawa da kuma ƙarshen lokuta, da kuma lokuta, suna wuce lokaci kamar yadda ya kamata ta yin amfani da takamammen da za su kara ko rage musu kwanakin da lokutan.
- Lokaci lokacin zana aiki tare da kwanan wata da lokaci na yanzu za a iya yi tare da gajerun hanyoyi na keyboard wanda ke karanta lambar serial na yanzu .
Ana sabunta kwanan wata da / ko lokacin da aka nuna ko kuma lokacin a duk lokacin da aka bude wani aikin aiki ko a sake rubuta shi tare da ayyukan NOW da TODAY .
Me yasa tsarin kwanan nan guda biyu?
A taƙaice, tsarin PC na Excel ( Windows da DOS tsarin aiki), da farko sunyi amfani da tsarin tsarin 1900 domin kare kanka da daidaituwa tare da Lotus 1-2-3 , shirin da aka fi so a cikin layi.
Matsalar wannan ita ce, lokacin da aka halicci Lotus 1-2-3, an tsara shekara ta 1900 a matsayin shekara mai tsalle, lokacin da ba gaskiya bane. A sakamakon haka, ƙarin matakan shirye-shiryen da ake buƙatar ɗauka don gyara kuskure.
Hanyoyin Excel na yau suna kiyaye tsarin tsarin zamani na 1900 don kare kanka da dacewa da takardun aiki wanda aka tsara a cikin sassan da suka gabata.
Tun da babu wani Macintosh version na Lotus 1-2-3 , buƙatun farko na Excel don Macintosh bai buƙatar damuwa da al'amurra masu dacewa ba kuma an zaɓi tsarin tsarin 1904 don kauce wa matsalolin shirye-shiryen da suka danganci batun shekara ta 1900 ba.
A wani ɓangare kuma, ya haifar da batun daidaitawa a tsakanin takardun aiki da aka gina a Excel don Windows da Excel don Mac, wanda shine dalilin da yasa sababbin sassan Excel suke amfani da tsarin tsarin 1900.
Canza Kwanan wata Kwanan wata Sabunta
Lura : Za'a iya amfani da tsarin kwanan wata ɗaya ta littafi. Idan tsarin canzawa na kwanan wata da ya rigaya ya ƙunshi kwanakin, waɗannan kwanakin sun motsa ta shekaru hudu da rana ɗaya saboda bambancin lokaci tsakanin tsarin kwanan nan da aka ambata a sama.
Don saita tsarin kwanan wata don littafi mai aiki a Excel 2010 da kuma wasu sifofin baya:
- Bude ko sauya zuwa littafin da za a canza;
- Danna kan Fayil din shafin don buɗe menu na Fayil ;
- Danna Zaɓuɓɓuka a cikin menu don bude akwatin maganganun na Excel Zabuka ,
- Danna Ci gaba a cikin sashin hagu na akwatin maganganu;
- A karkashin A yayin da aka lissafta wannan sashin littafin a cikin hannun dama, zaɓi ko share amfani da akwati na tsarin kwangilar 1904 ;
- Danna Ya yi don rufe akwatin maganganu kuma komawa cikin littafin.
Don saita tsarin kwanan wata don littafin aiki a Excel 2007:
- Bude ko sauya zuwa littafin da za a canza;
- Danna kan Button Office don buɗe menu na Office ;
- Danna Zaɓuɓɓuka a cikin menu don buɗe akwatin maganganu na Excel Options ;
- Danna Ci gaba a cikin sashin hagu na akwatin maganganu;
- A karkashin A yayin da aka lissafta wannan sashin littafin a cikin hannun dama, zaɓi ko share amfani da akwati na tsarin kwangilar 1904 ;
- Danna Ya yi don rufe akwatin maganganu kuma komawa cikin littafin.