Engeza usuku nosuku lwamanje nge-Excel's NOW function
Omunye wemisebenzi yedethi eyaziwayo kakhulu ye-Excel yinto esemthethweni, futhi ingasetshenziswa ukufaka ngokushesha usuku noma isikhathi samanje esikhwameni sokusebenzela.
Kungabuye ifakwe ezinhlobonhlobo zosuku nosuku amafomula ngezinto ezifana nalezi:
- ukuthola izinsuku eziningi kakhulu ezinsukwini ezedlule
- ukuthola inombolo yezinsuku ekupheleni kwenyanga yamanje
- kubuyisa umzuzu wamanje
MANJE Umsebenzi we-Syntax ne-Arguments
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, abahlukanisi be-comma kanye nezimpikiswano .
I-syntax yomsebenzi we-MANJE yile:
= MANJE ()
Qaphela: Umsebenzi we-MAN manje awunazo izimpikiswano-idatha evame ukufakwa phakathi kwabazali bomsebenzi.
Ukufaka umsebenzi we-MANJE
Njengemisebenzi eminingi ye-Excel, umsebenzi we-MAN manje ungangena ephepheni lokusebenzela usebenzisa ibhokisi lebhokisi lomsebenzi, kodwa njengoba lingathathi izingxabano, umsebenzi ungangena esitokisini esisebenzayo ngokuthayipha = Manje () futhi ucindezela ukhiye we- Enter kwikhibhodi . Umphumela ubonisa usuku nesikhathi samanje.
Ukuze ushintshe ulwazi olubonisiwe, lungisa ukufometha kweseli ukukhombisa usuku nje noma isikhathi usebenzisa ithebhu Ifomethi kuthebhu yemenyu.
Izinqamuleli zezinqamuleli zokufometha usuku nosuku
Ukufometha ngokushesha umsebenzi okwenziwe MANJE, sebenzisa izinqamuleli zekhibhodi ezilandelayo:
Idethi (ifomethi yonyaka wenyanga)
I-Ctrl + Shift + #Isikhathi (ihora: iminithi: ifomethi yesibili ne-AM / PM - njenge-10:33:00 AM)
I-Ctrl + Shift + @Inombolo yocingo / Usuku
Isizathu sokuthi umsebenzi we-MAN manje awutholi izingxabano ngoba umsebenzi uthola idatha yayo ngokufunda iwashi yesistimu yekhompiyutha.
Ama-Windows e-Excel agcina usuku njengenombolo emele inani lezinsuku ezigcwele kusukela phakathi kwamabili January 1, 1900 kanye nenombolo yamahora, imizuzu nemizuzwana yosuku lwamanje. Le nombolo ibizwa ngokuthi inombolo ye-serial noma idethi ye-serial.
Imisebenzi eguquguqukayo
Njengoba inombolo ye-serial iqhubeka njalo ngekhondi ngalinye elidlulayo, ukungena ngosuku lwamanje noma isikhathi nge-NOW function kusho ukuthi ukusebenza komkhiqizo kushintsha njalo.
Umsebenzi we-MAN manje uyilungu leqembu lika-Excel lemisebenzi ehlukumezayo , evuselela noma evuselela njalo uma ishidi lokusebenzela elitholakala kulo liphinde libuyele kabusha.
Isibonelo, ama-worksheet avuselela njalo lapho evuliwe noma lapho izenzakalo ezithile zenzeka-njengokungena noma ukuguqula kwedatha kushidi lokusebenza-ngakho usuku noma isikhathi lishintsha ngaphandle kokuthi ukuvuselelwa okuzenzakalelayo kuvaliwe.
Ukuphoqelela Umsebenzi Wokusebenzela / Ukulungiswa Kwezincwadi
Ukuphoqa umsebenzi ukuba ubuyekeze nganoma isiphi isikhathi, cindezela okhiye abalandelayo ekhibhodi:
- Shift + F9 ukuze ubuyekeze kabusha ishidi lokusebenzela elisebenzayo noma lamanje;
- F9 ukuvuselela zonke izincwadi zokusebenzela ezivulekile.
Ukugcina Izinsuku Nezikhathi Eziqinile
Ukuba nosuku nesikhathi okuguquka ngaso sonke isikhathi akuyona into efiselekayo ngaso sonke isikhathi, ikakhulukazi uma isetshenziselwa ukubalwa kwesikhashana noma uma ufuna usuku noma isikhathi isitembu somsebenzi.
Izinketho zokufaka usuku noma isikhathi azange zishintshe zihlanganisa ukuvala ukuvuselelwa okuzenzakalelayo, ukuthayipha amadethi nezikhathi ngesandla, noma ukungena kuzo usebenzisa izinqamuleli zekhibhodi ezilandelayo:
- Isinqamuleli sosuku yi- Control + ; (semicolon)
- Isikhathi esinqamuleli sesikhathi siyi- Control + Shift + : (colon)