Umhla we yangoku. Njani ukuze ufumane umhla wangoku kunye nexesha Excel

Excel i corporation "Microsoft" yeyona njengomqhubekisi enamandla, leyo lula abasebenzisi ezininzi umsebenzi ngemihla kunye izixa ezikhulu data tabular. Noko ke, ochwepheshe baze baba, kwiminyaka emininzi yokusebenza kunye nale nkqubo, maxa wambi ezilahlekileyo kunye nemfuneko ukufaka kulo iseli lokusebenzela umhla wangoku kunye nexesha. Oku kubangelwa ikakhulu yokuba umsebenzi "Umhla", ukuba bekuya kuba sengqiqweni ukusebenzisa ukufumana amaxabiso ezinqwenelekayo, wenza umsebenzi eyahlukileyo ngokupheleleyo. Kweli nqaku, siza kukuxelela malunga neentlobo ezahlukeneyo mihla asetyenziswa Excel, ukuba iinkqubo ukulungiselela kunye nesicelo iimpawu zazo.

types of dates

Excel ucinga iinketho ezimbini "Umhla current". Eyokuqala kuzo - oku lixabiso esiqingqiweyo se-umhla wangoku kunye nexesha, egcinwe kwi computer mntu uzisebenzisayo. Xa bangena worksheet, ixabiso akayi kutshintsha kungakhathaliseki utshintsho ngexesha lenene kunye nomhla. Xa kungafuneka olu khetho? iimpendulo ezininzi, umzekelo, xa umhla likaMpro- zokufumana umsebenzi ukusebenza okanye ukugxothwa, faka mhla wokufunyanwa impahla ukuya yokugcina. La maxabiso kufuneka ihambisane, kuba ukutshintsha ngokuhamba kwexesha.

Inguqulelo yesibini "Umhla ngoku" - onamandla, ziyatshintsheka, updateable. Usebenziso oluqhelekileyo le khetho - umhla kunye nexesha ixabiso kwikona ye lokusebenza, njenge gama "Namhlanje, May 14, 2017". Olu uhlobo lisetyenziswa kwi fomyula, umzekelo ukubala ukuba zingaphi iintsuku idlule ukususela inani elithile. Abasebenzi Ngoko namhlanje anahamba apho ekupheleni kwethuba probationary yomqeshwa, kwaye nitshekishe istokhwe umsebenzi, hayi ngaphezu komhla wokuphelelwa nokuba ethunyelweyo.

Kakade ke, lo mhla onamandla kunye nexesha Excel kuluncedo kakhulu, kodwa kukho into ebaluleke kakhulu: lungenzeki nokuhlaziya eliqhubekekayo amaxabiso data. Ixabiso wangena iya kutshintsha ngexesha zokuvulwa le ncwadi, xa macro ekubaleni kwizibalo ezahlukeneyo. Ukuba ushiya nje ivuliwe ncwadi, yaye akukho nanye izenzo ngasentla akayi kwenza, umhla kunye nexesha iya kuhlala kumaxabiso ukuba wangena kanye. Kodwa kuyimfuneko ukuphinda-ukuyivula incwadi okanye ekube- ifomula, iinqobo ziya kuhlaziywa.

Cinga ngendlela e Excel ukufaka ezi ntlobo zimbini ze mihla.

Umhla esisigxina, musa ukubuyekeza

value Excel "umhla wangoku" inokufunyanwa ngokucinezela ngokucacileyo isitshixo Ctrl, kwaye ";". ume nje kwiseli ayinqwenelayo kwiphepha lomsebenzi yaye ngoko nangoko ubambe phantsi iqhosha Ctrl kwaye ucinezele i semicolon. Le seli iya kuba umhla wangoku kwi fomati emfutshane, umzekelo 5/14/2017.

Ukuze ufake ixesha, enze umsebenzi ofanayo ngokubamba pantsi iqosha lwe Ctrl, cofa uze ubambe phantsi iqosha lwe shift ne cofa nje semicolon. Bonke. Faka ixesha langoku ngohlobo "hh: mm".

Ukuze ugcine esiseleni ngoko nangoko kunye nomhla kunye nexesha elaneleyo emva kokufaka umhla ucofe kwibha ufake ixesha, usebenzisa iqhosha elikhankanyiweyo emfutshane.

Njengoko sibona, ukufaka umhla ifomati esisigxina ngoku Excel kulula. Le ukuphazamiseka kuphela kukuba kuyimfuneko kwi yeebhodi ezininzi ngaphandle izitshixo abongezelelweyo, switsha kwi IsiNgesi sitshixo sebhodi.

Umhla dynamically kubuyekezwa

umhla nezolo eluhlobo i updatable kucacisiwe Excel usebenzisa ifomula. Option ezimbini:

• Ifomula "= NAMHLANJE ()" ikuvumela ukuba ufumane umhla wangoku.
• Ifomula "= NGOKU ()" ikuvumela ukuba ufumane umhla wangoku kunye nexesha.

Le misebenzi kufuneka akukho anikwe kunye neemfundiso ezisisiseko ezifunyanwe kusetyenziswa kuzo zihlaziyiwe ixesha ngalinye ezisekelwe / khuphela / bawurhuqa fomyula okanye kwakhona ukuvulwa sheet.