Kushandura maawa kusvika kumaminitsi muExcel nenzira dzakasiyana

Kushandura maawa kusvika kumaminitsi ibasa rakajairika, iro dzimwe nguva rinodiwa muExcel. Pakutanga kuona, zvinoratidzika kuti izvi zvinogona kuitwa muchirongwa pasina kuoma kukuru. Nekudaro, mukuita, vamwe vashandisi vanogona kusangana nematambudziko nekuda kwezvimiro zvechirongwa. Naizvozvo, pazasi isu tichatarisa maitiro aungaita maawa kuita maminetsi muExcel uchishandisa nzira dzakasiyana.

Shandura maawa kuita maminetsi

Sezvatataura pamusoro, Excel ine ficha ine yakakosha nguva yekuverengera chirongwa chinosiyana nechakajairwa. Muchirongwa, maawa makumi maviri nemana akaenzana nerimwe, uye maawa gumi nemaviri anoenderana nenhamba 24 (hafu yezuva rose).

Ngatitii tine sero rine kukosha mufomati yenguva.

Dzvanya pane yazvino fomati (tab "Kumba", chikamu chezvishandiso “Nhamba”) uye sarudza iyo general fomati.

Somugumisiro, isu tichanyatsowana nhamba - iri mune iyi fomu iyo purogiramu inoona nguva inoratidzwa muchitokisi chakasarudzwa. Nhamba yacho inogona kuva pakati pe0 ne1.

Naizvozvo, pakusandura maawa kuva maminitsi, tinofanira kurangarira rutivi urwu rwepurogiramu.

Nzira 1: Kushandisa Formula

Iyi nzira ndiyo yakapfava uye inosanganisira kushandiswa kwefomati yekuwanza. Kushandura maawa kuita maminetsi, unofanira kutanga wawedzera nguva yawakapihwa 60 (nhamba yemaminitsi muawa imwe), ipapo - pa 24 (nhamba yemaawa pazuva rimwe). Nemamwe manzwi, tinofanirwa kuwanza nguva nenhamba 1440. Ngatiedzei izvi nemuenzaniso unoshanda.

1. Isu tinosimuka muchitokisi umo tinoronga kuratidza mhedzisiro muchimiro chenhamba yemaminetsi. Nekuisa chiratidzo chakaenzana, tinonyora fomura yekuwedzera mairi. Iko kurongeka kwesero ine kukosha kwepakutanga (munyaya yedu - C4) inogona kutaurwa nemaoko, kana nekungodzvanya pairi nebhatani rekuruboshwe. Tevere, dzvanya kiyi pinda.
2. Nekuda kweizvozvo, hatiwane izvo zvataitarisira, zvinoti, kukosha "0:00".
3. Izvi zvakaitika nekuda kwekuti kana ichiratidza chigumisiro, purogiramu inotarisa pamafomati emasero anobatanidzwa mufomu. Avo. kwatiri isu, sero rinobuda rinopihwa iyo fomati "Nguva". Chinja kuti "General" unogona sezvazviri mu tab "Kumba" (block of tools “Nhamba”), sezvakakurukurwa pamusoro apa, uye muhwindo refomati yesero, iyo inogona kuwanikwa kuburikidza nemenu yemukati yesero, inodanwa nekudzvanya-kurudyi pairi.Paunenge uri mufafitera rekufometa mune runyorwa kuruboshwe, sarudza mutsara "General" uye tinya bhatani OK.
4. Nekuda kweizvozvo, tichawana huwandu hwese hwemaminetsi munguva yakapihwa.
5. Kana iwe uchida kushandura maawa kuita maminetsi ekoramu yese, hazvifanirwe kuita izvi zvakasiyana kune yega yega sero, nekuti maitiro anogona otomatiki. Kuti uite izvi, fambisa pamusoro pesero neformula nekukurumidza kana chiratidzo chitema chabuda (fill marker), bata bhatani rekuruboshwe woridhonzera pasi kune yekupedzisira sero yaunoda kuverengera zvinoenderana nayo.
6. Zvese zvakagadzirira, nekuda kwechiito ichi chiri nyore, takakwanisa kukurumidza kushandura maawa kuita maminetsi kune ese makolamu kukosha.

Nzira 2: Shandura basa

Pamwe chete nekuwandisa kwakajairika, Excel ine basa rakakosha KUSHANDURAkushandura maawa kuita maminetsi.

Zvakakosha kuyeuka kuti basa rinoshanda chete kana nguva inomiririrwa mufomati "General". Muchiitiko ichi, semuenzaniso, nguva "04:00" inofanira kunyorwa senhamba iri nyore 4, "05:30" - sei "5,5". Zvakare, iyi nzira yakakodzera chete kana tikangoda kuverenga huwandu hwemaminitsi anoenderana nehuwandu hwemaawa, pasina kufunga nezvezvakanyorwa zvehurongwa hwekuverenga muchirongwa, icho chakakurukurwa nenzira yekutanga.

1. Tinosimuka muchitokisi chatinoda kuita masvomhu. Mushure meizvozvo, tinya bhatani "Isa basa" (fx) kuruboshwe rweformula bar.
2. Muwindo rekuisa mabasa, sarudza chikamu "Engineering" (kana “Runyorwa ruzere rwearufabheti”), tinya pamutsetse une basa racho “CONVERTER”, ipapo nebhatani OK.
3. Hwindo rinovhurika ratinoda kuzadza mashandiro enharo:
   • mumunda “Nhamba” tsanangura kero yesero ine kukosha kwaunoda kushandura. Iwe unogona kuita izvi nekupinda macoordinates nemaoko, kana kungo dzvanya-kuruboshwe pane yaunoda sero mutafura pachayo (apo iyo cursor inofanirwa kunge iri mumunda wekupinda kukosha).
   • Ngatienderere mberi kune nharo. "Original unit of measure". Pano tinoratidza kodhi dhizaini yewachi - “hr”.
   • Sechikamu chekupedzisira chekuyera, tinoratidza kodhi yayo - “mm”.
   • kana wagadzirira, tinya bhatani OK.
4. Mhedzisiro inodiwa ichaonekwa muchitokisi ine basa.
5. Kana isu tichida kuita masvomhu ekoramu yese, senge munzira yekutanga, isu tichashandisa fill markernokuidhonzera pasi.

mhedziso

Saka, zvichienderana nemaitiro uye mhedzisiro yaunoda muExcel, unogona kushandura maawa kuita maminetsi uchishandisa nzira mbiri dzakasiyana. Chimwe nechimwe chazvo chinoshanda nenzira yaro, asi kuvabata hakuna kuoma.