Ukwazi ukuba lingakanani ixesha eligqithileyo phakathi kweminyaka emibini ethile kulula njengokuthabatha amanani abo, nangona kunjalo, kwiindawo zokusebenza iimfuno zihlala zinzima kakhulu. Ngoko, Ayiqhelekanga ukuzifumana ufuna ukuthabatha imihla epheleleyo kuxwebhu lwe-Excel.. Le nkqubo yisuite ejolise ekuqhubeni zonke iintlobo zemisebenzi yemathematika kwaye ukuthabatha iintsuku ezimbini akukho mehluko. Ngaloo ndlela, siza kukubonisa yonke into oyifunayo ukuze uyenze kwaye uyisebenzise kwi-spreadsheets zakho.
Ukuba ufuna ukwazi ukuba zingaphi iintsuku, iinyanga okanye iminyaka edlulileyo phakathi kwemihla emibini, ufikile kwindawo efanelekileyo kuba siza kukunika lonke ulwazi ukufezekisa kwimizuzwana embalwa..
Uyisusa njani imihla kwi-Excel?
Ukuthabatha imihla ngumsebenzi othi kwi-Excel unike iindlela ezininzi zokufikelela kwisiphumo, nangona kunjalo, ukuba yeyiphi enokuthi ithathwe iya kuxhomekeka kwindlela esifuna ukuyibonisa ngayo.. Ngale ndlela, inkqubo iyakwazi ukubonisa iintsuku ezidlulileyo, iinyanga kunye neminyaka, nangona ngokwahlukeneyo. Ukuba ufuna ukubona ulwazi olupheleleyo, kuya kufuneka uhlale iiseli ezi-3 ukuvelisa umphumo ngamnye kwaye kamva, uthathe ifomyula yokudibanisa umtya wabalinganiswa. Nangona kunjalo, i-Excel yiprogram apho amathuba avulekileyo kwaye kukho iindlela zokwakha iifomyula ezivumela ukuba sibonise umphumo wokuthatyathwa kwemihla kwifomathi esiyifunayo.
Apha siza kubona ezona ndlela zilula nezifikelelekayo zokuyifeza.
Ukuthabatha umhla osisiseko
Le yeyona ndlela ilula yokuthabatha imihla kwi-Excel kwaye imalunga nokuthabatha, ukukhetha iiseli apho imihla ekuthethwa ngayo ibekwe khona.. Ngale ndlela, konke kuya kufuneka ukwenze oku kulandelayo:
- Cofa kabini kwiseli apho ufuna isiphumo.
- Ngenisa uphawu olulinganayo ( = ).
- Khetha umhla inombolo ye1.
- Faka uphawu lothabatha (-).
- Khetha umhla inombolo ye2.
- Cofa u-Enter.
Oku kuya kubuyisela inani leentsuku ezidlulileyo phakathi kwale mihla yomibini.. Kufuneka kuqatshelwe ukuba inombolo yomhla 1 kufuneka ibe ngowona mva nje, ukuze ufumane inani eliqinisekileyo.
Ukuthabatha imihla kunye nomsebenzi we-DATEDIF
Ukuba ukhangela umsebenzi UKUBA UMHLA kwikhathalogu ye-Excel, awuzukuyifumana, nangona kunjalo, isafumaneka kwaye isebenza. Umsebenzi wayo ukubonisa ngokucacileyo umahluko phakathi kwemihla emibini, kunye nethuba lokuchaza ukuba sifuna ukuba ibonakaliswe ngeentsuku, iminyaka okanye iinyanga. Ngale ndlela, ukuba ufuna ukuba nolwazi olupheleleyo malunga nexesha elidlulileyo, kuya kukwanela ukuhlala iiseli ezi-3 ngokulandelelana, enye ngomlinganiselo ngamnye wexesha.
Isivakalisi sale fomula sithi:
=UMHLADIF(Umhla1,umhla2)
Nangona kunjalo, ngokungafaniyo kwimeko yangaphambili, kwi-DATEDIF umsebenzi sifuna inombolo yomhla 1 ukuba ibe ngowona mdala. Ukuba siyenza ngenye indlela, inkqubo iza kuphosa impazamo #¡NUM!
Ukwenza ukuthabatha imihla kwaye isiphumo siboniswe ngeentsuku, iinyanga kunye neminyaka kufuneka wenze oku kulandelayo:
- Cofa kabini kwiseli.
- Ngenisa umsebenzi UKUBA UMHLA kwaye uvule izibiyeli.
- Cofa kumhla wenombolo 1 (owona mdala) kwaye ufake isiphumlisi.
- Cofa kumhla wenombolo 2 (owona wakutshanje) kwaye ufake isiphumlisi.
- Faka kumanqaku ekowuteshini unobumba d, y kunye no m abamele iintsuku, iminyaka kunye neenyanga ngokulandelelanayo.
- Vala i-parenthesis.
- Cofa u-Enter.
Ngokohlobo lweleta oyifakileyo ekupheleni phakathi kweengcaphuno, isiphumo siya kuboniswa ngeentsuku, iinyanga okanye iminyaka. Ke, unokukhupha ngokulula imihla kwi-Excel kwaye wazi inani lexesha elidlulile phakathi kwamanqaku amabini athile kwikhalenda.
Isiphelo
Ukuthabatha imihla kwi-Excel yinkqubo ebalulekileyo yokwazi nabani na osebenza ngedatha kwaye kufuneka enze izibalo zexesha.. Nangona isenokubonakala intsonkothile ekuqaleni, kulula kakhulu ukuyisebenzisa xa uqonda iziseko. Qaphela ukuba indlela nganye esiyichazayo inezinto zayo kwaye ukuziqonda kuya kuxhomekeka ekufumaneni iziphumo ezichanekileyo.
Kubalulekile ukukhumbula ukuba i-Excel isebenzisa umhla woku-1 kaJanuwari 1900 njengomhla wayo wesiseko, ngoko ke kubalulekile ukukhumbula oku xa ufaka imihla. Ukongeza, kuyimfuneko ukwazi indlela yokufomatha iiseli ukuze iziphumo ziboniswe njengoko sifuna.
Njengoko sele sibonile, kukho iindlela ezahlukeneyo zokuthabatha imihla kwi-Excel, ukusuka ekusebenziseni umsebenzi we-DATEDIF ukuya ekubaleni ngesandla usebenzisa iifomyula ezilula. Indlela nganye ineengenelo kunye nokungona kwayo, ngoko ke kubalulekile ukukhetha ukhetho olulungele iimfuno zakho. Khumbula, kwakhona, ukuba unethuba lokuziqhelanisa ngexesha lomsebenzi wakho ngenkqubo nganye ukuze uqhelane nayo nayiphi na kwaye le yeyona ndlela yakho iphambili yokuthabatha imihla kwi-Excel.