Chimodzi mwazinthu zomwe wogwiritsa ntchito angakumane nazo akugwira ntchito ku Excel ndi kuwonjezera nthawi. Mwachitsanzo, nkhaniyi imatha kuchitika mukalemba nthawi yantchito. Zovutazi zimalumikizidwa ndikuti nthawi siyimawerengeredwa munthawi yantchito, momwe Excel imagwirira ntchito mwachisawawa. Tiyeni tiwone momwe tingafotokozere mwachidule nthawi yofunsira izi.
Nthawi DRM
Pofuna kukwaniritsa njira yotchulira nthawi, choyambirira, maselo onse omwe amatenga nawo mbali pa ntchitoyi ayenera kukhala ndi nthawi. Ngati sizili choncho, ndiye kuti akuyenera kuti azisanjidwa moyenerera. Mitundu yamakono ya maselo imatha kuwonedwa mutasankha iwo tabu "Pofikira" m'munda wokonzedwa mwapadera pa riboni m'bokosi la chida "Chiwerengero".
- Sankhani maselo ofanana. Ngati izi ndi zingapo, ingotsitsani batani lakumanzere ndikuzungulira. Ngati tikuchita ndi maselo amodzi omwazikana ndi pepala, ndiye kuti timasankha, mwa zina, atanyamula batani Ctrl pa kiyibodi.
- Timadina molondola, potipangitsa kusinthitsa mitu yankhani yonse. Pitani ku chinthucho "Mtundu wamtundu ...". M'malo mwake, mutha kuyang'ananso kuphatikiza pambuyo powunikira pa kiyibodi Ctrl + 1.
- Tsamba losintha likutsegulidwa. Pitani ku tabu "Chiwerengero"ngati idatsegulidwa patsamba lina. Pakadutsa magawo "Mawerengero Amanambala" sinthani kusintha kwa malo "Nthawi". Gawo lamanja la zenera mu chipika "Mtundu" timasankha mtundu wamawonekedwe omwe tidzagwirira nawo ntchito. Pambuyo khwekhwe litatha, dinani batani "Zabwino" pansi pazenera.
Phunziro: Kukhazikitsa matebulo ku Excel
Njira 1: kuwonetsa patatha maola angapo
Choyamba, tiyeni tiwone momwe tingawerengere kuti ndi maora angati adzawonetsetse nthawi yayitali, yowonetsedwa m'maola, mphindi ndi masekondi. Pachitsanzo chathu, tiyenera kudziwa kuchuluka kwa zomwe zidzakhalepo pa ola limodzi ndi mphindi 45 ndi masekondi 51 ngati nthawiyo ndi 13:26:06.
- Pa gawo lojambulidwa la pepalali m'maselo osiyanasiyana pogwiritsa ntchito kiyibodi, lowetsani deta "13:26:06" ndi "1:45:51".
- Mu khungu lachitatu, momwe mawonekedwe ake adakhazikitsidwanso, ikani chizindikiro "=". Kenako, dinani pa foni patapita nthawi "13:26:06", dinani chizindikiro cha "+" pa kiyibodi ndikudina foni ndi mtengo "1:45:51".
- Kuti muwonetsetse zowerengera, dinani batani "Lowani".
Yang'anani! Pogwiritsa ntchito njirayi, mutha kudziwa kuti ndi maora angati omwe adzawonetsetse pakapita nthawi yochepa mkati mwa tsiku limodzi. Kuti muzitha "kudumpha" pazaka zonse komanso kudziwa nthawi yomwe mawotchi adzawonetse, ndikofunikira kusankha mtundu wamtundu wa asterisk mukamapanga maselo, monga chithunzi pansipa.
Njira 2: gwiritsani ntchito ntchito
Njira ina yanjira yapita ndikugwiritsa ntchito ntchitoyo SUM.
- Datha yayikulu (koloko yatsopanoyo ndi nthawi yake) zikalowetsedwa, sankhani khungu limodzi. Dinani batani "Ikani ntchito".
- Wizard wa Ntchito akutsegulidwa. Tikuyang'ana ntchito mndandanda wazinthu SUM. Sankhani ndikudina batani. "Zabwino".
- Ntchito yotsutsana ndi ntchito imayamba. Khazikitsani chotembezera m'munda "Nambala1" ndikudina khungu lomwe lili ndi nthawi yapano. Kenako ikani cholozera kumunda "Nambala2" ndikudina foni yomwe nthawi yomwe ikufunika iwonjezedwe. Pambuyo poti magawo onse atsirizidwa, dinani batani "Zabwino".
- Monga mukuwonera, kuwerengera kumachitika ndipo zotsatira zake zowonjezera nthawi zimawonetsedwa mu khungu lomwe lidasankhidwa koyamba.
Phunziro: Ntchito Wizard ku Excel
Njira 3: kuwonjezera nthawi
Koma pafupipafupi pochita, simuyenera kudziwa kuti wotchiyo itadutsa nthawi inayake, koma onjezerani nthawi yonseyo. Mwachitsanzo, izi zimafunikira kuti mudziwe kuchuluka kwa maola omwe agwira ntchito. Pazifukwa izi, mutha kugwiritsa ntchito imodzi mwanjira ziwiri zomwe zafotokozedwapo kale: kuphatikiza kosavuta kapena kugwiritsa ntchito ntchito SUM. Koma, pankhaniyi ndikosavuta kugwiritsa ntchito chida chotere ngati kuchuluka kwa galimoto.
- Koma, choyamba, tifunikira kukonza maselo mwanjira ina, osati monga momwe tafotokozera m'mbuyomu. Sankhani dera ndikuyitanitsa mawonekedwe. Pa tabu "Chiwerengero" sinthani kusinthaku "Mawerengero Amanambala" m'malo "Zotsogola". Gawo lamanja la zenera timapeza ndikuyika mtengo wake "[h]: mm: ss". Kuti musunge masinthidwe, dinani batani "Zabwino".
- Kenako, sankhani masanjidwe odzaza ndi nthawi ndi foni imodzi yopanda pambuyo pake. Kukhala pa tabu "Pofikira"dinani pachizindikiro "Ndalama"ili pa tepi pachiboliboli chida "Kusintha". Kapenanso, mutha kulemba njira yachidule pa kiyibodi "Alt + =".
- Pambuyo pa izi, zotsatira za kuwerengera zimawonekera mu khungu lopanda kanthu.
Phunziro: Momwe mungawerengere kuchuluka kwa Excel
Monga mukuwonera, pali mitundu iwiri ya kuwonjezera nthawi mu Excel: kuwonjezeredwa kwa nthawi yonse ndi kuwerengera kwa mawonekedwe a wotchi itatha nthawi inayake. Pali njira zingapo zothetsera mavuto onsewa. Wogwiritsa ntchitoyo ayenera kusankha njira yomwe ingamuyenerere.
