Musi uno. Sei kuitika zuva uye nguva Excel

Excel iri repamutemo "Microsoft" ari processor simba, iyo hwezvekukurukurirana akawanda vanoshandisa zuva basa pamwe yakawanda tabular mashoko. Zvisinei, kunyange ruzivo nyanzvi, makore akawanda achishanda chirongwa ichi, dzimwe nguva akarasika yatinoona dzinoisa kupinda pepa muchitokisi ano zuva uye nguva. Izvi kunyanya nokuti kuti mashandiro "Date", kuti zvaizova nomusoro kushandisa kuwana kutsvakwa tsika, anoita zvakasiyana zvachose basa. Munyaya ino, tichakurukura kukuudza pamusoro mhando dzakasiyana-siyana dzokunyora misi vakajaira Excel, kuti pezvakaitwa gadziriro uye chikumbiro chavo zvimwe.

marudzi mazuva

Excel ari kufunga maviri zvokusarudza "Date ano". Wokutanga wavo - iri ngadzirambe kukosha kuitika zuva uye nguva, zvakachengetwa pamusoro rokushandisa pachake kombiyuta. Kamwe apinda pepa, mutengo hakuzochinji zvisinei nokuchinja panguva chaiyo uye musi. Kana ungada nezvechisarudzo ichi? Mhinduro zhinji, somuenzaniso, kana muchitoro musi kugashira mushandi kushanda kana kudzingwa, kupinda musi okutambirwa nhumbi kusvika yokuchengetera zvinhu. tsika izvi zvinofanira kuva kunofambira mberi, nokuti handishanduki nokufamba kwenguva.

The shanduro chechipiri "Date magetsi" - a simba, unochinja, updateable. Kushandiswa kupfuura zvinowanzovapo nezvechisarudzo ichi - musi uye nguva ukoshi pakona pepa, sechikamu akanyorwa "Nhasi, May 14, 2017". musiyano uyu zvinowanzodavirwa kushandiswa mune zvokuimba Somuenzaniso kuverenga sei mazuva mazhinji apfuura kubva imwe nhamba. Vashandi vanogona kudzidza kufamba ipapo kuguma probationary nguva mushandi, uye mushandi wemari cheki, kwete pamusoro kana expiry musi muna consignment.

Chokwadi, simba zuva uye nguva Excel inobatsira chaizvo, asi pane chinokosha zvikuru chinhu: kuramba updating kuti mashoko tsika zvikasaitika. The akapinda ukoshi zvichachinja panguva kuvhurazve yebhuku, kana makro dzemaitirwe pakati equations siyana. Kana iwe chete musiye bhuku yakazaruka, uye hapana apa zviito haadi, zuva uye nguva vacharamba vari tsika kuti wakapinda kamwe. Asi zvinokosha kuzodzosera kuzarura bhuku kana kuti recalculate kuti nzira, tsika zvichaparadzwa yoku-.

Funga kuti iri Excel kuti pinza izvi mhando mbiri yemichindwe.

Date wakaiswa, regai dzifambirane

Excel ukoshi "Musi ano" inogona kuwanikwa nyore mabhatani Ctrl kiyi, uye ";". Just kumira aida muchitokisi iri pepa uye pakarepo abate pasi Ctrl kiyi achizviendesa semicolon. Sero achava musi kuitika mune pfupi format, somuenzaniso 5/14/2017.

Kuti vemabhuku nguva, kuita yakafanana kushanda nokuomerera pasi Ctrl kiyi, baya uye mubatirire pasi Shift kiyi uye chete achizviendesa semicolon. All. Dzinoisa kuitika nguva pamanyorerwo "hh: mm".

Kuti tirambe muchitokisi pakarepo uye musi uye nguva yakakwana pashure kuisa zuva achizviendesa spacebar kuti vemabhuku nguva, uchishandisa yakati yokudimbudzira kiyi.

Sezvatinogona kuona, kuti dzinoisa kuitika musi yakatarwa pamanyorerwo muna Excel zviri nyore. The chete kuzvuzvungudza ndechokuti zvakakodzera pamusoro keyboards dzakawanda pasina mamwe makiyi, chinja kusvika Chirungu kiibhodhi marongerwo.

Date dynamically weekly

Current musi muchimiro ane updatable rinorondedzerwa Excel vachishandisa Masvomhu. Option maviri:

• The payakavakirwa "= TODAY ()" kunoita kuti vawane kuitika zuva.
• The payakavakirwa "= NOW ()" kunoita kuti vawane kuitika zuva uye nguva.

Mabasa Ava havana kupopotedzana uye tsika vakawana kushandisa vavo yoku- nguva imwe neimwe kunobva / kopi / kudhonza pakati Masvomhu kana apiwa hwomukova jira.