Usuku lwamanje. Kanjani ukuze uthole idethi nesikhathi samanje Excel

Excel kuyinto corporation "Microsoft" kuyinto processor enamandla, okuyinto kusiza abasebenzisi amaningi emsebenzini nsuku zonke nge esiningi idatha yethebula. Nokho, ochwepheshe ngisho wazibonela, eminyakeni eminingi esebenza lolu hlelo, ngezinye izikhathi elahlekile isidingo ukufaka ku eseshadini cell idethi nesikhathi samanje. Lokhu kungenxa kakhulu ngenxa yokuthi umsebenzi "Usuku", ukuthi kunengqondo ukusebenzisa ukuthola amagugu oyifunayo, wenza umsebenzi ohluke ngokuphelele. Kulesi sihloko, sizokutshela mayelana izinhlobo ezahlukene izinsuku zisetshenziselwa Excel, ukuze nezinqubo nokulungiselela isicelo sabo izici.

izinhlobo izinsuku

Excel libona ezimbili ongakhetha "Usuku lwamanje". Eyokuqala wabo - lena Inani elimisiwe usuku nesikhathi samanje, egcinwe kukhompyutha komuntu siqu komsebenzisi. Uma wangena lokusebenzela, ukubaluleka ngeke kushintshe kungakhathaliseki izinguquko esikhathini sangempela nosuku. Uma kungase kudingeke le ndlela? izimpendulo eziningi, ngokwesibonelo, lapho usuku esitolo ukuthola umsebenzi ukusebenza noma ukuxoshwa, faka usuku kokuthola izimpahla kuya ishede. Lamagugu kumelwe ihambisane, ngoba abazi ukushintsha kwesikhathi.

Le nguqulo yesibili ka "Usuku lwamanje" - onamandla, kushintshashintsha, updateable. Ukusetshenziswa ezivame kakhulu le ndlela - idethi nesikhathi ukubaluleka ekhoneni sekhasi, njengengxenye eliqoshwe umbhalo othi "Namuhla, Meyi 14, 2017". Lokhu okuhlukile kabanzi lisetshenziswe amafomula, isibonelo ukubala zingaki izinsuku sele idlulile solo inombolo ethile. Abasebenzi bangase ngaleyo ndlela funda ongahambi khona ekupheleni kwesikhathi probationary isisebenzi, kanye isheke umsebenzi isitokwe, hhayi phezu ukuthi kwesikhathi usuku athola la maphilisi.

Yiqiniso, usuku ashukumisayo nesikhathi Excel iyasiza, kodwa kukhona into ebaluleke kakhulu: Ukuvuselela okuqhubekayo yamanani idatha ingekho. Inani olifakile zizoshintsha ngesikhathi uwavule yencwadi, lapho Macro kulesi sibalo zibalo ahlukahlukene. Uma nje ushiye incwadi evulekile, futhi akekho izinyathelo ezingenhla ngeke enze, usuku kanye nesikhathi bazosala amagugu oyifake esisodwa. Kodwa kubalulekile ukuba kabusha ukuvula le ncwadi noma recalculate ifomula, amagugu kuzobuyekezwa.

Cabanga indlela Excel ukufaka kulezi zinhlobo ezimbili nezinsuku.

Kosuku olunqunyiwe, azibuyekezi

Excel value "usuku zamanje" ingatholakala ngokumane ngokucindezela ukhiye u-Ctrl, futhi ";". Vele ume iseli oyifunayo ephepheni lokusebenzela futhi ngokushesha ubamba ikhi Ctrl bese ucindezela isemikholoni. Iseli kuyoba usuku wamanje ngefomethi lamafisha, sib 5/14/2017.

Ukufaka isikhathi, enze operation efanayo ngokubamba ukhiye Ctrl, chofoza bese ubamba ukhiye we-Shift futhi nje ucindezela isemikholoni. Zonke. Faka isikhathi samanje ngefomethi "hh: mm".

Ukuze ugcine kuseli ngokushesha futhi usuku nesikhathi esanele emva ufaka usuku cindezela ibha yesikhala ukufaka isikhathi, kusetshenziswa imininingwane yamakheli asetshenziswAa ngabaningi.

Njengoba singabona, ukufaka wamanje usuku Ifomethi elungisiwe Excel kulula. Ngokuphazamisa kuphela ukuthi siyadingeka ikhibhodi kakhulu ngaphandle okhiye ezengeziwe, ukushintshela IsiZulu isendlalelo sekhibhodi.

Usuku ngamandla olusha

Usuku lwamanje ngesimo i Updatable kuchaziwe Excel usebenzisa amafomula. Inketho ezimbili:

• Ifomula "= NAMUHLA ()" ikuvumela ukuba uthole usuku wamanje.
• Ifomula "= MANJE ()" ikuvumela ukuba uthole idethi nesikhathi samanje.

Lezi imisebenzi abanalo agumenti kanye namagugu etholwe ukuzisebenzisa ishintsha isikhathi ngasinye based / ikhophi / edonsa amafomula noma ukuvulwa kabusha ishidi.