Ɗaya daga cikin ayyukan da mai amfani zai iya fuskanta yayin aiki a Excel shine ƙarin lokaci. Alal misali, wannan tambaya zai iya fitowa a cikin shirye-shirye na daidaitattun lokacin yin aiki a cikin shirin. Difficulties suna da alaƙa da gaskiyar cewa ba a ƙayyade lokaci ba a cikin tsarin ƙaddarar da aka saba da mu, wanda Excel yayi aiki ta hanyar tsoho. Bari mu gano yadda za a tara lokaci a cikin wannan app.
Ƙaddamar lokaci
Domin samar da tsarin taƙaitaccen lokaci, da farko, dukan kwayoyin da suke shiga cikin wannan aiki dole ne su tsara tsarin lokaci. Idan wannan ba haka bane, dole ne a tsara ta yadda ya kamata. Za a iya duba tsarin sirrin yanzu a bayan zaɓi a cikin shafin "Gida" a cikin wani tsari na musamman na ƙila a kan tef a cikin akwatin kayan aiki "Lambar".
- Zaɓi sel masu daidaita. Idan wannan lamari ne, to, kawai ka riƙe maɓallin linzamin hagu kuma ka kewaye shi. Idan muna aiki da kwayoyin mutum wanda aka watsar a kan takarda, to sai muka zaba su, a tsakanin sauran abubuwa, ta hanyar riƙe maɓallin Ctrl a kan keyboard.
- Mun danna maɓallin linzamin linzamin dama, don haka kiran mahallin mahallin. Ku tafi cikin abu "Tsarin tsarin ...". A madadin, za ka iya rubuta haɗin bayan nuna rubutu a kan keyboard. Ctrl + 1.
- Tsarin tsarin ya buɗe. Jeka shafin "Lambar"idan ta buɗe a wani shafin. A cikin fasalin fasali "Formats Matsala" Swap da canza zuwa matsayi "Lokaci". A gefen dama na taga a cikin toshe "Rubuta" zaɓi nau'in nuni da za mu yi aiki tare da. Bayan an gama saitin, danna kan maballin. "Ok" a kasan taga.
Darasi: Tsarin layi na Excel
Hanyar 1: nuni lokaci bayan lokaci
Da farko, bari mu ga yadda za a tantance yawan lokutan da za a nuna bayan wani lokaci, aka bayyana a cikin sa'o'i, minti da kuma seconds. A cikin misalinmu na musamman, kana buƙatar gano yadda za a kasance a agogo bayan minti 1 da minti 45 da 51, idan an saita lokaci a 13:26:06.
- A tsarin da aka tsara na takardar a cikin kwayoyin daban daban ta amfani da keyboard shigar da bayanai "13:26:06" kuma "1:45:51".
- A cikin ɓangaren na uku, wanda aka saita tsarin lokaci, sanya alamar "=". Kusa, danna kan tantanin halitta tare da lokaci "13:26:06"danna kan alamar "+" a kan keyboard kuma danna tantanin halitta tare da darajar "1:45:51".
- Domin nuna sakamakon sakamakon lissafin, danna kan maballin "Shigar".
Hankali! Amfani da wannan hanya, zaka iya gano yawancin awowi da za a nuna bayan wasu lokutan kawai a cikin rana ɗaya. Domin samun damar "tsalle" a kan iyakokin yau da kullum kuma ku san tsawon lokacin da agogon zai nuna, dole ne ku zabi nau'in tsari da alama ta atomatik lokacin tsara tsarin sel, kamar yadda a cikin hoton da ke ƙasa.
Hanyar 2: amfani da aikin
Wani madadin hanyar da aka rigaya shine don amfani da aikin SUM.
- Bayan bayanan farko (halin yanzu na kwanan nan da tsawon lokaci) an shigar, zaɓi sel mai rarraba. Danna maballin "Saka aiki".
- Wizard na aiki ya buɗe. Muna neman aikin a cikin jerin abubuwa "SUMM". Zaɓi shi kuma danna maballin. "Ok".
- An kaddamar da taga na aiki. Saita siginan kwamfuta a filin "Number1" kuma danna kan tantanin halitta dauke da halin yanzu. Sa'an nan kuma saita siginan kwamfuta a filin "Number2" kuma danna kan tantanin halitta, wanda ke nuna lokacin da kake so ka ƙara. Bayan an cika fannonin biyu, danna maballin "Ok".
- Kamar yadda kake gani, ana yin lissafi kuma sakamakon sakamakon lokaci yana nunawa a cikin tantanin halitta da aka zaba.
Darasi: Wizard Function Wizard
Hanyar 3: jimlar ƙarin lokaci
Amma sau da yawa a cikin aikin yana da muhimmanci kada a ƙayyade kwanakin lokuta bayan wani lokaci, amma don ƙara yawan adadin lokaci. Alal misali, ana buƙatar wannan don sanin yawan adadin lokutan aiki. Don waɗannan dalilai, zaka iya amfani da ɗayan hanyoyi biyu da aka bayyana a baya: ƙarawa mai sauƙi ko amfani da aikin SUM. Amma, yafi dacewa a cikin wannan yanayin don amfani da irin wannan kayan aiki a matsayin fan mota.
- Amma, na farko za mu buƙaci mu tsara kwayoyin halitta daban-daban, kuma ba a hanyar da aka bayyana a cikin sifofin da suka gabata ba. Zaɓi yanki kuma kira hanyar tsarawa. A cikin shafin "Lambar" Swap da canji "Formats Matsala" a matsayi "Advanced". A gefen dama na taga mun sami kuma saita darajar "[h]: mm: ss". Don ajiye canji, danna maballin. "Ok".
- Na gaba, kana buƙatar zaɓin kewayon cika da darajar lokaci da kuma ɗakin marar ciki bayan shi. Da yake kan shafin "Gida", danna kan gunkin "Adadin"wanda yake a kan tef a cikin wani asalin kayan aiki Ana gyara. A matsayin madadin, za ka iya rubuta hanyar gajeren hanya "Alt + =".
- Bayan waɗannan ayyukan, sakamakon lissafi zai bayyana a cikin wani zaɓi wanda aka zaɓa.
Darasi: Yadda za a tantance adadin a Excel
Kamar yadda kake gani, akwai nau'o'i biyu na lokaci a Excel: jimlar yawan lokaci da lissafin matsayi na hours bayan wani lokaci. Don magance waɗannan matsalolin, akwai hanyoyi da dama. Mai amfani da kanta dole ne ya yanke shawarar wane zaɓi don shari'ar ta dace da shi gaba ɗaya.
