Lokacin aiki tare da lokaci a cikin Excel, wani lokacin akwai matsalar sauya sa'o'i zuwa minti. Zai yi kama da aiki mai sauƙi, amma sau da yawa yana da wuyar gaske ga masu amfani da yawa. Kuma abu duka yana cikin fasalulluka na lissafin lokaci a cikin wannan shirin. Bari mu kalli yadda zaku iya sauya awa zuwa mintuna a cikin Excel ta hanyoyi daban-daban.
Maida sa'o'i zuwa mintuna a cikin Excel
Duk wahalar sauya sa'o'i zuwa mintuna shine cewa Excel ya ɗauki lokaci ba hanyar da ta saba mana ba, amma tsawon kwanaki. Wannan shine, don wannan shirin 24 hours daidai yake da ɗaya. A 12:00, shirin yana wakiltar 0.5, saboda awanni 12 shine kashi 0 na rana.
Don ganin yadda wannan ke faruwa tare da misali, kuna buƙatar zaɓar kowane tantanin a kan allo akan tsarin lokaci.
Kuma sannan shirya shi zuwa tsari na gama gari. Lambar ne da ke bayyana a cikin tantanin halitta wanda zai nuna tsinkaye shirye-shiryen shirin bayanan da aka shigar. Kewayon ta na iya kasancewa daga 0 a da 1.
Saboda haka, batun canza sa'o'i zuwa awanni dole ne a matattara ta hanyar gaskiyar wannan gaskiyar.
Hanyar 1: amfani da dabarar ninka
Hanya mafi sauki don sauya awa zuwa mintina shine don ninka shi ta hanyar wani yanayi. Mun gano a sama cewa Excel yana ɗaukar lokaci a cikin kwanaki. Saboda haka, don samun daga magana a cikin awanni na mintuna, kuna buƙatar ninka wannan kalmar ta hanyar 60 (yawan mintuna cikin awanni) da kunnawa 24 (yawan awowi a rana). Don haka, abin da muke buƙata wanda muke buƙatar ninka darajar zai zama 60×24=1440. Bari mu ga yadda zai kaya a aikace.
- Zaɓi sel wanda sakamakon sakamako na ƙarshe cikin minti zai kasance. Mun sanya alama "=". Mun danna kan wayar wanda bayanan ke cikin sa'o'i. Mun sanya alama "*" kuma buga lamba daga maballin 1440. Domin shirin ya tsara bayanan kuma ya nuna sakamakon, danna maɓallin Shigar.
- Amma sakamakon na iya kasancewa ba daidai ba ne. Wannan ya faru ne saboda gaskiyar cewa, sarrafa bayanan tsarin lokacin ta hanyar dabara, tantanin halitta wanda aka nuna sakamakon shi da kansa ya samu tsari iri ɗaya. A wannan yanayin, dole ne a canza shi gaba ɗaya. Don yin wannan, zaɓi tantanin. Sannan mun matsa zuwa shafin "Gida"idan muna cikin wani, saika danna filin musamman inda aka nuna yadda aka tsara shi. An samo shi a kan tef a cikin toshe kayan aiki. "Lambar". A lissafin da zai buɗe, tsakanin saitin dabi'u, zaɓi "Janar".
- Bayan waɗannan ayyuka, za a nuna madaidaitan bayanai a cikin tantanin da aka ƙayyade, wanda zai kasance sakamakon sauya sa'o'i zuwa minti.
- Idan baku da darajar guda ɗaya, amma gaba ɗaya don juyawa, to ba za ku iya yin aikin da ke sama don kowane darajar daban ba, amma kwafa dabarar ta amfani da alamar cikawa. Don yin wannan, sanya siginan kwamfuta a cikin ƙananan kusurwar dama na tantanin halitta tare da dabara. Muna jira har sai an kunna alamar cikewa a cikin hanyar giciye. Riƙe maɓallin linzamin kwamfuta na hagu kuma ja siginar layi ɗaya a cikin sel tare da bayanan da ake juyawa.
- Kamar yadda kake gani, bayan wannan matakin, za a canza dabi'un dukkanin jerin zuwa mintina.
Darasi: Yadda ake yin autocomplete a Excel
Hanyar 2: yi amfani da aikin PREFER
Akwai kuma wata hanyar da za a canza awa zuwa mintina. Kuna iya amfani da aikin musamman don wannan. GASKIYA. Ya kamata a sani cewa wannan zaɓin zai yi aiki ne kawai lokacin da asalin darajar yake a cikin sel tare da tsari na gama gari. Wannan shine, awanni 6 a ciki bai kamata a nuna shi azaman ba "6:00"kuma ta yaya "6"da kuma awanni 6 da mintuna 30, ba kamar "6:30"kuma ta yaya "6,5".
- Zaɓi wayar da kuka shirya amfani da ita don nuna sakamakon. Danna alamar. "Saka aikin"wanda yake kusa da layin tsari.
- Wannan matakin zai bude Wizards na Aiki. Yana bayar da cikakken jerin maganganun Excel. A cikin wannan jerin muna neman aiki GASKIYA. Bayan samo shi, zaɓi kuma danna maballin "Ok".
- Farashin muhawara na aiki fara. Wannan ma'aikacin yana da hujjoji guda uku:
- Lambar;
- Unit Source;
- Kashi na karshe.
Yankin gardama ta farko tana nuna alamar lamba da ake jujjuyawa, ko kuma batun tantanin halitta inda yake. Don ƙayyade hanyar haɗi, kuna buƙatar sanya siginan kwamfuta a cikin taga, sannan danna kan wayar a kan takardar wanda bayanan ke ciki. Bayan haka, za a nuna kwarrafan a fagen.
A cikin filin na asali na ma'aunin ma'auni a cikin yanayinmu, kuna buƙatar tantance agogo. Saka bayanan su kamar haka: "hr".
A fagen na karshe na ma'aunai, saka mintuna - "mn".
Bayan an shigar da dukkan bayanan, danna maɓallin "Ok".
- Excel zai yi juyi kuma a cikin tantanin da aka ambata a baya wanda zai samar da sakamako na ƙarshe.
- Kamar yadda a cikin hanyar da ta gabata, ta amfani da alamar cikewa, zaku iya aiwatarwa tare da aikin GASKIYA cikakken kewayon bayanai.
Darasi: Mayan Maɗaukaki
Kamar yadda kake gani, canza sa'o'i zuwa mintuna ba abu bane mai sauki kamar yadda ake gani da farko. Wannan yana da matsala musamman tare da bayanai a tsarin lokaci. An yi sa'a, akwai hanyoyi waɗanda za ku iya aiwatar da juyawa ta wannan hanyar. Ofaya daga cikin waɗannan zaɓuɓɓukan sun haɗa da amfani da coefficient, da na biyu - ayyuka.
