Ana buɗe Tables na ODS a cikin Microsoft Excel

Lokacin aiki tare da lokaci a Excel, wani lokacin akwai matsala na canza sa'o'i zuwa minti. Zai zama aiki mai sauƙi, amma sau da yawa yana nuna cewa ya zama mai yawa ga masu amfani da yawa. Kuma abu yana cikin fasali na ƙayyade lokaci a wannan shirin. Bari mu kwatanta yadda za'a fassara hours cikin minti zuwa Excel a hanyoyi daban-daban.

Sauya sauti zuwa minti a Excel

Duk wahalar sauya sa'o'i zuwa minti shine Excel ya dauki lokaci ba kamar yadda muke saba ba, amma kamar yadda kwanakin. Wato, don wannan shirin, sa'o'i 24 yana daidai da ɗaya. Lokaci yana da karfe 12, shirin shine 0.5, domin sa'o'i 12 yana da kashi 0.5 na rana.

Don ganin yadda wannan ya faru tare da misali, kana buƙatar zaɓar kowane sel a kan takarda a cikin tsarin lokaci.

Sa'an nan kuma tsara shi a karkashin tsari na kowa. Wannan lambar ce za ta bayyana a cikin tantanin halitta wanda zai nuna tunanin da shirin yake game da bayanan da aka shigar. Hakan zai iya bambanta daga 0 har zuwa 1.

Sabili da haka, dole ne a kuskura yin tambaya game da sauya sa'o'i zuwa mintoci ta hanyar wannan gaskiyar.

Hanyar 1: Amfani da Fassara Formula

Hanyar mafi sauki don sauya hours zuwa minti shine ninka ta hanyar wani abu. A sama, mun gano cewa Excel yana ganin lokaci a cikin kwanaki. Saboda haka, don samun minti daya daga cikin magana, kana buƙatar ninka wannan furta ta 60 (yawan minti a cikin sa'o'i) da kuma 24 (yawan lokutan da rana). Saboda haka, mahaɗin da muke buƙatar ninka darajar za ta kasance 60×24=1440. Bari mu ga yadda za a yi aiki.

  1. Zaɓi tantanin halitta wanda zai ƙunshi sakamakon ƙarshe a cikin minti. Mun sanya alamar "=". Danna kan tantanin halitta wanda aka samo bayanai a cikin sa'o'i. Mun sanya alamar "*" da kuma rubuta lambar daga keyboard 1440. Domin shirin don aiwatar da bayanai kuma nuna sakamakon, danna kan maballin Shigar.
  2. Amma sakamakon zai iya zama ba daidai ba. Wannan shi ne saboda gaskiyar cewa, sarrafa bayanai na tsarin lokaci ta hanyar dabarun, tantanin halitta wanda aka nuna shi duka, kanta ta samo wannan tsari. A wannan yanayin, yana buƙatar canzawa zuwa gaba ɗaya. Domin yin wannan, zaɓi cell. Sai motsa zuwa shafin "Gida"idan muna cikin wani kuma danna filin musamman inda aka nuna tsarin. Ana samuwa a kan tef a cikin asalin kayan aiki. "Lambar". Daga cikin saitin dabi'u a jerin da ya buɗe, zaɓi abu "Janar".
  3. Bayan waɗannan ayyukan, ƙwayar da aka ƙayyade za ta nuna cikakken bayanai, wanda zai haifar da canza sa'o'i zuwa minti.
  4. Idan kana da darajar fiye da ɗaya, amma dukkanin juyi na fassarar, ba za ka iya yin aikin da ke sama don kowane darajar ba, amma kwafa wannan tsari ta amfani da alamar cika. Don yin wannan, sanya siginan kwamfuta a cikin kusurwar dama na tantanin halitta tare da tsari. Muna jiran alama mai cikawa da za a kunna a matsayin gicciye. Riƙe maɓallin linzamin hagu kuma ja mai siginan kwamfuta a layi daya zuwa sel tare da bayanan da aka canza.
  5. Kamar yadda kake gani, bayan wannan aikin, za a canza dabi'un jerin jinsin zuwa minti.

Darasi: Yadda za a yi ba da kyauta a Excel

Hanyar 2: Amfani da aikin GABATARWA

Akwai kuma wata hanya ta canza awa zuwa minti. Don yin wannan, zaka iya amfani da aikin musamman. Talla. Ya kamata a lura cewa wannan zaɓin zai yi aiki ne kawai lokacin da ƙimar farko ta kasance a cikin tantanin halitta tare da tsari na kowa. Wato, 6 hours ya kamata ba bayyana a matsayin "6:00"da kuma yadda "6", kuma 6 hours 30 minutes, ba so "6:30"da kuma yadda "6,5".

  1. Zaɓi tantanin da kake shirya don amfani don nuna sakamakon. Danna kan gunkin "Saka aiki"wanda aka sanya a kusa da wannan tsari.
  2. Wannan aikin yana haifar da binciken Ma'aikata masu aiki. Yana bayar da cikakkiyar sakon bayanan Excel. A cikin wannan jerin, nemi aikin Talla. Bayan samun shi, zaɓi shi kuma danna maballin. "Ok".
  3. An kaddamar da taga na aiki. Wannan afaretan yana da ƙididdiga guda uku:
    • Yawan;
    • Bayanin Sashen;
    • Ƙungiyar ƙarshe.

    Yanayin jayayyar farko ita ce fadin lamarin da aka canza, ko kuma bayanin wurin tantanin halitta inda aka samo shi. Domin ƙayyade hanyar haɗi, kana buƙatar saita siginan kwamfuta a filin filin, sa'an nan kuma danna tantanin salula akan takardar da aka samo asusun. Bayan wannan haɗin za a nuna a filin.

    A cikin yanayin asali na asali a cikin yanayin mu, kana buƙatar saka kwanan agogo. Alamarsu ita ce: "Hr".

    A filin filin karshe na ma'auni nuna minti - "mn".

    Bayan an shigar da bayanai, danna kan maballin "Ok".

  4. Excel zai yi fassarar kuma a cikin wayar da aka ƙayyade zai samar da sakamakon ƙarshe.
  5. Kamar yadda aka yi a baya, ta amfani da alamar cika, zaka iya yin aikin aiki Talla dukkanin bayanai.

Darasi: Maɓallin aiki na Excel

Kamar yadda kake gani, yin hira da sa'o'i zuwa minti ba sauki kamar yadda yake kallo ba. Wannan mawuyacin matsala ne tare da bayanai a cikin tsarin lokaci. Abin farin, akwai hanyoyin da za su ba da damar yin hira a cikin wannan hanya. Ɗaya daga cikin waɗannan zaɓuɓɓuka ya haɗa da amfani da maƙalli, kuma na biyu - aikin.