Lapho usebenza nesikhathi e-Excel, kwesinye isikhathi kuba nenkinga yokuguqula amahora abe ngamaminithi. Kungabonakala kungumsebenzi olula, kepha kuvame ukuba nzima kakhulu kubasebenzisi abaningi. Futhi into yonke isezimweni zokubala isikhathi kulolu hlelo. Ake sibheke ukuthi ungawaguqula kanjani amahora abe ngamaminithi e-Excel ngezindlela ezahlukahlukene.
Guqula amahora abe ngamaminithi ku-Excel
Ubunzima bonke bokuguqula amahora abe yimizuzu ukuthi i-Excel ibheka isikhathi akuyona indlela evamile ngathi, kodwa yezinsuku. Lokho wukuthi, kulolu hlelo amahora angama-24 alingana. Ngo-12: 00, uhlelo lumelela u-0.5, ngoba amahora ayi-12 ayi-0.5 ingxenye yosuku.
Ukuze ubone ukuthi kwenzeka kanjani lokhu ngesibonelo, udinga ukukhetha noma isiphi iseli eshidini ngefomethi yesikhathi.
Bese uyihlela ngefomethi evamile. Yinombolo evela esitokisini ezokhombisa umbono wohlelo wedatha efakiwe. Ububanzi bawo bungasukela ku 0 ngaphambili 1.
Ngakho-ke, udaba lokuguqulwa kwamahora lube amaminithi kufanele lusondelwe ngokuqondile ngokusebenzisa leli qiniso.
Indlela yoku-1: faka ifomula yokuphindaphinda
Indlela elula yokuguqula amahora abe ngamaminithi ukwanda ngesici esithile. Sithole ngaphezulu ukuthi i-Excel ithatha isikhathi ngezinsuku. Ngakho-ke, ukuthola inkulumo kusuka ngamahora wemizuzu, udinga ukuphindaphinda le nkulumo ngo 60 (inani lemizuzu emahoreni) kuqhubeke 24 (inani lamahora ngosuku). Ngakho-ke, ukugcwala esizodinga ukukwengeza inani kuzoba 60×24=1440. Ake sibheke ukuthi kuzobukeka kanjani ekusebenzeni.
- Khetha iseli ozothola umphumela wokugcina emizuzwini. Sibeka isibonakaliso "=". Sichofoza kuseli lapho idatha itholakala khona emahoreni. Sibeka isibonakaliso "*" bese uthayipha inombolo kusuka kukhibhodi 1440. Ukuze uhlelo lucubungule idatha futhi lubonise umphumela, chofoza inkinobho Ngena.
- Kepha umphumela ungalokhu ungalungile. Lokhu kungenxa yokuthi, ukucubungula idatha yohlobo lwesikhathi ngefomula, iseli lapho umphumela kukhonjiswa ngokwalo lithola ifomethi efanayo. Kulokhu, kumele iguqulwe ibe jikelele. Ukuze wenze lokhu, khetha iseli. Ngemuva kwalokho siqhubekela kuthebhu "Ikhaya"uma sikwesinye, bese uchofoza kwinkambu ekhethekile lapho ifomethi iboniswa khona. Itholakala ethepheni kwibhulokhi yamathuluzi. "Inombolo". Uhlu oluvulayo, phakathi kweqoqo lamanani, khetha "Okujwayelekile".
- Ngemuva kwalezi zenzo, idatha efanele izokhonjiswa kuseli elicacisiwe, okuzoba ngumphumela wokuguqula amahora ube imizuzu.
- Uma ungenalo inani elilodwa, kepha uhla lonke lokuguqulwa, khona-ke awukwazi ukwenza lokhu okungenhla ngenani ngalinye ngokwahlukana, kodwa kopisha ifomula usebenzisa umaka wokugcwalisa. Ukuze wenze lokhu, beka ikhesa ekhoneni elingezansi kweseli ngefomula. Silinda kuze kube yilapho umaka wokugcwalisa esebenze ngendlela yesiphambano. Bamba inkinobho yegundane kwesobunxele bese uhudula isikhombisi ngokufana kumaseli imininingwane eguqulwayo.
- Njengoba ubona, ngemuva kwalesi senzo, amanani alo lonke uchungechunge azoguqulwa abe yimizuzu.
Isifundo: Ungayenza kanjani i-autocomplete ku-Excel
Indlela 2: sebenzisa umsebenzi we-PREFER
Futhi enye indlela yokuguqula amahora abe imizuzu. Ungasebenzisa umsebenzi okhethekile kulokhu. ISIVIVINYO. Kufanele kuqashelwe ukuthi le ndlela izosebenza kuphela lapho inani lasekuqaleni likuseli elinefomethi evamile. Okusho ukuthi, amahora angu-6 kuwo akufanele aboniswe njengoba "6:00"nokuthi kanjani "6"namahora ayi-6 imizuzu engama-30, akufani "6:30"nokuthi kanjani "6,5".
- Khetha iseli ohlela ukusisebenzisa ukubonisa umphumela. Chofoza isithonjana. "Faka umsebenzi"etholakala eduze nomugqa wamafomula.
- Lesi senzo sizovuleka Umsebenzi Wizards. Inikeza uhlu oluphelele lwezitatimende ze-Excel. Kulolu hlu sifuna umsebenzi ISIVIVINYO. Njengoba usuyitholile, khetha bese uchofoza inkinobho "Kulungile".
- Iwindi lokuphikisana komsebenzi liyaqala. Lo opharetha unezimpikiswano ezintathu:
- Inombolo;
- Iyunithi Yomthombo;
- Iyunithi yokugcina.
Inkambu yengxabano yokuqala ikhombisa ukubizwa kwenombolo okuguqulwayo, noma ireferensi yeseli lapho litholakala khona. Ukuze ucacise isixhumanisi, udinga ukubeka isikhombisi ensimini yewindi, bese uqhafaza esitokisini eshidi lapho idatha itholakala khona. Ngemuva kwalokho, izixhumanisi zizokhonjiswa endle.
Emkhakheni weyiyunithi yasekuqaleni yokulinganisa kithi, udinga ukucacisa iwashi. Ukufaka kwabo ikhodi kunje: "hr".
Emkhakheni weyunithi yokugcina yokulinganisa, chaza amaminithi - "mn".
Ngemuva kokuthi yonke imininingwane ifakiwe, chofoza inkinobho "Kulungile".
- I-Excel izokwenza ukuguqulwa futhi kuseli elichaziwe ngaphambilini lizokhipha umphumela wokugcina.
- Njengendlela yangaphambilini, usebenzisa umaki wokugcwalisa, ungaqhubeka nomsebenzi ISIVIVINYO uhla lonke lwedatha.
Isifundo: I-Excel Feature Wizard
Njengoba ukwazi ukubona, ukuguqula amahora abe imizuzu akuwona umsebenzi olula njengoba kubonakala ekuqaleni. Lokhu kuyinkinga ikakhulukazi ngedatha efomethi yesikhathi. Ngenhlanhla, kunezindlela ongakwenza ngazo ukuguqulwa kule ndlela. Enye yalezi zinketho ifaka ukusetshenziswa kwe-coeffanele, kanti okwesibili - imisebenzi.
