Engeza usuku nosuku lwamanje ku-Google Spreadsheet
Imisebenzi Yosuku LwaseSpredishithi ye-Google
Kunemisebenzi eminingi yamanje etholakala kuma-Google Spreadsheets. Kuye ngezidingo zakho, ungasebenzisa umsebenzi wosuku ukuze ubuyele, phakathi kwezinye izinto, usuku olukhona noma isikhathi samanje.
Imisebenzi yosuku ingahle isetshenziswe emafomulini ukususa amadethi nezikhathi - njengokuthola izinsuku eziningi kakhulu kudlule usuku lwamanje noma izinsuku eziningi esikhathini esizayo.
Amapredishithi we-Google MANJE Umsebenzi
Omunye wemisebenzi yosuku olwaziwa kangcono yi-NOW umsebenzi futhi ungasetshenziselwa ukufaka ngokushesha usuku lwangoku - kanye nesikhathi uma ulufunayo - kwiphepha lokusebenzela noma lingafakwa ezinhlobonhlobo zamagama namafomula ahlukene njengoba kuxoxwe ngezansi.
MANJE Izibonelo Zezici
Umsebenzi we-MAN manje ungahlanganiswa nemininingwana yemisebenzi yokwakha amafomula amanani ahlukahlukene njengoba kuboniswa esithombeni ngenhla.
Ngomugqa, injongo yalezi fomula yilezi:
- Umzila owodwa: ubuyela inani lezinsuku kuze kube ngu-Spring 2016;
- Row ezimbili: ubuyela inani lezinsuku kusukela ngo-Christmas 2015;
- Row ezintathu: ubuyisela usuku oluyisihlanu ezinsukwini ezedlule;
- Umzila wesine: ubuyisela inombolo yezinsuku kuze kube sekupheleni kwenyanga yamanje;
- Imigqa emihlanu nesithupha: buyisela isikhathi samanje;
- Imigqa eyisikhombisa, eyisi-8, neyisishiyagalolunye: buyisa ihora lamanje (iwashi lamahora angu-24), iminithi, nesesibili;
- Row eziyishumi: ubuyisela usuku nesikhathi amahora angu-12 edlule (izikhathi zigcinwe njengezingxenyana zosuku lonke).
MANJE Umsebenzi we-Syntax ne-Arguments
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana .
I-syntax yomsebenzi we-MANJE yile:
= MANJE ()
Qaphela: Azikho izimpikiswano - idatha evame ukufakwa ngaphakathi kubakaki abasebenza emsebenzini - okwenziwe umsebenzi we-MANJE.
Ukufaka umsebenzi we-MANJE
Njengoba kungekho zimpikiswano zomsebenzi, MANJE ungangena ngokushesha. Nansi indlela:
- Chofoza kuseli lapho usuku / isikhathi kuzoboniswa khona ukwenza kube iseli esebenzayo .
- Thayipha: = Manje () kulowo makhalekhukhwini.
- Cindezela ukhiye wokungena kwikhibhodi.
- Usuku nesikhathi samanje kufanele kuboniswe esitokisini lapho ifomula ingene khona.
- Uma uchofoza kuseli eliqukethe usuku nesikhathi, umsebenzi ophelele = MANJE () uvela kubha yamasombulu ngaphezu kwephepha lokusebenzela.
Izinqamuleli zokunqamulela ukufometha Amaseli ezinsuku noma izikhathi
Ukuze ubonise usuku nje lwamanje noma isikhathi esitokisini, shintsha ifomethi yeseli kuze kube yisikhathi noma ifomethi yosuku usebenzisa okhiye bokunqamulela bekhibhodi alandelayo:
- Isinqamuleli sedethi yosuku (usuku / ngenyanga / kwifomethi yonyaka) : Ctrl + Shift + # (umaki we-hashi noma ukhiye wezignali)
- Isinqamuleli sesikhathi sokufometha (ihora: iminithi: ifomethi yesibili AM / PM) : Ctrl + Shift + @
Ukufometha I-Function MANJE usebenzisa i-Format Imenyu
Ukusebenzisa izinketho zemenyu ku-Google Spreadsheets ukufometha usuku noma isikhathi:
- Khetha ububanzi bamaseli ongathanda ukufometha noma ukuguqula;
- Chofoza kuFomathi > Inombolo > Usuku / Isikhathi .
Amafomu asetshenziselwa izinsuku nezikhathi besebenzisa le ndlela afana nalawo asetshenziswa ngokusebenzisa izinqamuleli zokufometha.
Ukulungiswa Kokusebenza Kwamanje Nesekhondi Lokusebenza
Umsebenzi we-MAN manje ilungu leqembu le-Google Spreadsheet yezinhlelo eziyingozi , okuzenzakalelayo, ukuphinda abuyele noma avuselele njalo uma ishidi lokusebenzela elitholakala kulo liphinde libuyele kabusha.
Isibonelo, ama-worksheet avuselela njalo lapho evuliwe noma lapho izenzakalo ezithile zenzeka - njengokungena noma ukuguqula idatha kuphepha lokusebenzela - ngakho uma usuku kanye / noma isikhathi ufakiwe usebenzisa umsebenzi we-MANJE, uzoqhubeka nokuvuselela.
Izilungiselelo zespredishithi - ezitholakala ngaphansi kwemenyu yefayela ku-Google Spreadsheets - inezilungiselelo ezimbili ezengeziwe lapho ishidi lokusebenzela liphinde lenzeke kabusha:
- Kushintsho njalo ngomzuzu.
- Kushintsho kanye nehora.
Akukho okukhethwa kukho ngaphakathi kohlelo lokuvala ukulungiswa kabusha kwemisebenzi ephikisayo.
Ukugcina Izinsuku Nezikhathi Eziqinile
Uma usuku nosuku noma / noma isikhathi sishintsha njalo akuyona into efiselekayo yokukhetha ukufaka izinsuku nezikhathi ezifakiwe kufaka phakathi ukuthayipha usuku / isikhathi ngesandla, noma ukufaka kuzo usebenzisa izinqamuleli zekhibhodi ezilandelayo:
- Isinqamuleli sosuku : Ctrl + ; (ukhiye we-colon wamaminithi)
- Isinqamuleli sesikhathi : Ctrl + Shift +: ((ukhiye wekhaloni)