Ukuguqula amahora abe amaminithi ku-Excel ngezindlela ezahlukene

Ukuguqula amahora abe amaminithi kuwumsebenzi ovame kakhulu, ngezinye izikhathi odingeka ku-Excel. Uma uthi nhlá, kubonakala sengathi lokhu kungenziwa ohlelweni ngaphandle kobunzima obuningi. Kodwa-ke, ekusebenzeni, abanye abasebenzisi bangase bahlangabezane nobunzima obuthile ngenxa yezici zohlelo. Ngakho-ke, ngezansi sizobheka ukuthi ungawaguqula kanjani amahora abe amaminithi ku-Excel usebenzisa izindlela ezahlukene.

Guqula amahora abe amaminithi

Njengoba sishilo ngenhla, i-Excel inesici esihlanganisa uhlelo lokubala lwesikhathi olukhethekile oluhlukile koluvamile. Kuhlelo, amahora angama-24 alingana nelilodwa, kanti amahora ayi-12 ahambisana nenombolo 0,5 (isigamu sosuku lonke).

Ake sithi sineseli elinenani ngefomethi yesikhathi.

Chofoza kufomethi yamanje (ithebhu "Ikhaya", isigaba samathuluzi "Inombolo") bese ukhetha ifomethi evamile.

Ngenxa yalokho, ngokuqinisekile sizothola inombolo - kuleli fomu lapho uhlelo lubona isikhathi esikhonjiswe kuseli elikhethiwe. Inombolo ingaba phakathi kuka-0 no-1.

Ngakho-ke, lapho siguqula amahora abe amaminithi, sidinga ukucabangela lesi sici sohlelo.

Indlela 1: Ukusebenzisa Ifomula

Le ndlela ilula kakhulu futhi ibandakanya ukusetshenziswa kwefomula yokuphindaphinda. Ukuguqula amahora abe amaminithi, udinga kuqala ukuphindaphinda isikhathi esinikeziwe ngaso 60 (inombolo yemizuzu ehoreni elilodwa), bese - kuvuliwe 24 (inani lamahora ngosuku olulodwa). Ngamanye amazwi, sidinga ukuphindaphinda isikhathi ngenombolo 1440. Ake sizame lokhu ngesibonelo esisebenzayo.

1. Sivuka esitokisini lapho sihlela ukubonisa umphumela ngesimo senombolo yemizuzu. Ngokubeka uphawu olulinganayo, sibhala ifomula yokuphindaphinda kuyo. Izixhumanisi zeseli ezinenani lokuqala (kithi - C4) ingacaciswa ngesandla, noma ngokumane uyichofoze ngenkinobho yegundane engakwesokunxele. Okulandelayo, cindezela inkinobho Faka.
2. Ngenxa yalokho, asikutholi lokho ebesikulindele, okungukuthi, inani "0:00".
3. Lokhu kwenzeka ngenxa yokuthi uma ubonisa umphumela, uhlelo lugxile kumafomethi amaseli ahilelekile kufomula. Labo. esimweni sethu, iseli eliwumphumela linikezwa ifomethi “Isikhathi”. Ishintshe ibe "Okuvamile" ungakwenza njengakuthebhu "Ikhaya" (ibhulokhi yamathuluzi "Inombolo"), njengoba kuxoxiwe ngenhla, kanye nasefasiteleni lefomethi yeseli, elingafinyelelwa ngemenyu yokuqukethwe kweseli, ebizwa ngokuchofoza kwesokudla kuyo.Uma usefasiteleni lokufometha ohlwini olungakwesokunxele, khetha umugqa "Okuvamile" bese ucindezela inkinobho OK.
4. Njengomphumela, sizothola inani eliphelele lamaminithi ngesikhathi esinikeziwe.
5. Uma udinga ukuguqula amahora abe amaminithi kuyo yonke ikholomu, akudingekile nakancane ukwenza lokhu ngokwehlukana kuseli ngalinye, ngoba inqubo ingenziwa ngokuzenzakalelayo. Ukuze wenze lokhu, hambisa phezulu kweseli ngefomula ngokushesha nje lapho kuvela uphawu olumnyama lokuhlanganisa (gcwalisa umaka), cindezela inkinobho yegundane kwesokunxele bese uyihudulela phansi kuseli lokugcina ofuna ukwenza izibalo ezihambisanayo kulo.
6. Konke sekumi ngomumo, ngenxa yalesi senzo esilula, sikwazile ukuguqula ngokushesha amahora abe amaminithi awo wonke amanani ekholomu.

Indlela yesi-2: Guqula umsebenzi

Kanye nokuphindaphinda okujwayelekile, i-Excel inomsebenzi okhethekile UMguquliukuguqula amahora abe amaminithi.

Kubalulekile ukukhumbula ukuthi umsebenzi usebenza kuphela uma isikhathi simelelwe ngefomethi "Okuvamile". Kulokhu, isibonelo, isikhathi "04:00" kufanele ibhalwe njengenombolo elula 4, "05:30" - Kanjani "5,5". Futhi, le ndlela ifaneleka lapho sidinga nje ukubala inani eliphelele lamaminithi ahambisana nenani elinikeziwe lamahora, ngaphandle kokucabangela izici zesistimu yokubala ohlelweni, okwaxoxwa ngakho endleleni yokuqala.

1. Sisukuma esitokisini lapho sifuna ukwenza khona izibalo. Ngemva kwalokho, cindezela inkinobho "Faka umsebenzi" (fx) kwesokunxele sebha yefomula.
2. Ewindini lokufaka imisebenzi, khetha isigaba “Ubunjiniyela” (noma “Uhlu oluphelele lwama-alfabhethi”), chofoza umugqa onomsebenzi "ISIGUQI", bese ngenkinobho OK.
3. Iwindi lizovuleka lapho sidinga ukugcwalisa izimpikiswano zomsebenzi:
   • ensimini "Inombolo" cacisa ikheli leseli ofuna ukuliguqulela inani lalo. Ungakwenza lokhu ngokufaka izixhumanisi ngokwenza, noma umane uchofoze kwesokunxele kuseli oyifunayo kuthebula ngokwalo (ngenkathi ikhesa kufanele ibe senkambu yokufaka inani).
   • Ake siqhubekele engxabano. "Iyunithi yokulinganisa yangempela". Lapha sibonisa ukuqokwa kwekhodi yewashi - "ihora".
   • Njengeyunithi yokugcina yokulinganisa, sibonisa ikhodi yayo - "mm".
   • uma usulungile, cindezela inkinobho OK.
4. Umphumela odingekayo uzovela kuseli nomsebenzi.
5. Uma sidinga ukwenza izibalo zekholomu yonke, njengasendleleni yokuqala, sizosebenzisa gcwalisa umakangokuyidonsela phansi.

Isiphetho

Ngakho-ke, ngokuya ngendlela kanye nomphumela oyifunayo ku-Excel, ungaguqula amahora abe amaminithi usebenzisa izindlela ezimbili ezihlukene. Ngamunye wabo uyasebenza ngendlela yakhe, kuyilapho ukukwazi kahle akunzima.