Yadda Ake Daidaita lokaci a Fim

Ofaya daga cikin ayyukan da zai iya zama kafin mai amfani yayin aiki a Ecelcel shine ƙari. Misali, wannan tambaya na iya faruwa lokacin da zane a cikin tsarin daidaita lokacin daidaita aiki. Matsaloli suna da alaƙa da gaskiyar cewa lokaci bai auna shi cikin tsarin dimama wanda ya san mu, a cikin abin da Excel yana aiki ta tsohuwa. Bari mu gano yadda ake taƙaita lokacin a cikin wannan aikace-aikacen.

Tattaunawa

Don samar da hanyar kiran lokaci, da farko, duk sel da ke cikin wannan aikin dole ne su sami tsarin lokaci. Idan ba haka bane, to dole ne a tsara su daidai. Tsarin tantanin halitta na yanzu ana iya duba shi bayan an zaɓi tsarin gida bayan an zaɓi su a cikin shafin tsara na musamman akan tef a cikin tef a cikin tef a cikin maɓallin "Lambar" Toolbar.

1. Zaɓi sel masu dacewa. Idan kewayon, to kawai kawai matsa maɓallin linzamin kwamfuta na hagu kuma yana haifar da shi. A cikin taron cewa muna ma'amala da mutum sel ya watsu a kan takardar, to dukiyar da za'ayi, ta cikin wasu abubuwa, ta riƙe maɓallin Ctrl a maɓallin.
2. Ta danna maɓallin linzamin kwamfuta na dama, don haka kiran menu na mahallin. Ku shiga cikin kayan "tsari na tsari ...". Madadin haka, zaka iya sauke Ctrl + 1 hade a kan maballin.



3. Taga taga yana buɗewa. Je zuwa shafin "lamba idan ya bude a wani shafin. A cikin "adadi na adadi" sigogi, muna sake shirya canji zuwa matsayin "lokaci". A gefen dama na taga a cikin "nau'in" toshe, zaɓi nau'in nuna wanda za mu yi aiki. Bayan an yi saitin, danna maɓallin "Ok" a kasan taga.

Darasi: Tsarin tebur a Faith

Hanyar 1: Kalli Karatu ta hanyar Tsakanin Lokaci

Da farko dai, bari mu ga yadda za a iya lissafta awanni nawa ne za'a nuna awowi nawa bayan wani lokaci, wanda aka bayyana a cikin awanni, mintuna da sakan. A cikin misalinmu na musamman, kuna buƙatar sanin nawa zai kasance a kan agogo bayan awa 45 da sakan 51, idan an sanya ka a kansu 51.

1. A ɓangaren da aka tsara na takardar a cikin sel daban-daban ta amfani da keyboard, muna shigar da bayanai "13:26:06" da "1:45:51".



2. A cikin sel na uku, wanda za'a sanya tsarin tsari, sanya alamar "=". Na gaba, danna kan tantanin halitta akan lokaci "13:26:06", danna alamar "+" a maɓallin kuma danna kan tantanin tare da darajar "1:45:51".



3. Domin sakamakon lissafin don nuna allon, danna maɓallin "Shigar".

Hankali! Aiwatar da wannan hanyar, zaku iya gano sa'o'i nawa zasu nuna bayan wani adadin lokaci kawai a cikin rana ɗaya. Don "tsalle" ta hanyar layin yau da kullun kuma san lokacin da za a nuna agogo, tabbatar da zaɓin nau'in tsari tare da alama, kamar yadda a hoton da ke ƙasa.

Hanyar 2: Yin Amfani da Aiki

Wani zaɓi na zaɓi don amfani da shi shine amfani da adadin adadin.

1. Bayan manyan bayanai (na yanzu karanta na agogo da lokaci) an shigar, zaɓi raba sel. Danna kan "Manna Active".



2. Wizard ya buɗe. Muna neman a cikin jerin abubuwan aikin "Kems". Muna haskaka shi kuma latsa maɓallin "Ok".



3. Window aikin gargajiya yana farawa. Mun kafa siginan kwamfuta a filin "lamba" da kuma rashin daidaituwa na tantanin da ke ɗauke da lokacin yanzu. Sa'an nan kuma saita siginan kwamfuta a filin "lamba" sai ka danna kan tantanin, inda aka ƙayyade lokacin. Bayan duka filayen sun cika, latsa maɓallin "Ok".



4. Kamar yadda kake gani, lissafin yana faruwa ne kuma sakamakon batun yana nuna shi ne a cikin tantanin da aka zaɓa da farko.

Darasi: Ayyukan Wizard a Excel

Hanyar 3: Bugu da kari kari

Amma mafi sau da yawa a aikace, ya zama dole ba sanin karatun sa'o'i ba a wani lokaci, amma don ninka jimlar lokaci. Misali, ana buƙatar wannan don sanin adadin adadin sa'o'i. Don waɗannan dalilai, zaku iya amfani da ɗayan hanyoyi biyu da aka bayyana: ƙari mai sauƙi ko aikace-aikacen adadin adadin. Amma, mafi dacewa sosai a wannan yanayin, yi amfani da irin wannan kayan aiki a matsayin mota Mosmy.

1. Amma, da farko, muna buƙatar tsara sel ta wata hanya daban, kuma ba yadda aka bayyana ta a cikin sigogin da suka gabata ba. Zaɓi yankin kuma kira taga tsara. A cikin shafin "lamba", muna sake tsara "adadi na tsari" canzawa zuwa matsayin "ci gaba". A ɓangaren dama na taga mun sami kuma saita darajar "[H]: MM: SS". Don adana canjin, danna maɓallin "Ok".



2. Na gaba, kuna buƙatar haskaka kewayon cika da darajar lokaci da kuma wani sel mai komai bayan ta. Kasancewa a shafin gida, danna maɓallin icon, wanda ke kan tef a cikin kayan aikin gyarawa. A matsayin madadin, zaku iya buga maɓallin "Alt + =" keyboard akan keyboard.



3. Bayan waɗannan ayyukan, sakamakon lissafin zai bayyana a cikin sel zaɓaɓɓu.

Darasi: Yadda ake lissafta adadin a Excel

Kamar yadda kake gani, akwai nau'ikan lokuta guda biyu suna ninki biyu a Forevice: Jimillar kari da lissafin matsayin agogo bayan wani lokaci. Don magance kowane ɗayan waɗannan ayyuka akwai hanyoyi da yawa. Mai amfani da kansa dole ne ya yanke shawarar wani zaɓi don takamaiman batun da kansa zai dace da shi.