Pogwira ntchito ndi nthawi mu Excel, nthawizina pamakhala vuto la kutembenuza maola mphindi. Zingakhale zosavuta, koma nthawi zambiri zimakhala zovuta kwa ogwiritsa ntchito ambiri. Ndipo chinthucho chiri m'zochitika za kuwerengera nthawi pulogalamuyi. Tiyeni tiwone momwe tingatanthauzire maora mu mphindi ku Excel m'njira zosiyanasiyana.
Sinthani maola mpaka mphindi mu Excel
Kuvuta konse kwa kutembenuza maola mphindi ndikuti Excel amaona nthawi osati mwachizolowezi kwa ife, koma monga masiku. Izi ndizo, pulogalamu iyi, maola 24 ndi ofanana ndi amodzi. Nthawiyi ndi 12:00, pulogalamuyi ndi 0,5, chifukwa maola 12 ndi 0,5 gawo limodzi.
Kuti muwone momwe izi zikuchitikira ndi chitsanzo, muyenera kusankha selo iliyonse pa pepala mu nthawi yake.
Kenaka mawonekedwewo akhale osiyana. Ndi chiwerengero chomwe chidzawonekera mu selo chomwe chidzawonetsera malingaliro a pulogalamu ya deta yomwe yalowa. Zomwe zimapanga zimatha kusiyana 0 mpaka 1.
Choncho, funso loti mutembenuke maola ndi mphindi muyenera kuyandikira kudzera mu ndende ya mfundo iyi.
Njira 1: Kugwiritsa Ntchito Kuwonjezera Malamulo
Njira yosavuta yosinthira maola ndi mphindi ndikuchulukitsa ndi chinthu china. Pamwamba, tapeza kuti Excel amadziwa nthawi mu masiku. Kotero, kuti mutenge mphindi pang'ono kuchokera ku mawu, mukuyenera kuonjezera mawu omwewo 60 (chiwerengero cha mphindi maola) ndi 24 (maola ambiri pa tsiku). Choncho, coefficient yomwe tidzafunika kuonjezera mtengo idzakhala 60×24=1440. Tiyeni tiwone momwe ziwonekere pakuchita.
- Sankhani selo yomwe ili ndi zotsatira zomaliza mu mphindi. Ife timayika chizindikiro "=". Dinani mu selo limene deta ilipo maola. Ife timayika chizindikiro "*" ndipo lembani chiwerengerocho kuchokera ku keyboard 1440. Kuti pulogalamuyi igwiritse ntchito deta ndikuwonetsa zotsatira, dinani pa batani Lowani.
- Koma zotsatira zingakhalebe zolakwika. Izi zikuchitika chifukwa chokonzekera deta ya mawonekedwe a nthawiyo kudzera mu njirayi, selo limene chiwonetserocho chikuwonetsedwa, ichocho chimapeza mawonekedwe omwewo. Pankhaniyi, iyenera kusinthidwa kukhala yeniyeni. Kuti muchite izi, sankhani selo. Kenaka pita ku tabu "Kunyumba"ngati ife tiri mu lina ndipo tisiyeni pa malo apadera omwe mawonekedwe amasonyezedwa. Ipezeka pa tepiyi mu zida za zipangizo. "Nambala". Pakati pa ndondomeko zamakhalidwe m'ndandanda yomwe imatsegulidwa, sankhani chinthucho "General".
- Zitatha izi, selo lolankhulidwa lidzawonetsa deta yolondola, zomwe zidzakhala zotsatira za maola osintha mpaka mphindi.
- Ngati muli ndi mtengo woposa umodzi, koma mndandanda wonse wa kutembenuka, simungathe kuchita ntchitoyi pamwamba pa mtengo uliwonse padera, koma lembani fomuyo pogwiritsa ntchito chikhomo chodzaza. Kuti muchite izi, ikani cholozeracho kumbali ya kumanja ya selo ndi ndondomekoyi. Tikudikira chizindikiro chodzaza kuti chikhale ngati mtanda. Gwirani batani lamanzere la mouse ndi kukokera chithunzithunzi chofanana ndi maselo ndi deta yosinthidwa.
- Monga mukuonera, mutatha kuchita izi, mfundo za mndandanda wonse zidzasinthidwa mphindi.
Phunziro: Momwe mungapangire autocomplete mu Excel
Njira 2: Kugwiritsa ntchito ntchito YAM'MBUYO YOTSATIRA
Palinso njira ina yosinthira maola mumphindi. Kuti muchite izi, mungagwiritse ntchito ntchito yapadera. Preob. Tiyenera kukumbukira kuti njirayi idzagwira ntchito pokhapokha ngati mtengowu uli mu selo ndi mtundu wamba. Izi ndizo, maola 6 siziyenera kuoneka ngati "6:00"ndi momwe "6", ndi maola 6 mphindi 30, osakonda "6:30"ndi momwe "6,5".
- Sankhani selo limene mukufuna kugwiritsa ntchito kuti muwonetse zotsatira. Dinani pazithunzi "Ikani ntchito"yomwe imayikidwa pafupi ndi bar.
- Izi zimachititsa kuti apeze Oyang'anira ntchito. Amapereka mndandanda wathunthu wa mafotokozedwe a Excel. Mndandandawu, yang'anani ntchitoyi Preob. Mukachipeza, sankhani ndipo dinani pa batani. "Chabwino".
- Ntchito yotsutsana zenera ikuyambitsidwa. Wogwiritsa ntchitoyi ali ndi zifukwa zitatu:
- Chiwerengero cha;
- Chinthu Choyambitsa;
- Chigawo chomaliza.
Munda woyamba kutsutsana uli ndi mawu owerengeka omwe amatembenuzidwa, kapena kutchulidwa ku selo kumene kuli. Pofuna kufotokoza chiyanjano, muyenera kukhazikitsa mtolo mkati mwazenera, ndiyeno dinani selo pa pepala limene deta ili. Pambuyo pazigawo izi zidzawonetsedwa mmunda.
M'munda wa chiyero choyambirira chayeso kwa ife, muyenera kufotokozera ola. Kutsindika kwawo ndi: "hr".
M'munda wa gawo lomaliza la chiyeso amasonyeza maminiti - "mn".
Deta yonse italowa, dinani pa batani "Chabwino".
- Excel idzapangitsa kutembenuka ndipo mulojekiti yisanayambe idzapereka zotsatira zomaliza.
- Monga mwa njira yapitayi, pogwiritsa ntchito chikhomo chodzaza, mukhoza kuchita ntchito yogwiritsira ntchito Preob deta yonse.
Phunziro: Excel ntchito wizara
Monga mukuonera, kutembenuka kwa maola ndi mphindi si kophweka monga momwe kumawonekera poyamba. Izi ndizovuta kwambiri ndi deta mu mawonekedwe a nthawi. Mwamwayi, pali njira zomwe zimalola kuti kutembenuka kumbali iyi. Imodzi mwa njirazi ikuphatikiza kugwiritsa ntchito coefficient, ndipo yachiwiri - ntchito.
