Wedzera zuva uye nguva iripo yeExpcel NOW function
Rimwe remabasa ekuzivikanwa eEexcel ndiro basa RINO, uye rinogona kushandiswa kukurumidza kuwedzera zuva razvino kana nguva kune rimwe pepaji.
Inogonawo kuiswa mumhando yakasiyana yezuva uye nguva yemaitiro yezvinhu zvakadai se:
- kutsvaga mazuva ari mazuva akawanda akapfuura zuva razvino
- kuwana nhamba yemazuva kusvika kumagumo emwedzi uno
- kudzorera ikozvino maminitsi
NOMO Basa Rinoshandiswa Sirikiti uye Arguments
Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemazana uye nharo .
Mutsara weNOW basa ndewokuti:
= NOW ()
Cherechedza: IYO ino basa haina mhedziso-iyo data inowanzopinda mukati mevabereki vebasa.
Kupinda NOMUSORO YEMUSORO
Kufanana nemabasa akawanda eExcel, NOW basa rinogona kuiswa mune pepa rekushandisa uchishandisa basa rebhokisi rebhokisi , asi sezvo zvisingatauri nharo, basa rinogona kupinda muchikamu chinoshandiswa nekunyora = Zvino () uye kuvhara muIndo yekupinda pane keyboard . Chigumisiro chinoratidza zuva razvino uye nguva.
Kuti uchinje ruzivo rwakaratidzwa, shandura mafaira ekufambisa kuti aratidze zuva kana nguva inoshandisa Format format pane bar menu.
Shortcut Mazano Ekugadzirisa Musi Nezuva
Kuti udzidze nokukurumidza BASA basa rinobudiswa, shandisa maitiro ekutsvaga ma keyboard:
Musi (zuva-mwedzi-gore mafomati)
Ctrl + Shift + #Nguva (awa: miniti: yechipiri uye AM / PM format) - sa10: 33: 00 AM)
Ctrl + Shift + @Serial Number / Date
Chikonzero chekuti NOW basa harina matanho ndechokuti basa rinowana dhiyo yacho nekuverenga kombiyuta yeawadhi system.
Windows versions dzeExcel dzinochengetedza zuva sechiverengero chinomirira nhamba yezuva rakakwana kubva pakati pousiku January 1, 1900 pamwe nhamba yeawa, maminitsi nemaminitsi ezuva ranhasi. Iyi nhamba inonzi serial number kana seri seri.
Mabasa Asina Basa
Sezvo nhamba ye serial inowedzera ichiwedzera nechipiri chepfuura, kupinda muzuva razvino kana nguva neIYO basa rinoreva kushanda kwezvinhu kunoramba kuchichinja.
Ikozvino basa iri nhengo yeboka raExcel rekushanda, iro rinodzokorora kana kurongedza nguva dzose apo pepa rekushandira kwavanove rava kunoratidzira zvakare.
Semuenzaniso, mapepa emashandi anoyevedza nguva dzose kana achivhurwa kana apo zvimwe zviitiko zvinenge zvichiitika-zvakadai sokupinda kana kuchinja kwedhesi mubasa rekushanda-saka zuva kana nguva inoshandiswa kunze kwekungoerekana kugadziriswa kwekare kuchibviswa.
Kumanikidza Purogiramu Yebasa / Bhuku Rekugadzirisa
Kukumanikidza basa kuti rishandise chero nguva, shandisa zvinotevera zvinotevera pane keyboard:
- Shift + F9 kuti idzokezve purogiramu yekushanda kana ino yemazuva ano;
- F9 kugadzirisazve mabhuku ose emabhuku akazaruka.
Kuchengeta Mazuva Nenguva Dzakasimba
Kuva nezuva uye nguva nguva dzose zvinoshanduka hazvisi nguva dzose zvinodiwa, kunyanya kana zvichishandiswa mumazuva ekuverenga kana iwe uchida zuva kana nguva yechitsipa chesepeji.
Sarudzo yekupinda zuva kana nguva kuitira kuti irege kushandura dzinosanganisira kurega zvinyorwa zvekugadzirisa, kuverenga mazuva uye nguva mumunhu, kana kupinda mazviri uchishandisa zvishoma zvishoma zvinotevera:
- Zuva rekutsvaga ndiro Control + ; (semicolon)
- Nguva shoma shoma ndiyo Control + Shift + : (colon)