Wedzera zuva razvino uye nguva yeGoogle Spreadsheet
Google Spreadsheets Gwaro reMabasa
Pane huwandu hwemashoko ezuva anowanikwa muGoogle Spreadsheets. Zvichienderana nezvamunoda, unogona kushandisa zuva rekushanda kuti udzoke, pakati pezvimwe zvinhu, zuva razvino kana nguva yazvino.
Zuva remabasa rinogonawo kushandiswa mukufananidzira kubvisa mazuva uye nguva - zvakadai sekuwana mazuva akawanda mazuva akapfuura zuva ranhasi kana mazuva akawanda munguva yemberi.
Google Spreadsheets NOW Function
Rimwe remazuva anozivikanwa anozivikanwa ndiro NOMO basa uye rinogona kushandiswa kukurumidza kuwedzera zuva razvino - uye nguva kana zvichidikanwa - kune pepa rekushanda kana rinogona kuiswa mumhando yakasiyana yezuva uye nguva yemaitiro sezvakakurukurwa pasi apa.
NOMO Basa reMienzaniso
Izvo zvino basa rinogona kusanganiswa nemhando yezvigadziro kugadzira zvakasiyana-siyana zvemazuva mapepa sezvaratidzwa mumufananidzo uri pamusoro.
Mutsara, chinangwa chemazwi aya ndechekuti:
- Row one: anodzoka nhamba yemazuva kusvikira Gore 2016;
- Row maviri: anodzoka nhamba yemazuva kubva Krisimasi 2015;
- Row matatu: kudzorera musi wacho mazuva mashanu akapfuura;
- Row mana: anodzoka nhamba yemazuva kusvikira pakuguma kwemwedzi uno;
- Rowhi shanu uye nhanhatu: dzokai nguva yezvino;
- Rows manomwe, masere, uye mapfumbamwe: dzokai nguva yezvino (awa yeawa 24), miniti, uye yechipiri;
- Row gumi: anodzorera zuva uye nguva 12 maawa apfuura (nguva dzinoshandiswa sezvikamu zvemazuva ose).
NOMO Basa Rinoshandiswa Sirikiti uye Arguments
Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemavara, uye nharo .
Mutsara weNOW basa ndewokuti:
= NOW ()
Cherechedza: Hapana mhinduro - iyo data inowanzopinda mukati mekusungirirana kwebasa - nokuda kweZVO basa.
Kupinda NOMUSORO YEMUSORO
Sezvo pasina zvikonzero zvebasa racho, ZVINO zvinogona kukurumidza kupinda. Heino nzira:
- Dzvanya pane sero apo zuva / nguva icharatidzwa kuti iite iyo seki inoshanda .
- Tora: = Iye zvino () mune iyoyo cell.
- Dhinda pikicha inopinda mubhokisi.
- Zuva rezuva uye nguva inofanira kuiswa muchitokisi umo maitiro acho akaiswa.
- Kana iwe ukanyora pachitokisi chine zuva uye nguva, basa rakakwana = NOW () rinowanikwa mubhairi yepamusoro pane pepa pepaji.
Shortcut Mazano Ekugadzirisa Maseji Kwemazuva kana Nguva
Kuti uratidze zuva rekuti ikozvino kana nguva iri muchitokisi, shandura mafomisi esero pane imwe nguva kana fomati yezuva uchishandisa makatekheni ekutsinhanisa ma keyboard:
- Dhidhiro yekusvitsa kwezuva (zuva / mwedzi / gore fomu) : Ctrl + Shift + #
- Purogiramu nguva shoma (awa: miniti: yechipiri AM / PM format) : Ctrl + Shift + @
Kufambisa NOW Function uchishandisa Format Format
Kushandisa zvingasarudzwa mumenu muGoogle Spreadsheets kuti usvike zuva kana nguva:
- Sarudza uwandu hwemasero waungada kuomesa kana kuchinja;
- Dzvanya pa Format / Number > Date / Time .
Mafomu anoshandiswa kune mazuva uye nguva dzinoshandisa nzira iyi zvakafanana neaya anoshandiswa kushandisa maitiro ekufambisa.
Iko Basa reNOW uye Worksheet Recalculation
Ikozvino basa iri nhengo yeGoogle Spreadsheet yeboka remabasa asina simba , ayo, nekutadza, kudzokorora kana kurongedza nguva dzose apo pepa rekushandira ravanove rava kunoratidzira.
Semuenzaniso, mapepa emashandi anoyevedza nguva dzose kana achizarurirwa kana zvimwe zviitiko zvikaitika - sekupinda kana kushandura dhidhiro mumushandi - naizvozvo kana zuva uye / kana nguva zvichisvika vachishandisa BASA rino, richaramba richivandudza.
Zvirongwa zvepadheseti - zviri pasi peFiri menyu muGoogle Spreadsheets - ine mazamu maviri ezvepamusoro apo pepa rekushandura rinodzokorora:
- Pakuchinja uye maminitsi ose.
- Pakuchinja uye awa imwe neimwe.
Izvo hazvina chakanaka mukati meguro rekuvhara kugadziriswa kwekushanda kwemabasa.
Kuchengeta Mazuva Nenguva Dzakasimba
Kana kuva nezuva uye / kana nguva zvichiri kuchinjwa hazvidikanwi zvisarudzo zvekupinda mazuva uye nguva zvinosanganisira kuisa zuva / nguva mumunhu, kana kupinda mazviri uchishandisa zvishoma zvishoma zvinotevera:
- Zuva rakapera : Ctrl + ; (key semi-colon key)
- Nguva shoma : Ctrl + Shift +: ((koni yekoni)