Hauv Microsoft Office Excel, koj tuaj yeem ua cov kev suav ntawm cov ntaub ntawv hauv cov xuab moos, feeb thiab vib nas this hom. Yog tias koj xav tau xam lub sijhawm, siv daim qauv tsim nyog rau qhov no.
Cov Lus Qhia
Kauj ruam 1
Yog tias qhov no yog koj thawj zaug ntsib lub sijhawm ua haujlwm ntawm lub sijhawm, sim tsis txhob mus rau txoj haujlwm sai sai tam sim ntawd. Kev suav feem ntau tuaj yeem ua nrog cov qauv zauv yooj yim: ntxiv thiab rho tawm. Thiab nco ntsoov muab cov kabmob rau cov qauv kawm kom raug.
Kauj ruam 2
Txhawm rau ua qhov no, xaiv cov kab ntau ntawm cov hlwb rau cov ntaub ntawv twg yuav nkag mus rau sab xis thiab xaiv txoj haujlwm xaiv, lossis qhib "Lub Tsev" tab thiab nyem khawm "Format" hauv "Cells" toolbar. Hauv ob qho tib si thawj zaug thiab zaum ob, xaiv qhov "Format cells" nyob rau hauv cov ntawv qhia zaub mov.
Kauj ruam 3
Lub npov tshiab yuav qhib, xyuas kom koj nyob ntawm Tus Naj Npawb Tab. Hauv daim ntawv uas nyob rau sab laug ntawm lub qhov rais, xaiv cov khoom "Lub sijhawm" nrog tus nas laug khawm. Hauv seem ntawm lub qhov rais, qhia kom meej hauv lub sijhawm twg yuav tsum tau hais tawm. Nyem rau ntawm OK khawm kom paub meej tias koj xaiv.
Kauj ruam 4
Nkag mus rau cov ntaub ntawv hauv lub hlwb ua hom ntawv XX: XX (lossis XX: XX: XX). Los xam lub sij hawm sib nrug ntawm tus nqi thawj thiab theem ob, muab tus cursor tso rau hauv lub xov tooj ntawm qhov chaw uas tag nrho cov nqi tshwm. Hauv cov ntawv qhia mis, muab ib daim phiajcim sib npaug, nyem rau ntawm kab ntawv nrog tus nqi kawg nrog rau sab laug nas khawm, nkag mus rau cov cim rho tawm, tom qab ntawd nyem rau ntawm lub cell nrog tus nqi thawj. Nias Enter Sau.
Kauj ruam 5
Piv txwv li: lub sijhawm dhau los ntawm 11:10:15 txog rau 12: 30:00 yog 1 teev, 19 feeb thiab 45 vib nas this. Tus nqi tag nrho hauv cell C2 yog suav los ntawm tus qauv: = B2-A2. Yog tias koj xav suav lub sij hawm ncua nyob hauv ntau kab (A3 thiab B3, A4 thiab B4, thiab lwm yam), tsuas yog luag cov cim autocomplete los ntawm cell C2 mus rau qhov kawg ntawm koj cov kem kab ntawv (C3, C4).
Kauj Ruam 6
Yog tias koj xav tau suav pes tsawg tag nrho cov xuab moos, feeb thiab vib nas this nws coj mus rau qee yam, tsuas yog ntxiv cov ntaub ntawv tau nyob rau hauv txoj kev saum toj no siv SUM muaj nuj nqi. Muab tus cursor tso rau hauv lub cell nrog tag nrho cov nqi, nyem rau ntawm fx khawm, hauv lub qhov rai uas zoo nkaus li, xaiv SUM ua haujlwm nrog rau sab laug nas khawm thiab cim cov kab ntawm cov hlwb uas yuav koom nrog hauv kev suav. Nias Enter Sau. Cov laij ntsuas yuav zoo li no: = SUM (C2: C4).
