Enye yemisebenzi engabhekana nomsebenzisi ngenkathi isebenza ku-Excel yengezela isikhathi. Isibonelo, lo mbuzo ungavela ekulungiseleleni ibhalansi yokusebenza isikhathi esimisweni. Izinkinga zihlobene neqiniso lokuthi isikhathi asilinganisiwe ohlelweni lwesimali esaziwayo kithi, lapho i-Excel isebenza ngokuzenzakalelayo. Ake sizithole ukuthi singasifaka kanjani isikhathi kulolu hlelo lokusebenza.
Isikhathi sesikhathi
Ukuze ukhiqize inqubo yesikhathi sokufingqa, okokuqala, wonke amaseli ahlanganyela kulo msebenzi kumele abe nesakhiwo sesikhathi. Uma kungenjalo, kufanele kufomethiwe ngokufanele. Ifomethi yeselula yamanje ingabonwa ngemuva kokukhethwa kwayo kuthebhu "Ikhaya" endaweni ekhethekile yokufometha kwitheyipu ebhokisini lamathuluzi "Inombolo".
- Khetha amaseli ahambelanayo. Uma lokhu kungububanzi, khona-ke ubambe phansi inkinobho yesinxele segundane bese uyijikeleza. Uma sisebenzelana namaseli ngabanye ahlakazekile eshidi, bese sibakhetha, phakathi kwezinye izinto, ngokubamba inkinobho Ctrl kwikhibhodi.
- Sichofoza inkinobho yesokudla yegundane, ngaleyo ndlela sibiza imenyu yesimo. Hamba ngokusebenzisa into "Fometha amaseli ...". Ngaphandle kwalokho, ungaphinda uthayiphe inhlanganisela ngemuva kokugqamisa ekhibhodi. Ctrl + 1.
- Iwindi yokufometha ivula. Iya kuthebhu "Inombolo"uma ivuliwe kwelinye ithebhu. Ku-block parameter "Amafomu Amanani" shintshela inkinobho ukuma "Isikhathi". Ngakwesokudla kwefasitela ku-block "Thayipha" khetha uhlobo lokubonisa esizosebenza ngalo. Ngemva kokusetha kwenziwa, chofoza inkinobho. "Kulungile" phansi kwefasitela.
Isifundo: Ukufometha kwethebula kwe-Excel
Indlela 1: ukubonisa isikhathi emva kwesikhathi
Okokuqala, ake sibone ukuthi singakanani ukuthi singakanani amahora azoboniswa ngemuva kwesikhathi esithile, siboniswe emahoreni, imizuzu nemizuzwana. Esikhathini sethu esiqondile, udinga ukuthola ukuthi kuyoba yihora elingakanani emva kwehora elingu-1 amahora angu-45 nemizuzwana engu-51, uma isikhathi sisethwe ngo-13:26:06.
- Engxenyeni efomathiwe yeshidi kumaseli ahlukile usebenzisa ikhibhodi faka idatha "13:26:06" futhi "1:45:51".
- Esitokisini sesithathu, lapho isakhiwo sesikhathi sisethiwe, faka uphawu "=". Okulandelayo, chofoza kuseli ngesikhatsi "13:26:06"chofoza uphawu "+" kukhibhodi bese uchofoza esitokisini ngenani "1:45:51".
- Ukuze ubonise umphumela wokubala, chofoza inkinobho "Faka".
Qaphela! Ukusebenzisa le ndlela, ungathola ukuthi mangaki amahora azoboniswa ngemuva kwesikhathi esithile kuphela ngosuku olulodwa. Ukuze ukwazi "ukunqamula phezu" umkhawulo wansuku zonke futhi wazi isikhathi esingakanani iwashi ezobonisa, kufanele uhlale ukhetha uhlobo lwefomethi nge-asterisk uma ufometha amaseli, njengalesi sithombe ngezansi.
Indlela 2: sebenzisa umsebenzi
Enye indlela eya kwangaphambili ukusebenzisa uhlelo SUM.
- Emva kwedatha eyinhloko (ukufundwa kwamanje kwewashi nobude besikhathi) kufakiwe, khetha iseli elihlukile. Chofoza inkinobho "Faka umsebenzi".
- Umsebenzi wizard uvula. Sifuna umsebenzi ohlwini lwezinto "SUMM". Khetha bese uchofoza inkinobho. "Kulungile".
- Iwindi lempikiswano yokusebenza iqalisiwe. Setha isikhombisi emkhakheni "Number1" bese uchofoza esitokisini equkethe isikhathi samanje. Bese usetha isikhombisi ensimini "Number2" bese uchofoze esitokisini, okubonisa isikhathi ofuna ukuyifaka. Ngemuva kokuba kokubili amasimu agcwaliswe, chofoza inkinobho "Kulungile".
- Njengoba ubona, ukubalwa kwenziwa futhi umphumela wokufaka kwesikhathi uboniswa kuseli elikhethiwe ekuqaleni.
Isifundo: I-Excel Function Wizard
Indlela yesithathu: Ukwengezwa kwesikhathi esiphelele
Kodwa kaningi lapho kusebenza khona kuyadingeka ukuthi unganqamuli isibonakaliso samahora emva kwesikhathi esithile, kodwa ukwengeza isikhathi esiphelele. Isibonelo, lokhu kuyadingeka ukunquma inani eliphelele lamahora asetshenzisiwe. Ngale njongo, ungasebenzisa enye yezindlela ezimbili ezichazwe ngaphambili: ukwengeza okulula noma ukusetshenziswa komsebenzi SUM. Kodwa, kulula kakhulu kulokhu ukusebenzisa ithuluzi elinjalo njengesamba semoto.
- Kodwa, okokuqala sizodinga ukufometha amaseli ngokuhlukile, hhayi ngendlela echazwe ezinguqulweni zangaphambilini. Khetha indawo bese ufonela ifasitela lokufometha. Kuthebhu "Inombolo" shintsha ukushintsha "Amafomu Amanani" esimweni "Okuthuthukisiwe". Esikhathini esifanele sefasitela sithola futhi sibeke inani "[h]: mm: ss". Ukuze ulondoloze ushintsho, chofoza inkinobho. "Kulungile".
- Okulandelayo, udinga ukukhetha uhla olugcwele nesikhathi sesikhathi neseli elingenalutho ngemva kwalo. Ukuba kuthebhu "Ikhaya", chofoza kusithonjana "Inani"elitholakala kutheyipu ematheni amathuluzi Ukuhlela. Ngokunye, ungathayipha isinqamuleli sekhibhodi "Alt + =".
- Ngemva kwalezi zenzo, umphumela wezibalo uzovela kuseli elingenalutho elikhethiwe.
Isifundo: Indlela yokubala inani ku-Excel
Njengoba ubona, kunezinhlobo ezimbili zokwengeza kwesikhathi ku-Excel: ukungezwa kwesikhathi sonke nokubala kwesimo samahora ngemva kwesikhathi esithile. Ukuxazulula zonke lezi zinkinga, kunezindlela eziningana. Umsebenzisi ngokwakhe kufanele anqume ukuthi yikuphi okukhethwa kukho kulokhu okuzokwenzeka kuye ngokwengeziwe.
