Eminye yemisebenzi umsebenzisi angabhekana nayo ngenkathi esebenza e-Excel ukwengeza isikhathi. Isibonelo, le nkinga ingavela lapho kuhlanganiswa ibhalansi yesikhathi somsebenzi kuhlelo. Ubunzima buxhumene neqiniso lokuthi isikhathi asilinganiswa ohlelweni olujwayelekile lwedesimali, lapho i-Excel isebenza ngokuzenzakalelayo. Ake sibheke ukuthi singafingqa kanjani isikhathi kulolu hlelo lokusebenza.
Isikhathi DRM
Ukuze kwenziwe inqubo yesikhathi sokufingqa, okokuqala, wonke amaseli abamba iqhaza kulokhu kusebenza kufanele abe nefomethi yesikhathi. Uma lokhu kungenjalo, lapho-ke badinga ukufomethwa ngokufanele. Isimo samanje samaseli singabukwa ngemuva kokukhetha kuwo kuthebhu "Ikhaya" enkombeni yokufometha ekhethekile kubambo kubhokisi lamathuluzi "Inombolo".
- Khetha amaseli ahambisanayo. Uma lokhu kuluhlu, mane nje ubambe inkinobho yegundane kwesobunxele bese uyilungele. Uma sisebenzelana namaseli ngamanye ahlakazekile eshidini, lapho-ke siyawakhetha, phakathi kwezinye izinto, aphethe inkinobho Ctrl kwikhibhodi.
- Sichofoza kwesokudla, ngaleyo ndlela sinxusa imenyu yokuqukethwe. Iya entweni "Ifomethi yeseli ...". Esikhundleni salokho, futhi ungathayipha inhlanganisela ngemuva kokuqokomisa kukhibhodi I-Ctrl + 1.
- Iwindi lokufometha liyavula. Iya kuthebhu "Inombolo"uma ivule kwelinye ithebhu. Ebhulokini lamapharamitha "Amafomethi ezinombolo" hambisa switch uye esikhundleni "Isikhathi". Engxenyeni kwesokudla yewindows "Thayipha" sikhetha lolo hlobo lwesibuko esizosebenza ngalo. Ngemuva kokuthi ukusetha kwenziwe, chofoza inkinobho "Kulungile" phansi kwewindi.
Isifundo: Ifometha amatafula ku-Excel
Indlela yoku-1: bonisa amahora ngemuva kwenkathi yesikhathi
Okokuqala, ake sibheke ukuthi singabalwa kanjani ukuthi sizokhombisa amahora amangaki ngemuva kwenkathi ethile yesikhathi, kuvezwe ngamahora, imizuzu nemizuzwana. Esibonelweni sethu esithile, sidinga ukuthola ukuthi kungakanani okuzoba yikho ehoreni ngehora eli-1 nemizuzwana engama-51 uma isikhathi manje sesiyi-13: 266.
- Engxenyeni efomethiwe yeshidi kumaseli ahlukene usebenzisa ikhibhodi, faka idatha "13:26:06" futhi "1:45:51".
- Esitokisini sesithathu, lapho ifomethi yesikhathi nayo isethwe khona, beka uphawu "=". Okulandelayo, chofoza kuseli ngokuhamba kwesikhathi "13:26:06", chofoza uphawu "+" kukhibhodi bese uqhafaza kuseli ngenani "1:45:51".
- Ukuze ubonise umphumela wokubala, chofoza inkinobho "Ngena".
Ukunaka! Usebenzisa le ndlela, ungathola ukuthi zingaki amahora azokhombisa ngemuva kwesikhathi esithile kuphela ngosuku olulodwa. Ukuze ukwazi “ukweqa” umkhawulo wosuku futhi wazi ukuthi isikhathi sizokhombisa isikhathi esingakanani kuleli cala, qiniseka ukukhetha uhlobo lwefomethi nge-asterisk lapho ufometha amaseli, njengasesithombeni esingezansi.
Indlela 2: sebenzisa umsebenzi
Enye indlela yendlela edlule ukusebenzisa umsebenzi ISUM.
- Ngemuva kokufakwa kwedatha eyinhloko (iwashi yamanje nesikhathi sokuphumula), khetha iseli elihlukile. Chofoza inkinobho "Faka umsebenzi".
- Umsebenzi Wizard uyavula. Sifuna umsebenzi ohlwini lwezakhi ISUM. Khetha bese uchofoza inkinobho. "Kulungile".
- Iwindi lokuphikisana komsebenzi liyaqala. Setha isikhombisi esigangeni "Inombolo1" bese uchofoza kuseli equkethe isikhathi samanje. Ngemuva kwalokho setha isikhulumi esigangeni "Inombolo2" bese uchofoza kuseli lapho kukhonjiswa khona isikhathi esidinga ukwengezwa. Ngemuva kokuthi izinkambu zombili seziqediwe, chofoza inkinobho "Kulungile".
- Njengoba ukwazi ukubona, ukubala kwenzeka futhi umphumela wokungezelelwa kwesikhathi ukhonjiswa kuseli elikhethwe ekuqaleni.
Isifundo: Umsebenzi Wizard e-Excel
Indlela 3: isengezo sesikhathi esengeziwe
Kepha kaningi ekusebenzeni, awudingi ukunquma iwashi ngemuva kwesikhathi esithile, kepha engeza inani lesikhathi. Isibonelo, lokhu kuyadingeka ukuthola inani lamahora asetshenzisiwe. Ngalezi zinhloso, ungasebenzisa enye yezindlela ezimbili ezichazwe ngaphambilini: ukwengeza elula noma ukusetshenziswa komsebenzi ISUM. Kepha, kuleli cala kulula kakhulu ukusebenzisa ithuluzi elinje ngesilinganiso semoto.
- Kepha okokuqala, sizodinga ukufometha amaseli ngendlela ehlukile, hhayi njengoba kuchaziwe ezinguqulweni ezedlule. Khetha indawo bese ushayela iwindi lokufomatha. Kuthebhu "Inombolo" hlela kabusha switch "Amafomethi ezinombolo" esikhundleni "Kuthuthukile". Engxenyeni elungile yewindows sithola futhi sisetha inani "[h]: mm: ss". Ukuze ugcine ushintsho, chofoza inkinobho "Kulungile".
- Okulandelayo, khetha ibanga eligcwele ngenani lesikhathi neseli elilodwa elingenalutho emva kwalo. Ukuba kuthebhu "Ikhaya"chofoza isithonjana "Inani"etholakala ethepheni kubhulokhi bamathuluzi "Ukuhlela". Ngenye indlela, ungathayipha isinqamuleli sekhibhodi kwikhibhodi "Alt + =".
- Ngemuva kwalezi zenzo, umphumela wezibalo uvela esitokisini esingenalutho.
Isifundo: Ungayibala kanjani inani ku-Excel
Njengoba ubona, kunezinhlobo ezimbili zokungezwa kwesikhathi ku-Excel: isikhathi esengeziwe sokufakwa kanye nokubalwa kwesikhundla sewashi ngemuva kwenkathi ethile. Kunezindlela eziningana zokuxazulula inkinga ngayinye. Umsebenzisi ngokwakhe kufanele anqume ukuthi iyiphi inketho yecala elithile elimfanela ngokwengeziwe.
