Uburyo bwo kuzibika umwanya muri excel

Imwe mu mirimo ishobora kuba imbere yumukoresha mugihe ukora muri Excel ni cyo gihe cyongeyeho igihe. Kurugero, iki kibazo gishobora kubaho mugihe ushushanya mugihe cyakazi. Ingorane zifitanye isano nukuri ko igihe kidapimwe muri sisitemu icumi imenyerewe, aho extl ikora muburyo busanzwe. Reka tumenye uburyo bwo kuvuga muri make igihe muriyi porogaramu.

Incamake yigihe

Kugirango utange gahunda yo gukina, mbere ya byose, selile zose zigira uruhare muri iki gikorwa zigomba kugira imiterere yigihe. Niba atari byo, bigomba guhindurwa ukurikije. Imiterere yingingo igezweho irashobora kurebwa nyuma yo gutoranywa muri tab yo murugo muburyo bwihariye bwo gutunganya kuri kaseti muri "Umubare" wibikoresho ".

1. Hitamo selile zijyanye. Niba ari intera, noneho kura gusa buto yimbeba yibumoso hanyuma ubisubizemo. Mugihe turimo guhangana ningirabuzimafatizo kugiti cye katatanye kurupapuro, hanyuma kugenera aba bikorwa, mubindi, mugufata buto ya CTRL kuri clavier.
2. Mugukanda buto yimbeba iburyo, bityo uhamagare ibikubiyemo. Genda unyuze mubintu "imiterere ingirabuzimafatizo ...". Ahubwo, urashobora kandi gukuramo Ctrl + 1 guhuza kuri clavier.



3. Idirishya rifungura. Jya kuri tab "umubare" niba wafunguye indi tab. Muri "imiterere ya numero", tugana kumwanya wa "igihe". Kuruhande rwiburyo bwidirishya muri "ubwoko", hitamo ubwoko bwerekana tuzakora. Nyuma yo gushiraho, kanda kuri buto ya "OK" hepfo yidirishya.

Isomo: Imbonerahamwe ya Excel

Uburyo 1: Reba gusoma unyuze mugihe intera

Mbere ya byose, reka turebe uburyo bwo kubara amasaha azerekanwa nyuma yigihe runaka, bwerekanwe mumasaha, iminota namasegonda. Murugero rwihariye, ugomba kumenya uko bizaba kumasaha nyuma yamasaha 1 iminota 45 n'amasegonda 51, niba ubashishikarijwe kuri bo 13:26:06.

1. Ku gice cyakozwe cyurupapuro mu tugari dutandukanye ukoresheje clavier, twinjira mu makuru "13:26:06" na "1:45:51".



2. Muri selile ya gatatu, aho imiterere yigihe yashizwemo, shyira ikimenyetso "=". Ibikurikira, kanda ku Kagari Mugihe "13:26:06", tukabasimba ku "mujyi" kuri clavier hanyuma ukande ku kagari "1:45:51:51".



3. Kugirango ibisubizo byo kubara byerekana kuri ecran, kanda kuri buto "Enter".

Icyitonderwa! Gushyira mu bikorwa ubu buryo, urashobora kumenya umubare wamasaha azerekana nyuma yigihe runaka mugihe cyumunsi umwe. Kugirango "usimbukire" kumurongo wa buri munsi kandi umenye igihe cyo kwerekana isaha, menya neza ko uhinduranya selile, ugomba guhitamo ubwoko bwimiterere hamwe ninyenyeri, nko mu ishusho hepfo.

Uburyo 2: Gukoresha imikorere

Ubundi buryo bwo muburyo bwabanjirije ni ugukoresha umubare wamafaranga.

1. Nyuma yamakuru yibanze (igihe cyubu gisomye isaha nigihe) cyinjiye, hitamo selile itandukanye. Kanda kuri buto ya "Paste.



2. Umupfumu arakingura. Turimo gushakisha kurutonde rwibintu imikorere "amafaranga". Turabigaragaza kandi tugakanda buto "OK".



3. Idirishya ry'ibiganiro ritangira. Dushiraho indanga muri "Umubare1" na clique ya selile ikubiyemo igihe. Noneho shyira indanga muri "Umubare" hanyuma ukande ku kagari, aho igihe cyagenwe cyongeweho. Nyuma yimirima yombi yuzuye, kanda buto "OK".



4. Nkuko mubibona, kubara bibaho nibisubizo byigihe cyo kongerwaho birerekanwa mu kagari watoranijwe.

Isomo: Umukozi wa Wizard muri Excel

Uburyo 3: Igihe cyose cyongeyeho

Ariko kenshi mubikorwa, birakenewe kugirango tumenye gusoma amasaha mugihe runaka, ahubwo ni ukubike igihe cyose. Kurugero, ibi birasabwa kumenya umubare wamasaha yakazi. Kuri izo ntego, urashobora gukoresha imwe muburyo bubiri bwasobanuwe: kongera byoroshye cyangwa gushyira mu bikorwa umubare w'amafaranga. Ariko, byoroshye cyane muri uru rubanza, koresha igikoresho nkigikoresho nkimodoka mosmy.

1. Ariko, icya mbere, tuzakenera gushiraho ingirabuzimafatizo muburyo butandukanye, ntabwo buke uko byasobanuwe muri verisiyo zabanjirije iyi. Hitamo akarere hanyuma uhamagare idirishya. Muri kaburimbo "umubare", twe trarrange "train formats" guhinduranya "umwanya". Mu gice cyiburyo cyidirishya dusangamo kandi ushireho agaciro "[h]: mm: SS". Gukiza impinduka, kanda kuri buto "OK".



2. Ibikurikira, ugomba kwerekana urwego rwuzuye agaciro keza hamwe na selile imwe irimo ubusa nyuma yayo. Kuba kuri tab ya Murugo, kanda ku gishushanyo cyamafaranga, giherereye kuri kaseti murwego rwo guhindura ibikoresho. Nkubundi buryo, urashobora guhamagara "alt + =" Mwandikisho ya "kuri clavier.



3. Nyuma yibi bikorwa, ibisubizo byo kubara bizagaragara muri selire yatoranijwe.

Isomo: Nigute ushobora kubara amafaranga muri Excel

Nkuko mubibona, hari ubwoko bubiri bwo kuzimya muri Excel: hiyongereyeho igihe no kubara umwanya wisaha nyuma yigihe runaka. Gukemura buri gikorwa Hariho inzira nyinshi. Umukoresha ubwe agomba kumenya uburyo bwihuse kugiti cye bizamubera.