Onjezerani tsiku ndi nthawi ya Google Spreadsheet
Mapulogalamu a tsiku la Google Spreadsheets
Pali ntchito zamtundu zingapo zomwe zilipo mu Google Spreadsheets. Malingana ndi zosowa zanu, mungagwiritse ntchito ntchito tsiku kuti mubwererenso, pakati pazinthu zina, tsiku lamakono kapena nthawi yamakono.
Ntchito yamasiku ingagwiritsidwenso ntchito m'mafomu kuti achotsedwe masiku ndi nthawi - monga kupeza masiku omwe ali ochuluka kwambiri masiku opitirira lero kapena masiku ambiri mtsogolomu.
Google Spreadsheets NOW Ntchito
Imodzi mwa ntchito zodziwika bwino tsiku ndi ntchito YOMWE ndipo ingagwiritsidwe ntchito kuwonjezerapo tsiku lomwe liripo - ndi nthawi ngati likufunidwa - ku pepala la zolemba kapena likhoza kuphatikizidwa muzosiyana siyana za nthawi ndi nthawi monga momwe tafotokozera pansipa.
ZOYENERA Zitsanzo Zothandiza
Ntchito YOMWE ikhoza kuphatikizidwa ndi ntchito zingapo kuti apange mitundu yosiyanasiyana ya maonekedwe monga momwe tawonetsera pa chithunzi pamwambapa.
Mwa mzere, cholinga cha mawonekedwe awa ndi:
- Mzere umodzi: kubwerera chiwerengero cha masiku mpaka Spring 2016;
- Zowonjezera ziwiri: amabwereranso chiwerengero cha masiku kuyambira Khrisimasi 2015;
- Zowonjezera zitatu: kubwezeretsanso tsikulo masiku asanu apitawo;
- Zowonjezera zinayi: kubwezera chiwerengero cha masiku mpaka kumapeto kwa mwezi wamakono;
- Lima zisanu ndi zisanu ndi chimodzi: kubwezerani nthawi yeniyeni;
- Lembera zisanu ndi ziwiri, zisanu ndi zitatu, ndi zisanu ndi zinayi: bweretsani ola lomwe liripo (ola la maola 24), miniti, ndi yachiwiri;
- Row kumi: amabwezeranso tsiku ndi nthawi 12 maola apitawo (nthawi zimasungidwa monga magawo a masiku onse).
ZOCHITA Pulogalamu ya Syntax ndi Arguments
Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa .
Mawu omasulira a MASIKU ano ndi awa:
= TSOPANO ()
Zindikirani: Palibe zotsutsana - deta yomwe imalowa mkati mwa makina oyendetsa ntchito - PAMASIKU ano.
Kulowa Ntchito Yamakono
Popeza palibe zotsutsana za ntchitoyi, TSOPANO ikhoza kulowa mwamsanga. Nazi momwemo:
- Dinani mu selo pomwe tsiku / nthawi idzawonetsedwa kuti ikhale selo yogwira ntchito .
- Mtundu: = Tsopano () mu selo limenelo.
- Dinani ku key lolowamo pa khibhodi.
- Tsiku ndi nthawi zomwe zilipo tsopano ziyenera kuwonetsedwa mu selo momwe ndondomekoyi inalowetsedwera.
- Ngati inu mutsegula selo liri ndi tsiku ndi nthawi, ntchito yonse = NOW () ikuwoneka mu barolo lazenera pamwamba pa tsamba.
Njira Zowonjezera Zowonetsera Maselo kwa Nthawi kapena Nthawi
Kuti muwonetse tsiku lenileni kapena nthawi yomwe ili mu selo, sintha mawonekedwe a seloyo mpaka nthawi kapena fomu yamakono pogwiritsa ntchito makiyi afupikitsa awa:
- Kutsatsa kwadongosolo lamasamba (tsiku / mwezi / chaka mawonekedwe) : Ctrl + Shift + # (chizindikiro cha chikhomo kapena chilembo cha chizindikiro)
- Sinthani nthawi yochezera (hour: miniti: yachiwiri AM / PM maonekedwe) : Ctrl + Shift + @
Kupanga mawonekedwe a ZOYENERA Pulogalamu pogwiritsira ntchito Menyu Yopangira
Kuti mugwiritse ntchito masankhidwe omwe ali mu Google Spreadsheets kuti musinthe tsiku kapena nthawi:
- Sankhani ma selo osiyanasiyana omwe mukufuna kupanga kapena kusintha;
- Dinani pa Format > Number > Date / Time .
Zopangidwe zomwe zimagwiritsidwa ntchito pa nthawi ndi nthawi kugwiritsa ntchito njirayi ndizofanana ndi zomwe zimagwiritsidwa ntchito kugwiritsa ntchito mafupikitsidwe.
Ntchito Yowonjezera ndi Kukonzekera Kabukhu Kakang'ono
Ntchito YOMWE ndi membala wa gulu la Google Spreadsheet la ntchito zosasinthasintha , zomwe, mwachisawawa, zimawerenganso kapena kusinthidwa nthawi iliyonse yomwe tsamba limene alimo likuwerenganso.
Mwachitsanzo, mapepala amatha kubwereza nthawi iliyonse yomwe atsegulidwa kapena pamene zochitika zina zimachitika - monga kulowa kapena kusintha deta pa tsamba - kotero ngati tsiku ndi / kapena nthawi yalowa ntchito TSOPANO ntchito, idzapitirizabe kusinthika.
Makhalidwe apamwamba - omwe ali pansi pa Fayilo menyu mu Google Spreadsheets - ali ndi zoonjezerapo zina ziwiri pamene tsambali likugwiritsanso ntchito:
- Pa kusintha ndi miniti iliyonse.
- Pa kusintha ndi ola lililonse.
Palibe njira mkati mwa pulojekiti yakuletsa kubwezeretsedwa kwa ntchito zosasinthasintha.
Kusunga Nthawi ndi Nthawi Zimakhala Zolimba
Ngati kukhala ndi tsiku ndi / kapena nthawi kumasintha sizowonjezereka zosankha zolowera masiku ndi nthawi zikuphatikizapo kujambula tsiku / nthawi mwadongosolo, kapena kulowa nawo pogwiritsa ntchito njira zotsatilazi:
- Chotsatira cha tsiku : Ctrl + ; (key-colon key)
- Njira yotsatsa nthawi : Ctrl + Shift +: ((key colon)