Ungayihumusha Kanjani Iwashi ngemizuzu yokuya phambili

Lapho usebenza ngesikhathi se-Excel, kwesinye isikhathi kunenkinga yokuhunyushwa kwamahora ngemizuzu. Kungaba ngumsebenzi olula, kepha imvamisa akudingekile kubasebenzisi abaningi hhayi amazinyo. Futhi konke kuqukethe izici zokubalwa kwesikhathi kulolu hlelo. Ake sibheke ukuthi ungahumusha kanjani iwashi ngemizuzu ukuze udlule ngezindlela ezahlukahlukene.

Amahora wokuguqulwa ngomzuzu nge-Excel

Yonke inkimbinkimbi yokuhunyushwa kwewashi ngomzuzu ukuthi i-Excel ibheka isikhathi esisisijwayele, kodwa ngezinsuku. Okungukuthi, kulolu hlelo, amahora angama-24 alingana noyedwa. Isikhathi 12:00 Uhlelo lumele njengo-0,5, ngoba amahora angu-12 ngu-0,5 ingxenye yosuku.

Ukuze ubone ukuthi lokhu kwenzeka kanjani esibonelweni, udinga ukugqamisa noma yisiphi iseli eshidi ngesikhathi sesikhathi.

Bese uyifometha ngaphansi kwefomethi ejwayelekile. Yinombolo ezoba sesitokisini, futhi izokhombisa umbono wohlelo olufakiwe lwedatha. Ibanga layo lingahluka kusuka ku-0 kuye ku-1.

Ngakho-ke, embuzweni wokuguqulwa kwamahora ngemizuzu, kuyadingeka ukusondela kwi-Prism yaleli qiniso.

Indlela 1: Ukusetshenziswa kwefomula yokuphindaphinda

Indlela elula yokuhumusha iwashi ngemizuzu lapho ukuphindaphindwa kokwehluleka okuthile. Ngaphezulu sithole ukuthi i-Excel ibona isikhathi ngezinsuku. Ngakho-ke, ukuthola kusuka ezwini imizuzu yewaka, udinga ukwandisa le nkulumo ngo-60 (inani lemizuzu emahoreni) naku-24 (inani lamahora ezinsukwini). Ngakho-ke, i-coeffled etholakalayo lapho sidinga khona ukwandisa inani lizoba ngo-60 × 24 = 1440. Ake sibheke ukuthi kuzobukeka kanjani ekusebenzeni.

1. Sigqamisa iseli lapho umphumela wokugcina uzoba ngemizuzu. Sibeka uphawu "=". Chofoza esitokisini, lapho idatha itholakala khona ewashi. Sibeka isibonakaliso esithi "*" bese uthayipha inombolo 1440 kusuka kukhibhodi. Ukuze lolu hlelo luqhubeke nemininingwane futhi luphoqelele imiphumela.



2. Kepha umphumela usengaphuma njengoba akulungile. Lokhu kungenxa yokuthi, ukucubungula imininingwane yefomethi yesikhathi ngefomula, iseli, lapho umphumela utholakala khona, ifomethi efanayo lithathwe. Kulokhu, kufanele kuguqulwe kube yinto ejwayelekile. Ukuze wenze lokhu, khetha iseli. Ngemuva kwalokho sithuthela kuthebhu "Yasekhaya", uma ukhona, bese uqhafaza enkundleni ekhethekile lapho kuboniswa khona isimo. Itholakala ethepheni kubha yamathuluzi "yenombolo". Uhlu oluvule phakathi kwamanani amaningi, khetha into ethi "Jikelele".



3. Ngemuva kwalezenzo, idatha efanele izokhonjiswa esitokisini esinikeziwe, okuzoba umphumela wokuhunyushwa kwewashi ngalinye.



4. Uma unenani elingaphezu kweyodwa, kepha uhla lokuguqulwa, awukwazi ukwenza umsebenzi ongenhla ngenani ngalinye ngokuhlukile, bese ukopisha ifomula usebenzisa umaki wokugcwalisa. Ukuze wenze lokhu, beka isikhombisi ekhoneni elingezansi kwesokudla seseli ngefomula. Silinda lapho umaka wokugcwalisa esebenza njengesiphambano. Cindezela inkinobho yegundane kwesokunxele bese welula isikhombisi esifana namaseli ngedatha eguquliwe.



5. Njengoba ubona, ngemuva kwalesi senzo, inani lomugqa wonke lizoguqulwa ngemizuzu.

Isifundo: Kanjani ukwenza i-autocomplete ekudingisweni

Indlela 2: Isebenzisa umsebenzi we-prob

Futhi kunenye indlela eya emahoreni aguqukayo ngomzuzu. Ukuze wenze lokhu, ungasebenzisa umsebenzi okhethekile we-prob. Kuyadingeka ukubheka ukuthi le nketho izosebenza kuphela lapho inani lokuqala lisesitokisini elinefomethi ejwayelekile. Lokho wukuthi, amahora angu-6 kuwo akufanele kuboniswe njenge- "6:00", kodwa njenge- "6", kodwa amahora angu-6 imizuzu engama-30, hhayi njengo- "6:30", kodwa njengo- "6.5".

1. Khetha iseli elihlelelwe ukuthi lisetshenziselwe ukubonisa umphumela. Chofoza isithonjana se- "Insert Function", esiseduzane nomugqa wefomula.



2. Lesi senzo siholela ekuvuleni kwe-Master of Imisebenzi. Inohlu oluphelele lwabasebenza e-Excel. Kulolu hlu sifuna umsebenzi we-prob. Njengoba sikutholile, sabela bese sichofoza inkinobho ethi "KULUNGILE".



3. Iwindi lezimpiko ezisebenzayo liqala. Lo opharetha unezimpikiswano ezintathu:
   • Inombolo;
   • Iyunithi yomthombo wokulinganisa;
   • Iyunithi lokugcina lokulinganisa.

   Inkambu yengxabano yokuqala ikhombisa inkulumo enenombolo eguqulwa, noma isixhumanisi esisekweni, lapho itholakala khona. Ukuze ucacise isixhumanisi, udinga ukufaka isikhombisi endimeni yewindi, bese uqhafaza esitokisini eshidini lapho imininingwane itholakala khona. Ngemuva kwalokho, izixhumanisi zizokhonjiswa endle.

   Emkhakheni weyunithi lomthombo wokulinganisa kithi, udinga ukucacisa iwashi. Ukufaka ikhodi yabo kunje: "HR".

   Ensimini yeyunithi yokugcina, sicacisa imizuzu - "MN".

   Ngemuva kwayo yonke imininingwane yenziwe, chofoza inkinobho ethi "Kulungile".



4. U-Excel wenza ukuguqulwa kanye neseli elishiwo ngaphambili kuzonikeza umphumela wokugcina.



5. Njengasendleleni edlule, usebenzisa umaki wokugcwalisa, ungacubungula wonke umsebenzi wedatha.

Isifundo: I-Master of Imisebenzi ku-Asuka

Njengoba ubona, ukuguqulwa kwamahora ngomzuzu akuwona umsebenzi olula, njengoba kubonakala ekuqaleni. Kuyinkinga ikakhulukazi ukwenza lokhu ngedatha ngefomethi yesikhathi. Ngenhlanhla, kunezindlela ezikuvumela ukuthi uguqule kule ndlela. Enye yalezi zinketho ihlinzeka ngokusetshenziswa kwe-coefficient, nomsebenzi wesibili.