Onjezerani tsiku ndi nthawi yomwe ili ndi ntchito ya EXLOWOWO
Imodzi mwa ntchito zodziwika kwambiri za tsiku la Excel ndi ntchito YOMWE, ndipo ingagwiritsidwe ntchito kuwonjezera mwatsatanetsatane tsiku kapena nthawi yamakono pa tsamba.
Ikhozanso kuphatikizidwa mu nthawi zosiyanasiyana ndi nthawi zolemba zinthu monga:
- kupeza masiku omwe ali masiku ochuluka kuposa tsiku lamakono
- kupeza nambala ya masiku mpaka kumapeto kwa mwezi wamakono
- kubwezeretsa mphindi yamakono
ZOCHITA Pulogalamu ya Syntax ndi Arguments
Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakia, olekanitsa okometsa ndi otsutsana .
Mawu omasulira a MASIKU ano ndi awa:
= TSOPANO ()
Zindikirani: Ntchito YOMASO ilibe zifukwa-deta yomwe imalowa mkati mwazinthu zothandizira.
Kulowa Ntchito Yamakono
Monga momwe ntchito zambiri za Excel zimakhalira, ntchito YOMWE ingathe kulowetseramo ntchito pogwiritsa ntchito bokosi la bokosi la ntchito , koma popeza silingagwirizane, ntchitoyo ikhoza kulowa mu selo yogwira ntchitoyo polemba = Tsopano () ndi kukanikiza fungulo lolowamo mulowe . Zotsatira zimasonyeza tsiku ndi nthawi yomwe ilipo.
Kusintha malingaliro omwe asonyezedwa, sungani maonekedwe a selo kuti asonyeze tsiku kapena nthawi yogwiritsa ntchito Tabu yazomweyi pa bar.
Zowonjezera Zowonjezereka Zomwe Mungapange Tsiku ndi Nthawi
Kuti mupange mwamsanga ntchito YOPHUNZITSA ntchito, gwiritsani ntchito njira zotsatirazi:
Tsiku (chaka cha mwezi wa mwezi)
Ctrl + Shift + #Nthawi (ola: miniti: yachiwiri ndi AM / PM maonekedwe - monga 10:33:00 AM)
Ctrl + Shift + @Nambala ya Chithunzi / Tsiku
Chifukwa chimene ntchito YOMWE simukutsutsana ndi chifukwa chakuti ntchitoyo imapeza deta yake powerenga nthawi ya kompyuta.
Maofesi a Excel amasunga tsikuli ngati nambala yomwe ikuimira nambala ya masiku onse kuyambira pakati pa usiku January 1, 1900 kuphatikizapo chiwerengero cha maola, mphindi ndi masekondi kwa tsiku lomwelo. Nambala iyi imatchedwa nambala yotsatira kapena tsiku lachidule.
Ntchito Zosasinthika
Popeza kuti nambala yowonjezera ikuwonjezeka ndi yachiwiri yodutsa, kulowa mu tsiku kapena nthawi yomwe ili ndi ntchito YOMWE imatanthawuza kuti ntchitoyo imasintha nthawi zonse.
Ntchito YOMWE ndi membala wa gulu la Excel la ntchito zosasinthasintha , zomwe zimagwiritsanso ntchito nthawi zonse pomwe ndondomeko yomwe amapezeka ikuwerenganso.
Mwachitsanzo, mapepala amatha kubwereza nthawi iliyonse yomwe atsegulidwa kapena pamene zochitika zina zimachitika-monga kulowa kapena kusintha deta pamsewu - choncho tsiku kapena nthawi imasintha pokhapokha kutsekedwa kwatsopano kumatsekedwa.
Kumakakamiza Ntchito Yopangirako / Buku Loyambiranso
Kukakamiza ntchitoyi kuti ikhale yosinthika nthawi iliyonse, dinani makiyi awa pa kibokosilo:
- Shift + F9 kuti ikonzenso pepala lothandizira kapena lamakono;
- F9 kukonzanso mabuku onse ogwirira ntchito .
Kusunga Nthawi ndi Nthawi Zimakhala Zolimba
Kukhala ndi nthawi ndi nthawi zosintha sizothandiza nthaŵi zonse, makamaka ngati zigwiritsidwa ntchito pazomwe zili tsiku kapena ngati mukufuna tsiku kapena nthawi yosindikiza pa tsamba.
Zosankha zolowera tsiku kapena nthawi zomwe sizikusintha zimaphatikizapo kutsekemera kumbuyo kokonzanso, kulemba masiku ndi nthawi pokha, kapena kulowa nawo pogwiritsa ntchito njira zotsatilazi:
- Njira yotsatila ndi Control + ; (semicolon)
- Njira yotsatsa nthawi ndi Control + Shift + : (colon)