Raws li koj xav tau, koj tuaj yeem siv hnub ua haujlwm hauv Google Sheets kom rov qab los, ntawm lwm yam, hnub tam sim no lossis lub sijhawm tam sim no.
Hnub ua haujlwm ua haujlwm hauv cov qauv los rho tawm hnub thiab sijhawm, xws li nrhiav cov hnub uas yog qee cov hnub yav tom ntej.
kab hauv qab
Ib qho ntawm cov hnub paub zoo dua yog qhov tam sim no () ua haujlwm. Siv nws los ntxiv hnub tam sim no - thiab sijhawm, yog tias tsim nyog - rau daim ntawv ua haujlwm, lossis nws tuaj yeem muab tso rau hauv ntau hom hnub thiab sijhawm.
Tam sim no muaj nuj nqi Syntax thiab cov lus sib cav
A muaj nuj nqi syntax hais txog kev teeb tsa ntawm lub luag haujlwm thiab suav nrog cov haujlwm lub npe, cov hlua khi, cov cim cais, thiab cov lus sib cav.
Tus syntax rau NOW() muaj nuj nqi yog:
=NOW()
Tsis muaj kev sib cav - cov ntaub ntawv ib txwm nkag mus rau hauv lub luag haujlwm lub voj voog ncig - rau NOW() ua haujlwm.
Nkag mus rau tam sim no muaj nuj nqi
Vim TAM SIM NO () tsis muaj kev sib cav, tuaj yeem nkag tau sai. Nov yog li cas:
- Xaiv lub xovtooj uas hnub lossis sijhawm yuav tshwm sim, ua kom nws lub xovtooj ua haujlwm.
-
Enter the formula:
=Now()
- Nias lub Enter tus yuam sij ntawm cov keyboard. Hnub tim thiab lub sij hawm tam sim no yuav tsum tau muab tso rau hauv lub xov tooj ntawm tes uas tus qauv tau nkag. Yog tias koj xaiv lub xov tooj ntawm tes uas muaj hnub thiab sijhawm, qhov ua tiav tiav tshwm sim hauv cov qauv bar saum toj no daim ntawv ua haujlwm.
Shortcut Keys rau Formatting Cells rau hnub lossis Sijhawm
Txhawm rau tso tawm hnub tam sim no lossis lub sijhawm hauv lub xovtooj, hloov hom ntawm tes mus rau lub sijhawm lossis hnub hom siv cov keyboard shortcuts.
- Tus qauv hnub luv (hnub / hli / xyoo) yog Ctrl + Ua haujlwm +.
- Lub sij hawm luv luv (teev: feeb: thib ob AM / PM hom) yog Ctrl+Shift+@.
Formatting tam sim no muaj nuj nqi Siv hom ntawv qhia zaub mov
Siv cov kev xaiv zaub mov hauv Google Sheets los format hnub lossis sijhawm:
- Xaiv ntau lub hlwb koj xav tsim lossis hloov kho;
-
Xaiv Format > Number xaiv ib hom ntawv uas siv ntau tshaj plaws, lossis xaiv Format > Number > More Formats > Ntau Hnub thiab Sijhawm Formats qhib lub thawv dialog qhia kom meej ib hom ntawv.
Image - Qhia kom meej tias cov hlwb sib xws li hom ntawv koj xav.
Cov qauv siv rau hnub thiab sijhawm siv txoj kev no yog tib yam li cov ntawv thov siv cov ntawv luv luv.
Tam sim no muaj nuj nqi thiab daim ntawv ua haujlwm rov qab
NOW() muaj nuj nqi yog ib tus tswv cuab ntawm Google Sheet pawg ntawm cov haujlwm tsis hloov pauv, uas, los ntawm lub neej ntawd, rov xam lossis hloov kho txhua zaus cov ntawv ua haujlwm uas lawv nyob rov suav dua.
Piv txwv li, daim ntawv ua haujlwm rov suav dua txhua lub sijhawm lawv qhib lossis thaum muaj qee yam xwm txheej tshwm sim - xws li thaum cov ntaub ntawv nkag lossis hloov pauv hauv daim ntawv ua haujlwm - yog li yog hnub lossis sijhawm nkag mus siv NOW() ua haujlwm, nws txuas ntxiv hloov tshiab.
Cov ntawv teeb tsa, uas nyob hauv qab cov ntawv qhia zaub mov hauv Google Sheets, muaj ob qhov chaw ntxiv rau thaum daim ntawv ua haujlwm rov suav dua:
- Ntawm kev hloov pauv thiab txhua feeb
- Ntawm kev hloov pauv thiab txhua teev
Tsis muaj kev xaiv nyob rau hauv qhov kev pab cuam rau kev kaw rov suav cov haujlwm tsis hloov pauv.
Khaws Hnub thiab Sijhawm Zoo
Yog tias muaj hnub lossis sijhawm hloov pauv txuas ntxiv tsis xav tau, siv qhov kev xaiv luv rau nkag mus rau cov hnub qub thiab lub sijhawm suav nrog ntaus hnub lossis sijhawm manually lossis nkag rau lawv siv cov keyboard shortcuts hauv qab no:
- Hnub static shortcut yog Ctrl+; (semi-colon key)
- Lub sijhawm luv luv yog Ctrl + Ua haujlwm +: (tus yuam sij)
