Kutembenuza maola kukhala mphindi mu Excel m'njira zosiyanasiyana

Kutembenuza maola kukhala mphindi ndi ntchito wamba, yomwe nthawi zina imafunika ku Excel. Poyang'ana koyamba, zikuwoneka kuti izi zitha kuchitika mu pulogalamuyi popanda zovuta. Komabe, pochita, ogwiritsa ntchito ena amatha kukumana ndi zovuta zina chifukwa cha mawonekedwe a pulogalamuyi. Chifukwa chake, pansipa tiwona momwe mungasinthire maola kukhala mphindi mu Excel pogwiritsa ntchito njira zosiyanasiyana.

Sinthani maola kukhala mphindi

Monga tafotokozera pamwambapa, Excel ili ndi mawonekedwe omwe amakhala ndi nthawi yapadera yowerengera nthawi yomwe imasiyana ndi nthawi zonse. Mu pulogalamuyi, maola 24 ndi ofanana ndi amodzi, ndipo maola 12 amafanana ndi nambala 0,5 (theka la tsiku lonse).

Tiyerekeze kuti tili ndi selo yokhala ndi mtengo mumtundu wa nthawi.

Dinani pamtundu wamakono (tab "Pofikira", gawo la zida "Nambala") ndikusankha mtundu wamba.

Zotsatira zake, tidzapeza nambala - ndi mawonekedwe awa omwe pulogalamuyo imawona nthawi yomwe ikuwonetsedwa mu selo losankhidwa. Nambalayo ikhoza kukhala pakati pa 0 ndi 1.

Choncho, posintha maola kukhala mphindi, tiyenera kuganizira mbali imeneyi ya pulogalamuyo.

Njira 1: Kugwiritsa Ntchito Fomula

Njira imeneyi ndi yosavuta kwambiri ndipo imaphatikizapo kugwiritsa ntchito njira yochulutsa. Kuti musinthe maola kukhala mphindi, muyenera kuchulukitsa nthawi yomwe mwapatsidwa 60 (chiwerengero cha mphindi mu ola limodzi), ndiye - pa 24 (kuchuluka kwa maola pa tsiku limodzi). Mwa kuyankhula kwina, tiyenera kuchulukitsa nthawi ndi nambala 1440. Tiyeni tiyese izi ndi chitsanzo chothandiza.

1. Timadzuka mu selo momwe timakonzekera kusonyeza zotsatira mu mawonekedwe a chiwerengero cha mphindi. Poika chizindikiro chofanana, timalemba ndondomeko yochulukitsa mmenemo. Kulumikizana kwa selo ndi mtengo woyambirira (kwa ife - C4) zitha kufotokozedwa pamanja, kapena kungodinanso ndi batani lakumanzere. Kenako, dinani kiyi Lowani.
2. Zotsatira zake, sitipeza zomwe timayembekezera, mwachitsanzo, mtengo "0:00".
3. Izi zidachitika chifukwa chakuti powonetsa zotsatira, pulogalamuyo imayang'ana mawonekedwe a ma cell omwe akukhudzidwa ndi formula. Iwo. kwa ife, selo lomwe likubwera limapatsidwa mawonekedwe “Nthawi”. Sinthani kukhala "General" mukhoza monga tabu "Pofikira" (block of tools "Nambala"), monga tafotokozera pamwambapa, ndi pawindo lamtundu wa selo, lomwe lingapezeke kudzera muzolemba za selo, zomwe zimatchedwa ndikudina kumanja.Kamodzi pa masanjidwe zenera mu mndandanda kumanzere, kusankha mzere "General" ndi kukanikiza batani OK.
4. Zotsatira zake, tipeza chiwerengero chonse cha mphindi mu nthawi yoperekedwa.
5. Ngati mukufuna kutembenuza maola kukhala mphindi pamndandanda wonse, sikoyenera kuchita izi padera pa selo iliyonse, chifukwa ndondomekoyi ikhoza kukhala yokha. Kuti muchite izi, yang'anani pamwamba pa selo ndi chilinganizo chikangowoneka chizindikiro chakuda (lembani chikhomo), gwirani batani lakumanzere la mbewa ndikulikokera ku selo yomaliza yomwe mukufuna kuwerengera.
6. Chilichonse chakonzeka, chifukwa cha chophweka ichi, tinatha kusinthira mwachangu maola kukhala mphindi pazofunikira zonse.

Njira 2: KUSINTHA ntchito

Pamodzi ndi kuchulukitsa mwachizolowezi, Excel ili ndi ntchito yapadera KUSINTHAkutembenuza maola kukhala mphindi.

Ndikofunika kukumbukira kuti ntchitoyi imangogwira ntchito pamene nthawi ikuimiridwa mumtundu "General". Pankhaniyi, mwachitsanzo, nthawi "04:00" iyenera kulembedwa ngati nambala yosavuta 4, "05:30" - Bwanji "5,5". Komanso, njira imeneyi ndi yabwino pamene ife basi ayenera kuwerengera chiwerengero cha mphindi lolingana ndi chiwerengero anapatsidwa maola, popanda kuganizira peculiarities dongosolo mawerengedwe mu pulogalamu, amene anakambidwa mu njira yoyamba.

1. Timanyamuka m'chipinda chomwe tikufuna kuwerengera. Pambuyo pake, dinani batani "Ikani ntchito" (fx) kumanzere kwa formula bar.
2. Pazenera loyika ntchito, sankhani gulu "Engineering" (kapena “Mndandanda wa zilembo zonse”), dinani pamzere ndi ntchitoyo "CONVERTER", kenako ndi batani OK.
3. Iwindo lidzatsegulidwa momwe tiyenera kudzaza mfundo za ntchito:
   • m'munda "Nambala" tchulani adilesi ya cell yomwe mtengo wake mukufuna kusintha. Mutha kuchita izi polowetsa ma coordinates pamanja, kapena kungodina kumanzere pa cell yomwe mukufuna patebulo lokha (pamene cholozera chiyenera kukhala m'munda kuti mulowe mtengo).
   • Tiyeni tipitirire kukangana. "Original unit of measure". Apa tikuwonetsa ma code a wotchi - "hr".
   • Monga gawo lomaliza la kuyeza, tikuwonetsa nambala yake - "mm".
   • mukakonzeka, dinani batani OK.
4. Chotsatira chofunikira chidzawonekera mu selo ndi ntchito.
5. Ngati tifunika kuwerengera gawo lonse, monga momwe tachitira poyamba, tidzagwiritsa ntchito lembani chikhomopochikokera pansi.

Kutsiliza

Chifukwa chake, kutengera njira ndi zotsatira zomwe mukufuna mu Excel, mutha kusintha maola kukhala mphindi pogwiritsa ntchito njira ziwiri zosiyana. Aliyense wa iwo ndi wothandiza mwa njira yake, pamene kuwadziwa sikovuta.