Momwe mungadulire nthawi

Chimodzi mwazinthu zomwe zingakhale pamaso pa ogwiritsa ntchito pomwe mukugwira ntchito bwino ndikuwonjezera nthawi. Mwachitsanzo, funso lino limatha kuchitika pokonzanso nthawi yogwira ntchito. Mavuto amakhudzana ndi kuti nthawi siimayezedwa mu dongosolo lomwe limadziwika bwino, momwe ambiri amagwirira ntchito. Tiyeni tiwone momwe mungafotokozere mwachidule nthawi yomwe ili mu pulogalamuyi.

Kutalika kwa nthawi

Pofuna kupanga njira yokumbukira nthawi, choyamba, maselo onse omwe amatenga nawo mbali pantchitoyo ayenera kukhala ndi mtundu. Ngati sichoncho, ndiye kuti ayenera kuwongoleredwa. Mtundu wa madela ukhoza kuwonedwa atasankhidwa mu tabu yakunyumba mu tepi yapadera pa tepi mu "nambala" chida.

1. Sankhani maselo ofanana. Ngati ndi mtundu, ndiye ingomezani batani lamanzere ndikungobweretsa. Pakachitika kuti tikuchita ndi maselo amodzi omwazika pa pepalalo, ndiye kuti magawowa amachitika, pakati pa zinthu zina, pogwira batani la Ctrl pa kiyibodi.
2. Mwa kuwonekera batani la mbewa lamanja, potero kuyimbira menyu. Pitani kudzera mu chinthucho "Fomu ya Fomu ...". M'malo mwake, mutha kutsitsanso Ctrl + 1 pa kiyibodi.



3. Zenera lotseguka limatsegulidwa. Pitani ku "nambala yakuti" nambala ya "ngati itatsegulidwa mu tabu ina. Mu "mitundu ya manambala", timakonzanso kusintha kwa "nthawi". Kumbali yakumanja kwa zenera mu "Mtundu" block, sankhani mtundu wa chiwonetsero chomwe tidzagwira ntchito. Kukhazikitsa kumapangidwa, dinani batani la "OK" pansi pazenera.

Phunziro: Kupanga matebulo ku Excel

Njira 1: Onani kuwerenga nthawi yayitali

Choyamba, tiyeni tiwone momwe mungawerengere kuchuluka kwa maola ambiri, kuwonetsedwa m'maola, mphindi ndi masekondi. M'mafanizo athu, muyenera kudziwa kuti zidzakhala zochuluka motani pa ola limodzi mphindi 45 ndi masekondi 51, ngati mwaikidwa pa iwo 13:26:06.

1. Pa gawo lopangidwa ndi pepalalo m'maselo osiyanasiyana pogwiritsa ntchito kiyibodi, timalowetsa deta "13:26:06" ndi "1:4511".



2. Mu selo lachitatu, pomwe mtundu wake umayikidwanso, ikani chizindikirocho "=". Kenako, dinani pa cell "13:26:06", timadina chikwangwani cha "+" pa kiyibodi ndikudina pa cell ndi mtengo wake "1:45:511".



3. Pofuna zotsatira za kuwerengetsa kuwonetsa pazenera, dinani pa batani "Lowani".

Chidwi! Kugwiritsa ntchito njirayi, mutha kudziwa kuti ndi maola angati omwe angawonekere pambuyo pa nthawi yayitali. Pofuna "kudumpha" mzere watsiku ndi tsiku ndikudziwa nthawi yowonetsera wotchi, onetsetsani kuti mwapanga mtundu wa mawonekedwe ndi asterisk, monga chithunzi pansipa.

Njira 2: Kugwiritsa Ntchito Ntchito

Njira ina ku njira yapita ndikugwiritsa ntchito kuchuluka kwa kuchuluka kwa kuchuluka kwake.

1. Pambuyo pa deta yoyamba (kuwerenga nthawi yapano kwa wotchi ndi nthawi) yalowetsedwa, sankhani foni yosiyana. Dinani pa batani la "phala ntchito".



2. Wizard akutsegula. Tikuyang'ana pamndandanda wa zinthu zomwe zimachitika "Sum". Tikutsindika ndikusindikiza batani la "OK".



3. Zenera lokangana limayamba. Timakhazikitsa cholozera mu "nambala ya" nambala1 "ndi cell ya cell yomwe ili ndi nthawi yapano. Kenako ikani cholembera mu "gawo la" nambala2 "ndikudina pafoni, pomwe nthawi yatchulidwa. Pambuyo pa minda yonse yadzaza, kanikizani batani la "OK".



4. Monga mukuwonera, kuwerengetsa kumachitika ndipo zotsatira za nthawi yawonetsedwa mu chipinda chosankhidwa choyambirira.

Phunziro: Mzere wa Wizard mu Excel

Njira 3: Nthawi Zonse

Koma nthawi zambiri muzochita, ndikofunikira kuti musadziwe kuwerenga kwa maola panthawi inayake, koma kuti mufikire nthawi yonseyi. Mwachitsanzo, izi zimafunikira kuti mudziwe kuchuluka kwa maola ambiri. Pazifukwa izi, mutha kugwiritsa ntchito imodzi mwazinthu ziwiri zomwe zafotokozedwazo: chowonjezera kapena kugwiritsa ntchito kuchuluka kwa kuchuluka kwa ndalamazo. Koma, koposa zochulukirapo pamenepa, gwiritsani ntchito chida chotere monga kesa mgalimoto.

1. Koma, choyamba, tifunika kupanga maselo m'njira ina, osati momwe zimafotokozedwera m'mbuyomu. Sankhani malowa ndikuyitanitsa zenera. Mu "nambala ya" tabu, timakonzanso "mitundu ya manambala" kusinthana kupita ku "zapamwamba". Pa gawo loyenera la zenera lomwe timapeza ndikukhazikitsa mtengo "[H]: MM: SS". Kusunga kusintha, dinani batani la "OK".



2. Kenako, muyenera kutsindika za kuchuluka kwa mtengo wake ndi khungu limodzi pambuyo pake. Kukhala pa tabu yakunyumba, dinani pakona, yomwe ili pa tepi pa tepi yokonza chida. Monga njira ina, mutha kuyimba "Alt + =" Keyboard pa kiyibodi.



3. Pambuyo pa izi, zotsatira za kuwerengera zimawonekera mu chipinda chosankhidwa opanda kanthu.

Phunziro: Momwe mungawerengere ndalamazo

Monga mukuwonera, pali mitundu iwiri ya nthawi yopukutira pa Excel: Kuchulukitsa kwathunthu kwa nthawi ndi kuwerengera kwa malowo pambuyo pa nthawi inayake. Pofuna kuthana ndi iliyonse mwazinthu izi pali njira zingapo. Wogwiritsa ntchitoyo ayenera kudziwa njira inayake pamlandu wina ndi yoyenera.