Izindlela ezi-2 zokuguqula amahora abe amaminithi ku-Excel. Ungawaguqula kanjani amahora abe amaminithi ku-Excel

Kwabanye abasebenzisi abasebenzisa uhlelo lwe-Excel, ngokuhamba kwesikhathi kuba kudingekile ukuguqula amahora abe amaminithi. Uma uthi nhlá, kungase kubonakale sengathi lokhu kusebenza okulula akufanele kubangele noma ibuphi ubunzima. Kodwa-ke, njengoba umkhuba ubonisa, akuwona wonke umuntu ongakwazi ukuguqula amahora ngempumelelo futhi ngokushesha abe imizuzu. Lo mkhuba ungenxa yokuthi i-Excel inama-nuances ayo lapho ibala isikhathi. Ngakho-ke, ngenxa yalesi sihloko, uzoba nethuba lokuzijwayeza izindlela ezikhona ezikuvumela ukuthi uguqule amahora abe amaminithi ku-Excel, ukuze ukwazi ukwenza le misebenzi nganoma iyiphi indlela ekulungele.

Izici zokubala isikhathi ku-Excel

Uhlelo lwe-Excel lusibala isikhathi hhayi ngehora nemizuzu esifundwe ngayo, kodwa kusetshenziswa usuku. Kuvela ukuthi i-Excel ibona u-1 njengamahora angamashumi amabili nane. Ngokusekelwe kulokhu, inani lesikhathi lika-0,5 elibonwa uhlelo lizohambisana nesikhathi esibonwa ngumuntu ngo-12:00, njengoba inani le-0.5 lihambisana nomzuzwana owodwa wosuku. Ukuze ubone ukuthi isikhathi sibalwa kanjani kuhlelo lokusebenza, landela lezi zinyathelo:

• Khetha noma iyiphi iseli oyithandayo.
• Nikeza leli seli ifomethi ethi Isikhathi.
• Faka inani lesikhathi.

• Guqula inani lesikhathi elifakiwe libe ifomethi ethi "Okuvamile".

Kungakhathalekile ukuthi yisiphi isikhathi oqale ngaso esitokisini, uhlelo, ngemuva kokukhohlisa okungenhla, luzolihumusha libe yinani elizoba kububanzi obusuka ku-zero kuye koyedwa. Isibonelo, uma uqala ukufaka isikhathi esilingana no-17:47, bese ukuguqulela kufomethi evamile kuzonikeza inani. 0,740972

Ngakho-ke, lapho uguqula amahora abe amaminithi ku-Excel, kubaluleke kakhulu ukuqonda ukuthi uhlelo lubona kanjani isikhathi futhi lusiguqule. Manje ake siqhubekele ekucatshangelweni kwezindlela zokuguqula ezikhona.

Ukuphindaphinda isikhathi ngesici

Enye yezindlela ezilula zokuguqula amahora abe amaminithi ukuphindaphinda isikhathi ngento ethile. Uma kubhekwa iqiniso lokuthi uhlelo lwe-Excel lusebenza ngesikhathi ngosuku, kuyadingeka ukuphindaphinda isisho esikhona ngo-60 nango-24, lapho u-60 eyinani lemizuzu emahoreni, futhi u-24 inombolo yamahora ngosuku. Njengomphumela walesi sibalo, siphindaphinda 60 * 24 futhi sithola i-coefficient elingana no-1440. Ngokwazi ulwazi lwethiyori, singaqhubekela ekusetshenzisweni okungokoqobo kwendlela ecatshangelwayo.

1. Ukuze wenze lokhu, esitokisini lapho uhlelo luzobonisa umphumela wokugcina ngemizuzu, kufanele uqale usethe ifomethi ethi "Okujwayelekile", bese ukhetha bese ufaka uphawu olulinganayo kuyo.

1. Ngemva kwalokho, chofoza igundane kuseli lapho kukhona ulwazi ngamahora. Kuleli seli, faka uphawu lokuphindaphinda bese ufaka u-1440.

1. Ukuze i-Excel icubungule idatha efakiwe futhi ibonise umphumela, cindezela inkinobho ethi "Enter". Ilungile! Uhlelo lwenza ukuguqulwa.

Ukusebenzisa ithokheni yokuqedela ngokuzenzakalela

Ngokuvamile, abasebenzisi badinga ukuguqula ngenani elikhulu ledatha. Kulokhu, kulula ukusebenzisa isibambo sokugcwalisa.

1. Ukuze wenze lokhu, beka ikhesa yegundane ekugcineni kweseli ngefomula.
2. Linda imizuzwana embalwa ukuze isibambo sokugcwalisa sisebenze futhi uzobona isiphambano.
3. Ngemva kokuvula umaka, cindezela inkinobho yegundane engakwesokunxele bese uhudula ikhesa ehambisana namaseli ngesikhathi okufanele iguqulwe.

1. Ngemuva kwalokho uzobona ngokucacile ukuthi lonke uhla lwamanani luzoguqulwa uhlelo lube imizuzu.

Guqula usebenzisa umsebenzi ohlanganisiwe ku-Excel

Indlela yesibili yokuguqula ukusebenzisa umsebenzi okhethekile we-CONVERT, ohlanganiswe ohlelweni lwe-Excel ngokwalo.

Sicela uqaphele ukuthi le ndlela ingasetshenziswa kuphela uma amaseli aguquliwe equkethe isikhathi ngefomethi evamile. Isibonelo, isikhathi sehora le-12 kufanele sifakwe ngokuthi “12” futhi isikhathi u-12:30 kufanele sifakwe ngokuthi “12,5”.

1. Ukuze usebenzise le ndlela ngokuzijwayeza, udinga ukukhetha iseli ohlela ukubonisa umphumela kulo.

1. Khona-ke efasiteleni eliphezulu lohlelo udinga ukuthola into yemenyu ebizwa ngokuthi "Faka umsebenzi". Ngemva kokuchofoza le nto yemenyu, iwindi elisha lizovuleka phambi kwakho. Leli windi lizobonisa lonke uhlu lwemisebenzi ehlanganiswe nohlelo lwe-Excel.
2. Ukupheqa ohlwini lwemisebenzi usebenzisa isilayidi, thola umsebenzi obizwa nge-CONV. Bese udinga ukuyikhetha bese uchofoza inkinobho ethi "OK".

1. Iwindi elilandelayo lizovela phambi kwakho, lapho izinkambu ezintathu zokungqubuzana komsebenzi okhethiwe zizoboniswa. Njengempikiswano yokuqala, kufanele ucacise inani lenombolo lesikhathi noma ireferensi yeseli lapho leli nani litholakala khona. Cacisa amahora kunkambu yempikiswano yesibili, namaminithi endaweni yesithathu yokungqubuzana.
2. Ngemva kokufaka yonke idatha, chofoza inkinobho ethi "KULUNGILE". Ngemva kokucindezela le nkinobho, uhlelo luzobonisa umphumela kuseli ekhethiwe.

Uma udinga ukusebenzisa umsebenzi we-CONVERT ukuze uguqule izinhlelo zedatha, ungasebenzisa umaka wokugcwalisa, ukusebenzisana okuchazwe ngenhla.

Isiphetho

Sengiphetha, kufanele kuqashelwe ukuthi njengoba usuzijwayeze ngezindlela ezimbili zokuguqula amahora abe amaminithi ku-Excel, ungakhetha indlela efaneleke kakhulu futhi elula evumelana nezidingo zakho.