Ukuze wenze imisebenzi ethile ku-Excel, udinga ukunquma ukuthi zingaki izinsuku ezidlulile phakathi kwezinsuku ezithile. Ngenhlanhla, uhlelo lunamathuluzi angaxazulula le nkinga. Ake sibheke ukuthi yiziphi izindlela ongabala ngazo umehluko we-Excel.
Ukubalwa kwezinsuku
Ngaphambi kokuthi uqale ukusebenza nezinsuku, udinga ukufometha amaseli wale fomathi. Ezimweni eziningi, lapho ufaka iqoqo elifana nosuku, iseli ngokwalo liyabuyiselwa. Kepha kungcono ukukwenza ngesandla ukuze uzivikele ezingozini ezimangazayo.
- Khetha isikhala sephepha ohlela ukwenza kulo izibalo. Qhafaza kwesokudla kukhetho. Imenyu yokuqukethwe icushiwe. Kuyo, khetha into "Ifomethi yeseli ...". Ngenye indlela, ungathayipha isinqamuleli sekhibhodi kwikhibhodi I-Ctrl + 1.
- Iwindi lokufometha liyavula. Uma ukuvulwa kungenzekanga kuthebhu "Inombolo"khona-ke kufanele ungene kuwo. Ebhulokini lamapharamitha "Amafomethi ezinombolo" beka inkinobho eshintshiwe Usuku. Engxenyeni engakwesokudla yewindi, khetha uhlobo lwedatha esizosebenza nalo. Ngemuva kwalokho, ukulungisa izinguquko, chofoza inkinobho "Kulungile".
Manje yonke imininingwane ezotholakala kumaseli akhethiwe, uhlelo luzolwazisa njengosuku.
Indlela yoku-1: ukubalwa okulula
Indlela elula ukubala umehluko wezinsuku phakathi kwezinsuku usebenzisa ifomula evamile.
- Sibhala ngamaseli ahlukile ebanga ledethi elifomethiwe, umehluko phakathi kwalokhu okudingeka kubalwe.
- Khetha iseli lapho umphumela uzokhonjiswa khona. Kufanele isethwe kufomethi evamile. Isimo sokugcina sibaluleke kakhulu, ngoba uma ifomethi yosuku ikulesi seli, khona-ke kulokhu umphumela uzobukeka "dd.mm.yy" noma okunye, okuhambelana nale fomethi, okungumphumela ongalungile wezibalo. Isimo samanje seseli noma ibanga singabukwa ngokusiqokomisa kuthebhu "Ikhaya". Ebhokisini lamathuluzi "Inombolo" kunenkambu lapho le nkomba ikhonjiswa khona.
Uma inenani ngaphandle kwalokho "Okujwayelekile", bese kuleli cala, njengesikhathi esedlule, sisebenzisa imenyu yokuqukethwe siqala iwindows yokufometha. Kuyo kuthebhu "Inombolo" setha uhlobo lwefomethi "Okujwayelekile". Chofoza inkinobho "Kulungile".
- Esitokisini esisetshenziswe ifomathi ejwayelekile, beka uphawu "=". Chofoza kuseli lapho khona kamuva kwezinsuku ezimbili (ukuphela). Okulandelayo, chofoza kusithonjana sekhibhodi "-". Ngemuva kwalokho, khetha iseli eliqukethe usuku langaphambilini (qala).
- Ukuze ubone ukuthi singakanani isikhathi esidlulile phakathi kwalezi zinsuku, chofoza inkinobho Ngena. Umphumela uzokhonjiswa kuseli elifomethiwe ngefomethi evamile.
Indlela yesi-2: Umsebenzi wokulinganisa
Ungasebenzisa futhi umsebenzi okhethekile ukubala umehluko ngezinsuku. ISANDLA. Inkinga ukuthi ayikho ohlwini lwama-Wizadi Wemisebenzi, ngakho-ke kufanele ufake ifomula ngesandla. I-syntax yayo imi ngolu hlobo:
= DATE (qala_ usuku; ukuphela_ kosuku; iyunithi)
"Iyunithi" - Lesi yifomethi lapho umphumela uzokhonjiswa khona kuseli elikhethiwe. Uhlamvu lapho amayunithi umphumela uzobuyiselwa kuwo kuya ngokuthi yiluphi uhlamvu oluyofakwa kule pharamitha:
- "y" - iminyaka egcwele;
- "m" - izinyanga ezigcwele;
- "d" - izinsuku;
- "YM" - umehluko ezinyangeni;
- "MD" - umehluko ngezinsuku (izinyanga nezinyanga azinakwa);
- I- “YD” - umehluko ngezinsuku (iminyaka ayibhekwa).
Njengoba sidinga ukubala umehluko ngenani lezinsuku phakathi kwezinsuku, ikhambi elilungile kakhulu kungaba ukusebenzisa inketho yokugcina.
Kufanele futhi unake ukuthi, ngokungafani nendlela esetshenziswa ifomula elula echazwe ngenhla, lapho usebenzisa lo msebenzi, usuku lokuqala kufanele lube kwindawo yokuqala, futhi usuku lokuphela kufanele lube ngolwesibili. Ngaphandle kwalokho, ukubalwa kuzobe kungalungile.
- Sibhala ifomula esitokisini esikhethiwe, ngokwes syntax sayo esichazwe ngenhla, nedatha esemqoka ngendlela yosuku lokuqala nokuphela.
- Ukuze wenze ukubala, cindezela inkinobho Ngena. Ngemuva kwalokho, umphumela, ngendlela yenombolo ekhombisa inani lezinsuku phakathi kwezinsuku, zizokhonjiswa kuseli elicacisiwe.
Indlela 3: Bala Izinsuku Zokusebenza
Ku-Excel, kungenzeka futhi ukubala izinsuku zokusebenza phakathi kwezinsuku ezimbili, okungukuthi, ngaphandle kwezimpelasonto kanye namaholide. Ukuze wenze lokhu, sebenzisa umsebenzi IZINJONGO. Ngokungafani nesitatimende esedlule, sikhona ohlwini lwama-Wizards Wemisebenzi. I-syntax yalomsebenzi imi kanje:
= NET (qala_ usuku; ukuphela_ kosuku; [amaholide])
Kulomsebenzi, iziphikiso eziyinhloko ziyefana no-opharetha ISANDLA - usuku lokuqala nokuphela. Ngaphezu kwalokho, kunengxabano ongayikhetha. "Amaholide".
Esikhundleni salokho, kufanele usebenzise izinsuku zamaholide womphakathi, uma akhona, zesikhathi esimboziwe. Umsebenzi ubala zonke izinsuku zobubanzi obucacisiwe, ngaphandle kweMigqibelo, amaSonto, kanye nalezozinsuku ezingezwe ngumsebenzisi kwingxabano "Amaholide".
- Khetha iseli okuzotholakala kulo umphumela wokubala. Chofoza inkinobho "Faka umsebenzi".
- Umsebenzi Wizard uyavula. Esigabeni "Uhlu oluphelele lwe-alfabhethi" noma "Usuku nesikhathi" ngifuna into "CHISTRABDNI". Khetha bese uchofoza inkinobho. "Kulungile".
- Iwindi lokuphikisana ngomsebenzi liyavula. Faka usuku lokuqala nokuphela kwesikhathi, kanye nezinsuku zamaholide, uma akhona, emasimini afanele. Chofoza inkinobho "Kulungile".
Ngemuva kokukhwabanisa okungenhla, inani lezinsuku zokusebenza zesikhathi esinqunyelwe lizoboniswa kuseli elikhethwe ngaphambilini.
Isifundo: Umsebenzi Wizard e-Excel
Njengoba ukwazi ukubona, i-Excel ihlinzeka umsebenzisi wayo ngethuluzi elilungele ukubala inani lezinsuku phakathi kwezinsuku ezimbili. Ngaphezu kwalokho, uma udinga ukubala umehluko ngezinsuku, inketho engcono kakhulu kungaba ukusebenzisa ifomula yokususa elula, kunokuba usebenzise umsebenzi ISANDLA. Kepha uma udinga, ngokwesibonelo, ukubala inani lezinsuku zokusebenza, khona-ke umsebenzi uzokusiza NETWORKS. Okusho ukuthi, njengokujwayelekile, umsebenzisi kufanele anqume ngethuluzi lokufeza ngemuva kokuthi esethe umsebenzi othile.
