Yongeza umhla wangoku kunye nexesha kwi-Google Spreadsheet
ImiSebenzi yosuku lweeSpredishithi zeGoogle
Kukho imisebenzi yamaphepha ekhoyo efumaneka kwi-Google Spreadsheets. Ngokuxhomekeka kwiimfuno zakho, ungasebenzisa umsebenzi wokuhlaziya, phakathi kwezinye izinto, umhla okhoyo okanye ixesha langoku.
Imisebenzi yomhla ingasetyenziselwa amafomula ukususa iintsuku kunye namaxesha - njengokufumana imihla eninzi kangangeentsuku ezidlulileyo kumhla wangoku okanye iintsuku ezininzi kwixesha elizayo.
Iipredishithi zeGoogle MANJE Umsebenzi
Enye yemisebenzi eyaziwayo engcono yile MSEBENZI WOKUSEBENZA kwaye ingasetyenziselwa ukufaka ngokukhawuleza umhla okhoyo-kunye nexesha xa uyifunayo- kwiphepha lokusebenzela okanye linokufakwa kwiintlobo zexesha kunye nexesha leemfomula njengoko kuchaziwe ngezantsi.
MSEBENZI Iimpawu zoSebenzi
Umsebenzi we-MAN manje unokudibaniswa nenani lemisebenzi yokwenza iintlobo zeemfomula ezahlukeneyo njengoko kuboniswe kumfanekiso ongentla.
Ngomqolo, injongo yale fomula yile:
- Umqolo owodwa: ubuyisela inani leentsuku kude kube ngu-Spring 2016;
- Iintambo ezimbini: ubuyisela inani leentsuku ukusuka kwiKrisimesi 2015;
- Iintambo ezintathu: ubuyisela umhla omihlanu edlulileyo;
- Inqanaba lesine: ubuyisela inani leentsuku de kube sekupheleni kwenyanga ekhoyo;
- Iimitha ezintlanu neesithandathu: buyisela ixesha langoku;
- Iinqonga ezisixhenxe, ezisibhozo, kunye nesithoba. Buyela ihora elikhoyo (ihora le-24 iiyure), umzuzu kunye nesibini;
- Iintambo ezilishumi: ubuyisela umhla kunye nexesha ezili-12 iiyure ezidlulileyo (amaxesha agcinwe njengeziqhezu zeentsuku zonke).
MANJE Umsebenzi we-Syntax kunye neeArguments
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano .
I-syntax yalo MSEBENZI yile:
= MANJE ()
Qaphela: Akukho ziphakamiso - idatha ngokuqhelekileyo efakwe ngaphakathi kubakaki obumjikelezi bomsebenzi - okwenziweyo umsebenzi.
Ukufaka umsebenzi okhoyo ngoku
Ekubeni akukho ziphakamiso zomsebenzi, MANJE unokungena ngokukhawuleza. Nantsi indlela:
- Cofa kwiseli apho ixesha / ixesha liza kuboniswa ukuze lenze iseli esebenzayo .
- Uhlobo: = Ngoku () kwilo lisele.
- Cinezela ukhiye wokungena kwikhibhodi.
- Umhla kunye nexesha kufuneka liboniswe kwiseli apho ifom yangeniswa khona.
- Ukuba ucofa kwiseli equkethe usuku kunye nexesha, umsebenzi opheleleyo = MANJE () ubonakala kwifom yefomula ngaphezulu kwiphepha lokusebenzela.
Iindlela ezimfutshane zokufometha iiseli kwixesha okanye ngamaxesha
Ukubonisa nje umhla okhoyo okanye ixesha kwiseli, tshintsha ifomathi kweso sithuba okanye ifomathi yosuku usebenzisa ezi zilandelayo zitshixo zokuncinci:
- Ukufometha umgca wokugqibela (usuku / inyanga / ifomathi yonyaka) : Ctrl + Shift + # (itekhi yehagi okanye iqhosha lomqondiso weenombolo)
- Fometha ixesha elifutshane elifutshane (iyure: iminithi: ifomathi yesibini ye-AM / PM) : Ctrl + Shift + @
Ukufometha UMSEBENZI WOKUSEBENZISA usebenzisa iMenyu yefomathi
Ukusebenzisa ukhetho lwemenyu kwi-Google Spreadsheets ukufometha umhla okanye ixesha:
- Khetha uluhlu lweeseli ongathanda ukuyifomathiza okanye ukuguqula;
- Cofa kwi Fomathi > Inani > Umhla / Ixesha .
Iifomati ezisetyenzisiweyo kumhla kunye namaxesha asebenzisa le ndlela zifana nezo zicelo zisetyenziselwa ukufometha amancinci.
Umsebenzi we-MANJE kunye noHlelo lokuSebenza
Umsebenzi we-MAN manje ilungu leqela le-Google Spreadsheet yeemisebenzi ezinqabileyo , ezithi, ngokuzenzekelayo, ziphinde zihlaziywe okanye zihlaziywe rhoqo xa iphepha lokusebenzela apho lifumaneka khona.
Ngokomzekelo, amaxwebhu okusebenzela aphinde ahlaziywe rhoqo xa avulwa okanye xa kwenzeka iziganeko ezithile-ezifana nokungena okanye ukutshintsha idatha kwiphepha lokusebenzela - ngoko ukuba umhla kunye / okanye ixesha lifakwe usebenzisa umsebenzi OWENZIWA, kuya kuqhubeka ukuhlaziya.
Izicwangciso zeSpredishithi - eziphantsi kweMenyu yeFayile kwi-Google Spreadsheets - inezicwangciso ezimbini ezongezelelweyo xa iphepha lokusebenzela liphindaphinda:
- Ngenguqu kunye neminithi.
- Ngenguqu kunye neyure.
Akukho khetho kwiprogram yokucima ukulungiswa kwemisebenzi engathandekiyo.
Ukugcina iixesha kunye nexesha elimisiweyo
Ukuba unomhla kunye / okanye ixesha lokutshintsha rhoqo akusifiseki ukuba ukhetho lokungena kwixesha elimisiweyo kunye nexesha kubandakanya ukuthayipha usuku / ixesha ngexesha lomntu, okanye ungene kuzo usebenzisa izicutshulwa zekhibhodi ezilandelayo:
- Umhla wokugqibela : Ctrl + ; (iqhosha le-colon elincinane)
- Ixesha elifutshane : I-Ctrl + Shift +: ((iqhosha lekholoni)