Ukuze wenze imisebenzi ethile ku-Excel, udinga ukucacisa ukuthi zingaki izinsuku ezidlule phakathi kwezinsuku ezithile. Ngenhlanhla, lolu hlelo lunamathuluzi angakwazi ukuxazulula le nkinga. Ake sithole ukuthi ungabala kanjani umehluko wosuku ku-Excel.
Ibala inani lezinsuku
Ngaphambi kokuba uqale ukusebenza ngezinsuku, udinga ukufometha amaseli ale fomethi. Ezimweni eziningi, uma isethi yezinhlamvu ezifana nosuku ingenisiwe, iseli ngokwalo liguquliwe. Kodwa kungcono ukukwenza ngesandla ukuze uziqinisekise ngokumelene nezinselele.
- Khetha isikhala sekhasi ohlela ukwenza izibalo. Chofoza inkinobho yesokudla yegundane ekukhethweni. Imenyu yenkathi ivuliwe. Kulo, khetha into "Ifomethi yeselula ...". Ngaphandle kwalokho, ungathayipha kusinqamuleli sekhibhodi Ctrl + 1.
- Iwindi yokufometha ivula. Uma kuvulwa kungekho kuthebhu "Inombolo"bese ungena kuwo. Ku-block parameter "Amafomu Amanani" setha inkinobho ukuma "Usuku". Ngakwesokudla kwefasitela, khetha uhlobo lwedatha ozosebenza ngalo. Ngemuva kwalokho, ukulungisa izinguquko, chofoza inkinobho. "Kulungile".
Manje yonke idatha ezobe iqukethe amaseli akhethiwe, uhlelo luzoqaphela njengosuku.
Indlela 1: Ukubalwa Okulula
Indlela elula yokubala umehluko ezinsukwini eziphakathi kwezinsuku kunomsoco olula.
- Sibhala ebangeni ledethi elenziwe efomini elithile, umehluko phakathi kokufunayo.
- Khetha iseli lapho umphumela uzoboniswa khona. Kufanele ibe nefomethi evamile. Isimo sokugcina sibaluleke kakhulu, ngoba uma kunesimo samanje kule seli, khona-ke umphumela uzoba "dd.mm.yy" noma enye, ehambisana nale fomathi, okungumphumela ongalungile wokubala. Ifomethi yamanje yamaseli noma ububanzi ingabonwa ngokuyikhetha kuthebhu "Ikhaya". Ebhokisini lamathuluzi "Inombolo" yinkambu lapho lesi sibonakaliso siboniswa khona.
Uma inenani ngaphandle koku "Jikelele"khona-ke kulokhu, njengasesikhathini esidlule, ukusebenzisa imenyu yesimo sendawo siqala ifasitela lokufometha. Kuyo kuthebhu "Inombolo" setha ukubuka kwefomethi "Jikelele". Sicindezela inkinobho "Kulungile".
- Esikhathini esakhiwe esakhiweni ngaphansi kwesakhiwo jikelele esibeka uphawu "=". Chofoza kuseli lapho kamuva kwezinsuku ezimbili zitholakala (ekugcineni). Okulandelayo, chofoza uphawu lwekhibhodi "-". Emva kwalokhu, khetha iseli eliqukethe usuku lokuqala (lokuqala).
- Ukubona ukuthi sekudlule isikhathi esingakanani phakathi kwale mihla, chofoza inkinobho. Ngena. Umphumela uboniswa eselifomeni njengefomethi evamile.
Indlela 2: umsebenzi weRAZHDAT
Ukubala umehluko ezinsukwini, ungasebenzisa futhi umsebenzi okhethekile. RAZNAT. Inkinga yukuthi ayikho umsebenzi ohlwini lwabaphathi bomsebenzi, ngakho-ke kuzomele ufake ifomu ngesandla. I-syntax yayo ilandelayo:
= I-RAZNAT (qala_date; ekugcineni_kudlule; eyodwa)
"Unit" - yilo ifomethi lapho umphumela uzoboniswa kuseli elikhethiwe. Kuxhomeke kuloluphi uhlamvu oluzofakwa endaweni yale parameter, lapho amayunithi umphumela uzobuyiselwa khona:
- "y" - iminyaka egcwele;
- "m" - izinyanga ezigcwele;
- "d" - izinsuku;
- "YM" umehluko ezinyangeni;
- "MD" - umehluko ezinsukwini (izinyanga neminyaka azibalwa);
- "YD" umehluko ezinsukwini (iminyaka ayibalwa).
Njengoba kudingeka sibone umehluko enani lezinsuku phakathi kwezinsuku, isisombululo esihle kunazo zonke kungaba ukusebenzisa le ndlela yokugcina.
Kumele futhi uqaphele ukuthi, ngokungafani nendlela esebenzisa ifomula elula echaziwe ngenhla, uma usebenzisa lo msebenzi kuqala kufanele kube usuku lokuqala, futhi okokugcina - okwesibili. Uma kungenjalo, izibalo ngeke zilungile.
- Bhala ifomula esitokisini ekhethiwe, ngokwe-syntax yayo, echazwe ngenhla, kanye nedatha eyinhloko ngendlela yokuqala nokuphela kwezinsuku.
- Ukuze ubale, chofoza inkinobho Ngena. Emva kwalokho, umphumela, ngesimo senombolo ekhombisa inani lezinsuku phakathi kwezinsuku, izoboniswa kuseli elicacisiwe.
Indlela 3: Bala inani lezinsuku zokusebenza
E-Excel, kungenzeka futhi ukubala izinsuku zokusebenza phakathi kwezinsuku ezimbili, okungukuthi, ngaphandle kwamavikiki namaholide. Ukuze wenze lokhu, sebenzisa lo msebenzi ABAHLELI. Ngokungafani no-opharetha wangaphambilini, ukhona kuhlu lwamakhosi omsebenzi. I-syntax yalo msebenzi ilandelayo:
= ABASEBENZA (qala_kudlulile; ekugcineni_date; [amaholidi])
Kulo msebenzi, izingxabano eziyinhloko zifana no-opharetha RAZNAT - usuku lokuqala nokuphela. Ngaphezu kwalokho, kunengxabano yokuzikhethela "Amaholide".
Esikhundleni salokho, izinsuku zeholide zomphakathi, uma zikhona, ngesikhathi esifakwe kufanele kufakwe esikhundleni. Lo msebenzi ubala zonke izinsuku zohlu olucacisiwe, ngaphandle kwamaMgqibelo, amaSonto, kanye nalawo mahla wanezelwa ngumsebenzisi ekuxabaneni "Amaholide".
- Khetha iseli elizoqukatha umphumela wokubala. Chofoza inkinobho "Faka umsebenzi".
- Umsebenzi wizard uvula. Esikhathini "Uhlu oluphelele lwe-alfabhethi" noma "Usuku Nesikhathi" ngifuna into "CHISTRABDNY". Khetha bese uchofoza inkinobho. "Kulungile".
- Iwindi lempikiswano yokusebenza ivula. Faka emasimini afanele usuku lokuqala nokuphela kwesikhathi, kanye nezinsuku zamaholide omphakathi, uma kukhona. Sicindezela inkinobho "Kulungile".
Ngemuva kokusebenza okungenhla, inani lezinsuku zokusebenza zesikhathi esibekiwe lizoboniswa kuseli elikhethiwe ngaphambilini.
Isifundo: I-Excel Function Wizard
Njengoba ubona, i-Excel inikeza umsebenzisi wayo nge-toolkit elula yokubala inani lezinsuku phakathi kwezinsuku ezimbili. Kulokhu, uma nje udinga ukubala umehluko ezinsukwini, khona-ke ukukhetha okungcono kakhulu kungaba ukusebenzisa ifomula elula yokukhipha, kunokusebenzisa umsebenzi RAZNAT. Kodwa uma ufuna, isibonelo, ukubala inani lezinsuku zokusebenza, khona-ke umsebenzi uzokusiza ABAHLELI. Okusho ukuthi, njalo njalo, umsebenzisi kufanele anqume ithuluzi lokukhipha ngemuva kokusetha umsebenzi othize.
