Uma usebenzisa isikhathi ku-Excel, ngezinye izikhathi kunenkinga yokuguqula amahora kuya kumaminithi. Kungabonakala kuwumsebenzi olula, kodwa ngokuvamile kubonakala kuningi kakhulu kubasebenzisi abaningi. Futhi le nto iyingxenye yokubala isikhathi kuloluhlelo. Ake sibone indlela yokuhumusha amahora amaminithi ku-Excel ngezindlela ezihlukahlukene.
Guqula amahora kuya emaminithi ku-Excel
Inkinga yonke yokuguqula amahora kuya kwemizuzu ukuthi i-Excel ibheka isikhathi esingavamile kithi, kodwa njengezinsuku. Okusho ukuthi, lolu hlelo, amahora angu-24 alingana nelinye. Isikhathi se-12: 00, uhlelo luyi-0.5, ngoba amahora angu-12 ayi-0.5 ingxenye yosuku.
Ukuze ubone ukuthi lokhu kwenzeka kanjani ngesibonelo, kudingeka ukhethe noma yisiphi iseli kushidi ngesakhiwo sesikhathi.
Bese uyifometha ngaphansi kwefomethi evamile. Yilibalo elizovela esitokisini elizoveza umbono weprogram yedatha efakiwe. Ububanzi bayo bungahlukana 0 kuze kube 1.
Ngakho-ke, umbuzo wokuguqula amahora kuya kumaminithi kufanele uhanjiswe emgodini walokhu.
Indlela 1: Ukusebenzisa Ifomula Yokuphindaphinda
Indlela elula yokuguqula amahora kuya kumaminithi ukunyuswa ngesici esithile. Ngenhla, sithole ukuthi i-Excel ibona isikhathi ezinsukwini. Ngakho-ke, ukuze uthole imininingwana enkulumweni, udinga ukwandisa leyo nkulumo nge 60 (inombolo yemizuzu ngamahora) futhi 24 (inani lamahora ngosuku). Ngakho-ke, i-coefficient esizoyidinga ukuyandisa inani kuyoba 60×24=1440. Ake sibone ukuthi kuzobukeka kanjani ngokusebenza.
- Khetha iseli elizoqukatha umphumela wokugcina ngamaminithi. Sabeka uphawu "=". Chofoza kuseli lapho idatha ikhona khona emahoreni. Sabeka uphawu "*" bese uthayipha inombolo kusuka kukhibhodi 1440. Ukuze uhlelo luzocubungula idatha futhi lubonise umphumela, chofoza inkinobho Ngena.
- Kodwa umphumela ungase ungalungile. Lokhu kungenxa yokuthi, ukucubungula idatha yesakhiwo sesikhathi ngokusebenzisa ifomula, iseli lapho inani liboniswa khona, ngokwayo lithola ifomethi efanayo. Kulesi simo, kudinga ukuguqulwa kube jikelele. Ukuze wenze lokhu, khetha iseli. Bese uthuthela kuthebhu "Ikhaya"uma sisesinye futhi uchofoze emkhakheni okhethekile lapho ifomethi iboniswa khona. Itholakala ku-tape ebhodini lamathuluzi. "Inombolo". Phakathi kweqoqo lamagugu kuhlu oluvula, khetha into "Jikelele".
- Emva kwalezi zenzo, iseli ecacisiwe lizobonisa idatha efanele, ezoba umphumela wokuguqula amahora kuya kumaminithi.
- Uma unenani elingaphezu kweyodwa, kodwa ububanzi obuphelele bokuguqulwa, awukwazi ukwenza umsebenzi ngenhla ngenani ngalinye ngokwehlukana, kepha kopisha ifomula usebenzisa uphawu lokugcwalisa. Ukuze wenze lokhu, faka isikhombisi ekhoneni elingaphansi kwesokudla leseli ngefomula. Silinde uphawu lokugcwalisa ukuze lusebenze njengesiphambano. Bamba inkinobho yegundane lesokunxele bese uhudula i-cursor parallel kumaseli anedatha eguqulwe.
- Njengoba ubona, ngemuva kwalesi senzo, izindinganiso zochungechunge lonke zizoguqulwa zibe yimaminithi.
Isifundo: Indlela yokwenza ngokuzenzekelayo ku-Excel
Indlela 2: Ukusebenzisa umsebenzi othuthukisiwe
Kukhona enye indlela yokuguqula amahora amaminithi. Ukuze wenze lokhu, ungasebenzisa umsebenzi okhethekile. I-Preob. Kumele kuqashelwe ukuthi le nketho izosebenza kuphela lapho inani lokuqala likhona esitokisini ngesakhiwo esivamile. Lokhu kungukuthi, amahora angu-6 akufanele avele njengoba "6:00"futhi kanjani "6", namahora angu-6 amaminithi angu-30, engathandi "6:30"futhi kanjani "6,5".
- Khetha iseli ohlela ukuyisebenzisa ukubonisa umphumela. Chofoza kusithonjana "Faka umsebenzi"okuyinto ifakwe eduze kwe-formula bar.
- Lesi senzo siholela ekutholeni Amakhosi omsebenzi. Inikeza uhlu oluphelele lwezitatimende ze-Excel. Kulolu hlu, bheka umsebenzi I-Preob. Uma usutholile, ukhethe bese uchofoza inkinobho. "Kulungile".
- Iwindi lempikiswano yokusebenza iqalisiwe. Lo opharetha unezizathu ezintathu:
- Inombolo;
- Umthombo Wezandla;
- Iyunithi yokugcina.
Insimu yokuphikisana yokuqala yinkulumo yenombolo eguqulwayo, noma ireferensi yeseli lapho itholakala khona. Ukuze ucacise isixhumanisi, udinga ukusetha isikhombisi emkhakheni wewindi, bese uchofoza esitokeni kushidi lapho idatha ikhona khona. Emva kwalokhu kuhlanganiswa kuzoboniswa ensimini.
Emkhakheni weyunithi yokuqala yokulinganisa kithi, udinga ukucacisa iwashi. Ukukhokha kwabo ku: "hr".
Emkhakheni wokugcina wokulinganisa ukhombise amaminithi - "mn".
Ngemuva kokuthi yonke idatha ifakiwe, chofoza inkinobho "Kulungile".
- I-Excel izokwenza ukuguqulwa futhi kuseli elanduliwe lizoveza umphumela wokugcina.
- Njengendlela yangaphambilini, usebenzisa uphawu lokugcwalisa, ungenza umsebenzi wokucubungula I-Preob lonke uhla lwemininingwane.
Isifundo: I-Excel umsebenzi wizard
Njengoba ubona, ukuguqulwa kwamahora kuya emaminithini akulula njengoba kubonakala ekuqaleni. Lokhu kuyinkinga ngokukhethekile ngemininingwane ngesakhiwo sesikhathi. Ngenhlanhla, kunezindlela ezivumela ukuguqulwa kule ndlela. Enye yalezi zindlela kuhilela ukusetshenziswa kwe-coefficient, futhi okwesibili - umsebenzi.
