Ukwazi ukuthi singakanani isikhathi esidlulile phakathi kweminyaka emibili ethize kulula njengokususa izinombolo zabo, nokho, ezindaweni zokusebenza izimfuno zivame ukuba yinkimbinkimbi kakhulu. Ngakho, Akuvamile ukuthi uzithole udinga ukukhipha amadethi aphelele kudokhumenti ye-Excel.. Lolu hlelo luyisudi okuhloswe ngayo ukwenza zonke izinhlobo zemisebenzi yezibalo kanye nokususa izinsuku ezimbili nakho. Ngalowo mqondo, sizokukhombisa konke okudingeka ukwazi ukuze ukwenze futhi ukusebenzise kumaspredishithi akho.
Uma udinga ukwazi ukuthi zingaki izinsuku, izinyanga noma iminyaka edlulile phakathi kwezinsuku ezimbili, uze endaweni efanele ngoba sizokunikeza lonke ulwazi ukuze ulufeze ngemizuzwana nje..
Ungawasusa kanjani amadethi ku-Excel?
Ukukhipha amadethi kuwumsebenzi othi ku-Excel unikeze izindlela ezimbalwa zokuthola umphumela, nokho, ukuthi iyiphi ozoyithatha izoncika ekutheni sifuna ukuyibonisa kanjani.. Ngalo mqondo, uhlelo luyakwazi ukukhombisa izinsuku esezidlulile, izinyanga kanye neminyaka, nakuba ngokwehlukana. Uma ufuna ukubona ulwazi oluphelele, kuzodingeka usebenzise amaseli angu-3 ukuze ukhiqize umphumela ngamunye futhi kamuva, usebenzise ifomula yokuhlanganisa uchungechunge lwezinhlamvu. Kodwa-ke, i-Excel wuhlelo lapho amathuba evulekile futhi kunezindlela zokwakha amafomula asivumela ukuthi sibonise umphumela wokukhipha amadethi ngefomethi esiyifunayo.
Lapha sizobona izindlela ezilula nezifinyeleleka kakhulu zokuyifinyelela.
Ukukhishwa kwedethi eyisisekelo
Lena indlela elula yokukhipha izinsuku ku-Excel futhi imayelana nokukhipha, ukukhetha amaseli lapho amadethi okukhulunywa ngawo atholakala khona.. Ngale ndlela, konke okuzodingeka ukwenze okulandelayo:
- Chofoza kabili kuseli lapho ufuna khona umphumela.
- Faka uphawu lokulinganisa ( = ).
- Khetha idethi inombolo 1.
- Ifaka uphawu lokususa (-).
- Khetha idethi inombolo 2.
- Shaya u-Enter.
Lokhu kuzobuyisela inani lezinsuku ezidlulile phakathi kwamadethi womabili.. Kufanele kuqashelwe ukuthi inombolo yosuku 1 kufanele kube eyakamuva kakhulu, ukuze kutholwe isibalo esihle.
Ikhipha amadethi ngomsebenzi we-DATEDIF
Uma ufuna umsebenzi UMA KUSEKUDE kukhathalogi ye-Excel, cishe ngeke uyithole, nokho, isatholakala futhi iyasebenza. Umsebenzi wayo ukukhombisa ngokunembile umehluko phakathi kwezinsuku ezimbili, nethuba lokuchaza uma sifuna ivezwe ngezinsuku, iminyaka noma izinyanga. Ngale ndlela, uma ufuna ukuba nolwazi oluphelele mayelana nesikhathi esidlulile, kuzokwanela ukuthatha amaseli ama-3 ngokulandelana, elilodwa ngesilinganiso sesikhathi ngasinye.
I-syntax yale fomula ithi:
=DATEDIF(Usuku1,Usuku2)
Nokho, ngokungafani nesimo sangaphambilini, kumsebenzi we-DATEDIF sidinga inombolo yedethi 1 ukuze ibe indala kakhulu. Uma sikwenza ngenye indlela, uhlelo luzophonsa iphutha #¡NUM!
Ukuze ukhiphe amadethi nokuthi umphumela ukhonjiswe ngezinsuku, izinyanga neminyaka kufanele wenze lokhu okulandelayo:
- Chofoza kabili kuseli.
- Faka umsebenzi UMA KUSEKUDE futhi uvule abakaki.
- Chofoza inombolo yosuku 1 (endala kakhulu) bese ufaka ukhefana.
- Chofoza inombolo yosuku 2 (yakamuva kakhulu) bese ufaka ukhefana.
- Faka izimpawu zokucaphuna izinhlamvu d, y kanye no-m ezimelela izinsuku, iminyaka nezinyanga ngokulandelana.
- Vala abakaki.
- Shaya u-Enter.
Ngokohlobo lwencwadi oyifakile ekugcineni phakathi kwezingcaphuno, umphumela uzovezwa ngezinsuku, izinyanga noma iminyaka. Ngakho-ke, ungakwazi ukususa kalula izinsuku ku-Excel futhi wazi inani lesikhathi esidlulile phakathi kwamaphoyinti amabili athile ekhalendeni.
Isiphetho
Ukukhipha amadethi ku-Excel kuyinqubo ebalulekile okufanele wazi kunoma ubani osebenza ngedatha futhi odinga ukwenza izibalo zesikhathi.. Nakuba kungase kubonakale kuyinkimbinkimbi ekuqaleni, kulula kakhulu ukuyisebenzisa uma usuqonda izinto eziyisisekelo. Qaphela ukuthi indlela ngayinye esiyichazayo inemininingwane yayo futhi ukuyiqonda kuzoncika ekutholeni umphumela olungile.
Kubalulekile ukukhumbula ukuthi i-Excel isebenzisa uJanuwari 1, 1900 njengosuku lwayo oluyisisekelo, ngakho-ke kubalulekile ukukhumbula lokhu lapho ufaka izinsuku. Ngaphezu kwalokho, kuyadingeka ukwazi indlela yokufometha amaseli ukuze imiphumela ibonakale ngendlela esifuna ngayo.
Njengoba sesibonile, kunezindlela ezahlukene zokususa izinsuku ku-Excel, kusukela ekusebenziseni umsebenzi we-DATEDIF kuya ekubaleni okwenziwa ngesandla usebenzisa amafomula alula. Indlela ngayinye inezinzuzo nezinkinga zayo, ngakho-ke kubalulekile ukukhetha inketho evumelana nezidingo zakho. Khumbula, futhi, ukuthi unethuba lokuzijwayeza phakathi nomsebenzi wakho ngenqubo ngayinye ukuze ujwayelane nanoma iyiphi nokuthi lena indlela yakho eyinhloko yokukhipha izinsuku ku-Excel.