Ƙara kwanan wata da lokaci tare da aikin NASA na Excel
Ɗaya daga cikin sanannun kwanan wata na Excel shine aikin NOW, kuma ana iya amfani da ita don ƙara sauri kwanan wata ko lokaci zuwa wani aikin aiki.
Har ila yau za'a iya shigar da shi a cikin kwanan wata da lokaci da aka tsara don abubuwa kamar:
- kwanakin kwanakin da suka wuce kwanakin da suka gabata
- gano yawan kwanakin zuwa ƙarshen watan yanzu
- dawo da minti na yanzu
NOW Aiki Hanya da Magana
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, ɓangaren sharaɗi da kuma muhawara .
Haɗin aikin NOW shine:
= NOW ()
Lura: Ayyukan NOW ba su da wata hujja-yawancin bayanai da aka shigar a cikin iyayensu na aikin.
Shigar da aikin NOW
Kamar mafi yawan ayyuka na Excel, aikin NOW za a iya shigar da shi a cikin takardun aiki ta amfani da akwatin maganganun aikin, amma tun da yake ba ta da wata hujja, za a iya shigar da aikin a cikin tantanin halitta ta hanyar buga = Yanzu () kuma latsa maɓallin Shigar da ke keyboard . Sakamakon yana nuna kwanan wata da lokaci na yanzu.
Don canza bayanin da aka nuna, daidaita tsarin sirrin don nuna kawai kwanan wata ko lokacin amfani da shafin Tabba a mashaya menu.
Hanyar gajeren hanya zuwa ranar tsarawa da lokaci
Don tsara fasalin aikin NOW da sauri, yi amfani da gajerun hanyoyi masu zuwa na gaba:
Kwanan wata (tsarin kwanan wata-shekara)
Ctrl + Shift # #Lokaci (awa: minti: na biyu da AM / PM - kamar 10:33:00 AM)
Ctrl + Shift @ @Lambar Serial / Kwanan wata
Dalilin aikin NOW ba shi da wani muhawara saboda aikin yana samun bayanansa ta hanyar karatun agogon tsarin kwamfuta.
Fassara Windows na Excel ajiye kwanan wata azaman lambar da ke wakiltar adadin kwanaki cikakke tun daga tsakiyar Janairu 1, 1900 tare da adadin sa'o'i, minti da sakanci don kwanan nan. Ana kiran wannan lamba lambar lamba ko kwanan wata.
Ayyuka masu banƙyama
Tun da lambar serial ta ci gaba da ƙaruwa tare da kowane wucewa na biyu, shigar da kwanan wata ko lokaci tare da aikin NOW yana nufin ma'anar aikin yana cigaba da sauyawa.
Ayyukan NOW na memba ne na ƙungiyar Excel na ayyuka masu banƙyama , wanda ya sake rikodin ko sabunta duk lokacin da ɗigin aikin da aka samo su yana ɓoyewa.
Alal misali, takardun aiki suna sake rikodin duk lokacin da aka bude su ko kuma lokacin da wasu abubuwan sun faru-kamar shigarwa ko canza bayanai a cikin takardun aiki-don haka kwanan wata ko lokaci zai canza sai dai an sake kashewa ta atomatik.
Ƙarfafa Ayyukan rubutu / Ayyukan Ayyuka
Don tilasta aikin don sabuntawa a kowane lokaci, latsa maɓallai masu zuwa a kan keyboard:
- Shift + F9 don sake rikodin aikin aiki ko aiki na yanzu;
- F9 don sake rikodin duk litattafai masu buɗewa.
Tsayawa Dates da Takaddun Times
Samun kwanan wata da lokaci canzawa kullum ba kyawawan kyawawan ba, musamman idan an yi amfani da su a kwanan wata ko kuma idan kana son kwanan wata ko lokacin hatimi don takardar aiki.
Zaɓuɓɓuka don shigar da kwanan wata ko lokaci don haka ba su canzawa sun hada da kashe kashewa ta atomatik, rubuta kwanakin da lokuta tare da hannu, ko shigar da su ta amfani da gajerun hanyoyin keyboard masu zuwa:
- Yanayin kwanan wata shine Control + ; (semicolon)
- Lokacin gajeren hanya shine Control + Shift + : (mallaka)