Imodzi mwa ntchito zomwe munthu angagwiritse ntchito pamene akugwira ntchito ku Excel ndi Kuwonjezera kwa nthawi. Mwachitsanzo, funsoli likhoza kuchitika pokonzekera nthawi yogwira ntchito pulogalamuyi. Mavuto ali okhudzana ndi kuti nthawi sichiwerengedwa mu dongosolo lachimidzi lomwe ndilodziwika kwa ife, momwe Excel imagwira ntchito mwachindunji. Tiyeni tipeze momwe tingagwiritsire ntchito nthawi mu pulogalamuyi.
Nthawi yotsiriza
Pofuna kutulutsa ndondomeko ya nthawi, poyamba, maselo onse omwe amagwira nawo ntchitoyi ayenera kukhala ndi mawonekedwe a nthawi. Ngati siziri choncho, ziyenera kupangidwa moyenera. Selo yamakono yatsopano imatha kuwonekera pakusankhidwa kwawo mu tab "Kunyumba" mu gawo lapadera lopangira ma tepi pa tepi mu bokosi la zida "Nambala".
- Sankhani maselo ofanana. Ngati izi ndi zosiyana, ndiye ingokaniza batani lamanzere ndi kuzungulira. Ngati tikulimbana ndi maselo omwe amwazikana pa pepala, ndiye kuti timasankha, mwa zina, pogwiritsa ntchito batani Ctrl pabokosi.
- Timasankha botani lamanja la mouse, motero timatchula mndandanda wa masewera. Pitani kupyolera mu chinthucho "Sungani maselo ...". Mwinanso, mungathe kupanganso kuphatikiza mutatha kuyika pa kambokosi. Ctrl + 1.
- Zowonetsera zojambula zimatsegula. Pitani ku tabu "Nambala"ngati ilo latsegulidwa mu tabu lina. Muzitsulo zamkati "Maofomu Owerengeka" Sinthani kusintha kwa malo "Nthawi". Kumanja kwawindo pazenera Lembani " sankhani mtundu wa mawonetsero omwe tidzakhala nawo. Mukatha kukonza, dinani pa batani. "Chabwino" pansi pazenera.
Phunziro: Kupanga tebulo la Excel
Njira 1: Kuwonetsera nthawi patapita nthawi
Choyamba, tiyeni tiwone momwe tingawerengere maola angati omwe adzasonyezedwe patapita nthawi, atchulidwa maola, mphindi ndi masekondi. Muchitsanzo chathu chokha, muyenera kudziwa kuti nthawi idzakhala yotani pakatha ola limodzi mphindi 45 ndi mphindi zisanu ndi zisanu, ngati nthawi yayikidwa nthawi 13:26:06.
- Pachigawo chokongoletsedwa cha pepala mumaselo osiyanasiyana pogwiritsa ntchito kamphindi kulowetsa deta "13:26:06" ndi "1:45:51".
- Mu selo lachitatu, momwe mawonekedwe a nthawi amakhalanso, yikani chizindikiro "=". Kenaka, dinani selo ndi nthawi "13:26:06"Dinani pa "+" chizindikiro pa khibhodi ndipo dinani selo ndi mtengo "1:45:51".
- Kuti muwonetse zotsatira za mawerengedwe, dinani pa batani Lowani ".
Chenjerani! Pogwiritsa ntchito njirayi, mungathe kupeza maola angati omwe adzasonyezedwe patatha nthawi yeniyeni pokhapokha tsiku limodzi. Kuti mukhoze "kudumphira" pa malire a tsiku ndi tsiku ndikudziwa nthawi yowonjezera, nthawi zonse muyenera kusankha mtundu wa mapulogalamu ndi asterisk pamene maselo opanga mawonekedwe, monga fano ili pansipa.
Njira 2: Gwiritsani ntchito ntchitoyi
Njira ina yotsata njira yapitayi ndiyo kugwiritsa ntchito ntchitoyi SUM.
- Pambuyo pa deta yapadera (kuwerenga kwa ola limodzi ndi kutalika kwa nthawi) mwalowa, sankhani selo losiyana. Dinani pa batani "Ikani ntchito".
- Ntchito wiziti imatsegulidwa. Ife tikuyang'ana ntchito mu mndandanda wa zinthu "SUMM". Sankhani ndipo dinani pa batani. "Chabwino".
- Ntchito yotsutsana zenera ikuyambitsidwa. Ikani cholozera mmunda "Number1" ndipo dinani selo yomwe ili ndi nthawi yamakono. Kenaka ikani malonda mmunda "Number2" ndipo dinani selo, zomwe zimasonyeza nthawi yomwe mukufuna kuwonjezera. Zonse ziwiri zitatha, dinani pa batani "Chabwino".
- Monga mukuonera, kuwerengera kumachitika ndipo zotsatira za nthawi kuwonjezera zikuwonetsedwa mu selo yoyamba.
Phunziro: Wowonjezera Wogwira Ntchito
Njira 3: Kuwonjezera kwa nthawi
Koma kawiri kawiri pakuchita zofunikira n'kosafunika kudziwa nthawi yeniyeni, koma kuwonjezera nthawi yonse. Mwachitsanzo, izi zimafunika kudziwa nthawi yonse ya maola ogwira ntchito. Pogwiritsa ntchito njira ziwirizi, mungagwiritse ntchito njira imodzi yofotokozedwa kale: Kuphweka kwapafupi kapena kugwiritsa ntchito ntchitoyi SUM. Koma, ndizosavuta kwambiri pakadali pano kugwiritsa ntchito chida choterocho ngati ndalama yamagalimoto.
- Koma, choyamba tidzasintha ma selo mosiyana, osati monga momwe tafotokozera m'matembenuzidwe apitalo. Sankhani dera ndikuitana fomatiyiyi. Mu tab "Nambala" sintha zosintha "Maofomu Owerengeka" mu malo "Zapamwamba". Mu gawo labwino lawindo timapeza ndikuyika mtengo "[h]: mm: ss". Kuti musinthe kusintha, dinani pa batani. "Chabwino".
- Chotsatira, muyenera kusankha mtundu umene uli ndi phindu la nthawi ndi selo limodzi lopanda kanthu. Kukhala pa tab "Kunyumba", dinani pazithunzi "Mtengo"ili pa tepi muzitali za zida Kusintha. Monga njira ina, mungathe kufotokozera njira yomasulira "Alt + =".
- Pambuyo pazimenezi, zotsatira za mawerengedwe zidzawoneka mu selo losasankhidwa.
Phunziro: Momwe mungawerengere ndalama mu Excel
Monga mukuonera, pali mitundu iwiri ya kuwonjezera kwa nthawi mu Excel: Kuwonjezerapo nthawi ndi kuwerengera kwa malo a maola pambuyo pake. Pofuna kuthetsa mavuto onsewa, pali njira zingapo. Wogwiritsa ntchito mwiniwakeyo ayenera kusankha chomwe angapereke payekhapayekha.
