Ungasonga kanjani isikhathi ku-Excel

Eminye yemisebenzi engenzeka ngaphambi komsebenzisi ngenkathi isebenza ku-Excel ukufakwa kwesikhathi. Isibonelo, lo mbuzo kungenzeka lapho udweba ohlelweni lokulinganisa lwesikhathi sokusebenza. Ubunzima buhlobene neqiniso lokuthi isikhathi asilinganiswa ohlelweni lwedesimali olusijwayele, lapho kusebenza khona i-Excel ngokuzenzakalelayo. Ake sibheke ukuthi ungafingqa kanjani isikhathi kulolu hlelo lokusebenza.

Ukufingqa kwesikhathi

Ukuze ukhiqize inqubo yesikhathi sefingqa, okokuqala, wonke amaseli athatha iqhaza kulo msebenzi kufanele abe nefomethi yesikhathi. Uma kungenjalo, khona-ke kufanele bafomethwe ngokufanele. Ifomethi yeseli yamanje ingabukwa ngemuva kokuthi ikhethelwe ithebhu yasekhaya ensimini ekhethekile yokufometha etheyipini kubha yamathuluzi "yenombolo".

1. Khetha amaseli ahambisanayo. Uma kuyibanga, vele umane ukhiphe inkinobho yegundane kwesobunxele futhi uholele kukho. Uma kwenzeka sisebenzelana namaseli ngamanye asakazeke eshidini, khona-ke ukwabiwa kwawo kwenziwa, phakathi kwezinye izinto, ngokubamba inkinobho ye-CTRL kwikhibhodi.
2. Ngokuchofoza inkinobho yegundane kwesokudla, ngaleyo ndlela ushayele imenyu yokuqukethwe. Dlula entweni "Amaseli wefomethi ...". Esikhundleni salokho, ungalanda futhi inhlanganisela ye-CTRL + 1 kwikhibhodi.



3. Iwindi lokufometha livula. Iya kuthebhu "yenombolo" uma ivulwe kwenye ithebhu. Emihlangeni "yezinombolo", sihlele kabusha ukushintshwa kwesikhundla "sesikhathi". Ngakwesokunene sewindi kubhulokhi "yohlobo", khetha uhlobo lokubonisa esizosebenza ngalo. Ngemuva kokuthi isethaphu yenziwe, chofoza inkinobho ethi "Kulungile" ezansi kwewindi.

Isifundo: Ukufomatha amatafula ku-Excel

Indlela 1: Bukela ukufunda isikhathi sokuphumula

Okokuqala, ake sibone ukuthi ungalibala kanjani amahora amangaki azoboniswa ngemuva kwesikhathi esithile, esivezwe emahoreni, imizuzu nemizuzwana. Esibonelweni sethu esithile, kufanele wazi ukuthi kuzoba malini phansi ngemuva kwehora eli-1 imizuzu engama-45 nemizuzwana engama-51, uma ufakiwe kubo 13:26:06.

1. Esigabeni esifomethiwe seshidi emangqamuzaneni ahlukene usebenzisa ikhibhodi, sifaka imininingwane ethi "13: 16:06" no "1:45:51".



2. Esitokisini sesithathu, lapho kufakwa khona isimo sesikhathi, faka uphawu "=". Okulandelayo, chofoza kuseli ngokuhamba kwesikhathi "13:26:06", sichofoza esiteji "+" kwikhibhodi bese uqhafaza esitokisini ngenani elithi "1:45:51".



3. Ukuze imiphumela yokubalwa isiboniswa esikrinini, chofoza inkinobho ethi "Enter".

QAPHELA! Ukufaka le ndlela, ungathola ukuthi mangaki amahora azokhombisa ngemuva kwesikhathi esithile kungakapheli usuku olulodwa. Ukuze "weqe" ulayini wezinsuku zonke futhi wazi ukuthi singakanani isikhathi sokukhombisa iwashi, qiniseka ukufometha amaseli, udinga ukukhetha uhlobo lwefomethi nge-asterisk, njengasesithombeni esingezansi.

Indlela 2: Usebenzisa umsebenzi

Enye indlela eya endleleni edlule ukusebenzisa inani lenani.

1. Ngemuva kwedatha eyinhloko (ukufundwa kwesikhathi samanje sewashi nesikhathi) kufakiwe, khetha iseli elihlukile. Chofoza inkinobho ethi "PASTE function".



2. I-Wizard iyavula. Sifuna ohlwini lwezinto zomsebenzi "amanani". Sigqagqa kancane bese ucindezela inkinobho ethi "Kulungile".



3. Iwindi lezimpiko ezisebenzayo liqala. Sisungula isikhombisi ensimini "yenombolo1" kanye ne-clique yeseli equkethe isikhathi samanje. Ngemuva kwalokho setha isikhombisi kwinkambu ye- "Number2" bese uqhafaza esitokisini, lapho isikhathi sichazwe khona ukuthi sengezwe. Ngemuva kokuba zombili izinkambu zigcwalisiwe, cindezela inkinobho ethi "Kulungile".



4. Njengoba ubona, ukubala kwenzeka futhi umphumela wesengezo sesikhathi kukhonjiswa kuseli ekhethwe ekuqaleni.

Isifundo: Imisebenzi yeWizard ku-Excel

Indlela 3: Inani lesikhathi sengezo

Kepha kaningi ekusebenzeni, kuyadingeka ukuthi unganqumi ukufundwa kwamahora ngesikhathi esithile, kepha ukusonga inani lesikhathi esiphelele. Isibonelo, lokhu kuyadingeka ukuthola inani eliphelele lamahora asetshenzisiwe. Ngalezi zinhloso, ungasebenzisa enye yezindlela ezimbili ezichazwe ngaphambilini: Isengezo esilula noma ukusetshenziswa kwenani lamanani. Kepha, kulula kakhulu kuleli cala, sebenzisa leli thuluzi njenge-mosmy yemoto.

1. Kepha, okokuqala, sizodinga ukufometha amaseli ngendlela ehlukile, hhayi ukuthi yachazwa kanjani ezinguqulweni ezedlule. Khetha indawo bese ushayela iwindi lokufomatha. Kuthebhu "Yenombolo", sihlela kabusha "amafomethi ezinombolo" esikhumulweni "esithuthukile". Engxenyeni efanele yewindi esikutholayo bese usetha inani elithi "[H]: MM: SS". Ukuze ugcine ushintsho, chofoza inkinobho ethi "Kulungile".



2. Okulandelayo, udinga ukugqamisa ububanzi obugcwele ngenani lesikhathi nendawo eyodwa engenalutho ngemuva kwayo. Ukuba kwithebhu yasekhaya, chofoza isithonjana sesamba, esisethepeni kubha yamathuluzi yokuhlela. Njengenye indlela, ungashayela ikhibhodi ye- "Alt + =" kwikhibhodi.



3. Ngemuva kwalezi zenzo, umphumela wokubalwa uzovela esitokisini esikhethiwe esingenalutho.

Isifundo: Indlela yokubala inani le-Excel

Njengoba ubona, kunezinhlobo ezimbili zokugoqwa kwesikhathi ku-Excel: Ukungezwa kwesikhathi okuphelele kanye nokubalwa kwesikhundla sewashi ngemuva kwesikhathi esithile. Ukuxazulula ngayinye yale misebenzi kunezindlela eziningana. Umsebenzisi ngokwakhe kufanele anqume ukuthi iyiphi indlela ethile ethile eyayizomfanelekela yena.