Pogwira ntchito ndi nthawi ku Excel, nthawi zina pamakhala vuto lotembenuza maola kukhala mphindi. Zitha kuwoneka ngati ntchito yosavuta, koma nthawi zambiri zimakhala zovuta kwa ogwiritsa ntchito ambiri. Ndipo chinthu chonsecho chili pazinthu zowerengera nthawi mu pulogalamuyi. Tiyeni tiwone momwe mungasinthire maola kukhala mphindi mu Excel m'njira zosiyanasiyana.
Sinthani maola ambiri kukhala mphindi ku Excel
Chovuta chonse chosinthira maola kukhala mphindi ndikuti Excel samalingalira nthawi osati njira yanthawi zonse kwa ife, koma masiku. Ndiye kuti, pulogalamu iyi maola 24 ndi ofanana. Pofika 12:00, pulogalamuyo imayimira 0.5, chifukwa maola 12 ndi gawo 0,5 la tsiku.
Kuti muwone momwe izi zimachitikira ndi chitsanzo, muyenera kusankha khungu lililonse patsamba
Ndipo kenako pangani mawonekedwe wamba. Nambala ndi yomwe imawonekera mu foni yomwe imawonetsa kuzindikira kwa pulogalamuyi pamasamba omwe adalowetsedwa. Mtundu wake ukhoza kuyambira 0 kale 1.
Chifukwa chake, nkhani ya kutembenuza maola kukhala mphindi ikuyenera kufikiridwa ndendende kudzera mukutsimikizira kwa mfundo iyi.
Njira 1: gwiritsani ntchito njira zochulukitsira
Njira yosavuta yosinthira maola kukhala mphindi ndikuchulukitsa ndi chinthu china. Tidazindikira pamwamba kuti Excel imatenga nthawi m'masiku. Chifukwa chake, kuti mutenge mawu kuchokera maola ambiri, muyenera kuchulukitsa mawuwa 60 (kuchuluka kwa mphindi mu maola) ndi kupitirira 24 (kuchuluka kwa maola tsiku limodzi). Chifukwa chake, cholingana chomwe tidzafunikira kuwonjezera kuchuluka kwake chidzakhala 60×24=1440. Tiyeni tiwone momwe zimawonekera machitidwe.
- Sankhani khungu lomwe zotsatira zomaliza zili mphindi. Timayika chikwangwani "=". Timadula foni yomwe imakhala mu maola. Timayika chikwangwani "*" lembani nambala kuchokera pa kiyibodi 1440. Kuti pulogalamuyo ichite kafukufukuyo ndikuwonetsa zotsatira zake, dinani batani Lowani.
- Koma zotsatira zake zingakhalebe zolakwika. Izi ndichifukwa choti, pokonza zowerengera za nthawiyo kudzera mu chilinganizo, khungu lomwe zotsatira zake limadziwonetsera lokha limapeza mawonekedwe omwewo. Pankhaniyi, ziyenera kusinthidwa kukhala wamba. Kuti muchite izi, sankhani khungu. Kenako timasunthira ku tabu "Pofikira"ngati tili kwina, ndikudina pa gawo lapadera momwe mawonekedwe awonetsedwa. Ili pa tepi pachipata cha zida. "Chiwerengero". Pamndandanda womwe umatseguka, pakati pazokhazikitsidwa ndi mfundo, sankhani "General".
- Pambuyo pa izi, deta yolondola iwonetsedwa mu khungu lomwe latchulidwa, zomwe zidzakhale kusintha kwa maola kukhala mphindi.
- Ngati mulibe mtengo umodzi, koma lonse kutembenuka, ndiye kuti simungathe kuchita ntchito ili pamtundu uliwonse payokha, koma koperani formula pogwiritsa ntchito chikhomo. Kuti muchite izi, ikani cholozera cha ngodya chapansi chakumanja kwa chilinganizo. Timadikirira mpaka chikhomo chodzaza chikhale mwa mtanda. Gwirani batani lakumanzere ndikukokera thumbo limodzi ndi maselo ndi zomwe deta yasinthidwa.
- Monga mukuwonera, izi zitatha, mfundo za mndandanda wonsewo zisinthidwa kukhala mphindi.
Phunziro: Momwe mungapangire kuti zitheke mu Excel
Njira 2: gwiritsani ntchito ntchito ya PREFER
Palinso njira ina yosinthira maola kukhala mphindi. Mutha kugwiritsa ntchito ntchito yapadera ya izi. KULAMBIRA. Tiyenera kudziwa kuti kusankha kumeneku kudzagwira ntchito pokhapokha phindu loyambirira lili mu khungu lomwe lili ndi mtundu wamba. Ndiye kuti, maola 6 mkati mwake sayenera kuwonetsedwa "6:00"ndi motani "6"ndi maola 6 mphindi 30, osati monga "6:30"ndi motani "6,5".
- Sankhani foni yomwe mukufuna kugwiritsa ntchito kuti muwonetse zotsatira. Dinani pachizindikiro. "Ikani ntchito"lomwe lili pafupi ndi mzere wa fomula.
- Izi zitsegulidwa Ogwira Ntchito. Imapereka mndandanda wathunthu wazithunzithunzi za Excel. Mndandandawu tikufuna ntchito KULAMBIRA. Popeza mwachipeza, sankhani ndikudina batani "Zabwino".
- Ntchito yotsutsana ndi ntchito imayamba. Wogwiritsa ntchito ali ndi zifukwa zitatu:
- Chiwerengero;
- Source Source;
- Final unit.
Gawo la mfundo yoyamba likuwonetsa mawu omwe akusinthidwa, kapena cholowera ku foni komwe kuli. Kuti muthe kulongosola ulalo, muyenera kuyika chowunkhira mundawo la zenera, kenako ndikudina foniyo patsamba lomwe pulogalamuyo imapezekamo. Pambuyo pake, zogwirizira ziwonetsedwa m'munda.
Pazigawo zoyambirira za muyeso kwa ife, muyenera kufotokozera nthawi. Kulowerera kwawo kuli motere: "hr".
Pazigawo zomaliza za muyeso, nenani mphindi - "mn".
Pambuyo polemba data yonse, dinani batani "Zabwino".
- Excel adzasintha ndipo mu cell yomwe yatchulidwazi ipanga zotsatira zomaliza.
- Monga momwe munachitira kale, pogwiritsa ntchito cholembera, mutha kukonza ndi ntchitoyo KULAMBIRA mndandanda wonse wambiri.
Phunziro: Excel Feature Wizard
Monga mukuwonera, kusintha maola kukhala mphindi si ntchito yophweka monga momwe kumawonekera koyamba. Izi ndizovuta kwambiri ndi data munthawi. Mwamwayi, pali njira zomwe mungapangire kutembenuka kumene. Chimodzi mwazosankha izi chimaphatikizapo kugwiritsa ntchito kokwanira, ndipo chachiwiri - ntchito.
