Ofaya daga cikin ayyukan da mai amfani zai iya fuskanta yayin aiki a Excel shine ƙari na lokaci. Misali, wannan batun na iya tasowa yayin tara daidaiton lokacin aiki a cikin shiri. An haɗa matsaloli tare da gaskiyar cewa lokaci ba a auna lokaci a cikin tsarin makirci na yau da kullun, wanda Excel ke aiki ta hanyar tsohuwa. Bari mu gano yadda za a taƙaita lokaci a cikin wannan aikace-aikacen.
Lissafin Lokaci
Domin aiwatar da tsarin lokacin tara kudi, da farko, dukkanin sel wadanda suke wannan aiki dole ne su samar da tsarin lokaci. Idan wannan ba matsala bane, to lallai suna buƙatar tsara su daidai. Tsarin sel na yanzu ana iya duba shi bayan zaɓar su a cikin shafin "Gida" a fagen zane na musamman akan kintinkiri a cikin akwati "Lambar".
- Zaɓi madaidaitan ƙwayoyin. Idan wannan kewa ce, to kawai ka riƙe maɓallin linzamin kwamfuta na hagu ka kewaye. Idan muna ma'amala da sel sel ɗaya da ke warwatse akan takarda, to, zamu zaɓi su, tsakanin sauran abubuwa, riƙe maɓallin Ctrl a kan keyboard.
- Mun danna-dama, ta haka muke kiran menu. Je zuwa kayan "Tsarin kwayar halitta ...". Madadin haka, zaku iya rubuta hade bayan an sa alama akan maballin Ctrl + 1.
- Tsarin tsarawa yana buɗe. Je zuwa shafin "Lambar"idan ya bude a wani shafin. A cikin toshe na sigogi "Lambobin adadi" matsar da canji zuwa wuri "Lokaci". A hannun dama na taga a toshe "Nau'in" mun zabi nau'in nuni wanda zamuyi aiki dashi. Bayan an gama saitawa sai a latsa maballin "Ok" a kasan taga.
Darasi: Tsarin tebur a cikin Excel
Hanyar 1: nuni awanni bayan wani lokaci
Da farko, bari mu ga yadda za a ƙididdige yawan awowin da za su nuna bayan wani lokaci, wanda aka bayyana a cikin sa'o'i, mintuna da sakan. A cikin ƙayyadaddden misalinmu, muna buƙatar gano yadda zai kasance a kan agogo a cikin 1 awa 45 da mintuna 51 idan lokacin yanzu 13:26:06.
- A ɓangaren da aka tsara na takardar a cikin sel daban-daban ta amfani da keyboard, shigar da bayanai "13:26:06" da "1:45:51".
- A cikin tantanin na uku, wanda shima aka saita tsarin lokaci, sanya alama "=". Bayan haka, danna kan wayar akan lokaci "13:26:06", danna alamar "+" akan allon danna danna kan tantanin tare da darajar "1:45:51".
- Don nuna sakamakon lissafin, danna maɓallin "Shiga".
Hankali! Ta amfani da wannan hanyar, zaku iya gano yawan awowin da zasu nuna bayan wasu adadin lokaci ne kawai cikin kwana ɗaya. Domin samun damar "tsalle" sama da iyakar yau da kullun kuma san tsawon lokacin da agogo zai nuna a wannan yanayin, tabbatar an zabi nau'in nau'in tare da alamar alama yayin tsara sel, kamar yadda yake a hoton da ke ƙasa.
Hanyar 2: yi amfani da aikin
Wani madadin hanyar da ta gabata ita ce amfani da aikin SAURARA.
- Bayan an shigar da bayanan farko (agogo na yanzu da kuma lokaci tsakanin lokaci), zaɓi keɓaɓɓiyar sel. Latsa maballin "Saka aikin".
- Zazzage Aiki ya buɗe. Muna neman aiki a cikin jerin abubuwan SAURARA. Zaɓi shi kuma danna maballin. "Ok".
- Farashin muhawara na aiki fara. Sanya siginan kwamfuta a cikin filin "Lambar1" ka kuma danna wayar da ke dauke da lokacin da ake ciki. Sannan saita siginar shiga filin "Lambar2" sannan ka danna wayar inda aka nuna lokacin da ake bukatar kara. Bayan an kammala filayen duka biyu, danna maballin "Ok".
- Kamar yadda kake gani, lissafin yana faruwa kuma sakamakon ƙarin lokaci yana nunawa a cikin sel da aka zaɓa.
Darasi: Wizard ɗin Aiki a cikin Excel
Hanyar 3: jimlar ƙari
Amma mafi yawan lokuta a aikace, ba kwa buƙatar tantance agogo bayan wani lokaci, amma ƙara yawan adadin lokaci. Misali, ana buƙatar wannan don ƙididdige adadin adadin sa'o'in da aka yi aiki. Don waɗannan dalilai, zaku iya amfani da ɗayan hanyoyin biyu da aka bayyana a baya: ƙarin ƙari ko aikace-aikacen aiki SAURARA. Amma, a wannan yanayin yafi dacewa don amfani da irin wannan kayan aiki azaman adadin atomatik.
- Amma da farko, zamu buƙaci tsara sel ta wata hanya, ba kamar yadda aka fasalta na waɗancan sigogin da suka gabata ba. Zaɓi yankin kuma kira taga tsarawa. A cikin shafin "Lambar" sake shirya sauyawa "Lambobin adadi" a matsayi "Ci gaba". A ɓangaren dama na taga mun samo kuma saita ƙimar "[h]: mm: ss". Don adana canjin, danna maɓallin "Ok".
- Na gaba, zaɓi kewayon cike da ƙimar lokacin da sel ɗaya wofi bayan shi. Kasancewa a shafin "Gida"danna alamar "Adadin"located a kan tef a cikin toshe kayan aiki "Gyara". A madadin haka, zaku iya buga gajerar hanyar rubutu akan maballin "Alt + =".
- Bayan waɗannan ayyukan, sakamakon lissafin ya bayyana a cikin kwayar da aka zaɓa.
Darasi: Yadda za'a kirkiri adadin a Excel
Kamar yadda kake gani, akwai nau'in ƙarin lokacin lokaci a cikin Excel: ƙari duka lokacin haɗewa da ƙididdige matsayin matsayin agogo bayan wani lokaci. Akwai hanyoyi da yawa don magance kowace matsala. Mai amfani da kansa dole ne ya yanke shawara wane zaɓi don wannan yanayi da kansa ya fi dacewa da shi.
