Zvinokosha zvekushanda nemazuva uye nguva muExcel

Video

Semazuva ese, ndiani anoda kukurumidza - tarisa vhidhiyo. Details uye nuances - mune zvinyorwa pazasi:

Maitiro ekuisa misi uye nguva muExcel

Kana tikachengeta mupfungwa marongero edunhu, saka Excel inokutendera iwe kuti uise zuva nenzira dzakasiyana - uye unonzwisisa ese:

Kuonekwa (kuratidzwa) kwezuva muchitokisi kunogona kunge kwakasiyana kwazvo (ine kana pasina gore, mwedzi senhamba kana izwi, nezvimwewo) uye inoiswa kuburikidza nemenu yemamiriro - tinya-kurudyi pachitokisi uye ipapo. Sero format (Mafomati Masero):

Nguva inopindwa mumaseru uchishandisa makoroni. Semuyenzaniso

16:45

Kana uchida, iwe unogona kuwedzera kutsanangura nhamba yemasekonzi - kupinda iwo zvakare akaparadzaniswa nekoloni:

16:45:30

Uye, pakupedzisira, hapana anorambidza kutsanangura zuva nenguva kamwechete pamwechete kuburikidza nenzvimbo, kureva 

27.10.2012 16: 45

Kukurumidza kupinda kwemazuva uye nguva

Kuisa zuva ranhasi muchitokisi chazvino, unogona kushandisa nzira yekudimbudzira keyboard Ctrl + Ж (kana CTRL+SHIFT+4 kana uine mutauro wakasiyana wegadziriro yemutauro).

Kana iwe ukakopa sero rine date (dhonza kubva pazasi kurudyi kona yesero), uchibata rudyi bhatani rembeva, unogona kusarudza nzira yekukopa zuva rakasarudzwa:

Kana iwe kazhinji uchifanirwa kuisa mazuva akasiyana mumasero epepa, saka zviri nyore kuita izvi uchishandisa pop-up karenda:

Kana iwe uchida kuti sero rigare riine iro chairo zuva ranhasi, zviri nani kushandisa basa racho TODAY (NHASI):

Maitiro eExcel anochengetedza uye anogadzirisa misi nenguva

Kana ukasarudza sero rine zuva worigadzirira General format (kurudyi tinya pane cell Sero format – tab nhamba - General), unogona kuona mufananidzo unonakidza:

Kureva, kubva pakuona kweExcel, 27.10.2012/15/42 41209,65417:XNUMX pm = XNUMX

Muchokwadi, Excel inochengetedza uye inogadzirisa chero zuva rakafanana neiyi - senhamba ine nhamba uye chikamu chechikamu. Chikamu chizere chenhamba (41209) ndiyo nhamba yemazuva apfuura kubva muna Ndira 1, 1900 (akatorwa senge referenzi) kusvika zuva razvino. Uye chikamu chechikamu (0,65417), zvichiteerana, chikamu chezuva (zuva 1 = 1,0)

Kubva pane zvese izvi mhedziso mbiri dzinoshanda dzinotevera:

• Chekutanga, Excel haigone kushanda (pasina mamwe marongero) nemisi isati yasvika Ndira 1, 1900. Asi isu tichapona izvi! 😉
• Chechipiri, zvinokwanisika kuita chero masvomhu mashandiro ane misi uye nguva muExcel. Ndizvozvo nokuti idzo nhamba! Asi izvi zvinotovhura mikana yakawanda yemushandisi.

Nhamba yemazuva pakati pemazuva maviri

Inoonekwa sekubvisa kuri nyore - tinobvisa zuva rekutanga kubva pazuva rekupedzisira uye toshandura mhedzisiro kuti General (General) mafomati enhamba kuratidza musiyano mumazuva:

Nhamba yemazuva ebhizinesi pakati pemazuva maviri

Pano mamiriro acho akaoma zvishoma. Mugovera, Svondo uye mazororo hazvifanirwe kuverengerwa. Nokuda kwekuverenga kwakadaro, zviri nani kushandisa basa racho VABATI VACHENA (NETWORKDAYS) kubva muchikwata Zuva uye Nguva. Senharo dzebasa iri, iwe unofanirwa kutsanangura misi yekutanga nekupera uye maseru ane mazuva ekupera kwesvondo (zororo reveruzhinji, mazuva ekurwara, zororo, mazuva ekuzorora, nezvimwewo):

chitsamba: Iri basa rakaonekwa mune yakajairwa seti yeExcel mabasa kubvira vhezheni ya2007. Mune shanduro dzekare, unofanira kutanga wabatanidza add-on The analysis package. Kuti uite izvi, enda kumenyu Sevhisi - Mawedzero (Zvishandiso - Wedzera-Ins) uye tarisa bhokisi padyo ne Analysis package (Analisys Toolpak). Mushure meizvozvo, muFundo Wizard muchikamu Zuva uye Nguva basa ratinoda richaonekwa VABATI VACHENA (NETWORKDAYS).

Huwandu hwemakore akakwana, mwedzi, nemazuva pakati pemisi. Zera mumakore. Zvakaitika.

Nezve kuti ungaiverenga sei nenzira kwayo, zviri nani kuverenga pano.

Chinja zuva nenhamba yakatarwa yemazuva

Sezvo rimwe zuva muExcel date referensi system inotorwa seyuniti (ona pamusoro), kuverenga zuva iro, toti, mazuva makumi maviri kubva kune yakapihwa, zvakakwana kuwedzera iyi nhamba kune zuva.

Chinja zuva nenhamba yakatarwa yemazuva ekushanda

Kuvhiya uku kunoitwa nebasa ZUVA REBASA (ZUVA REBASA). Zvinokutendera kuti uverenge zuva riri kumberi kana rekudzokera kumashure kune rekutanga nenhamba yaunoda yemazuva ekushanda (uchifunga nezveMugovera neSvondo uye mazororo eruzhinji). Kushandisa basa iri kwakangofanana nekushandisa basa racho VABATI VACHENA (NETWORKDAYS) zvinotsanangurwa pamusoro.

Kuverenga zuva revhiki

Hauna kuzvarwa neMonday here? Kwete? Chokwadi? Inogona kuongororwa nyore nyore nebasa ZUVA (WEEKDAY)kubva muchikwata Zuva uye Nguva.

Nharo yekutanga yebasa iri isero rine zuva, yechipiri imhando yemazuva ekuverenga evhiki (yakanyanya kunaka ndeye 2).  

Kuverengera nguva dzenguva

Sezvo nguva muExcel, sezvataurwa pamusoro, iri nhamba imwechete sezuva, asi chikamu chayo chechikamu chete, saka chero masvomhu ese anogoneka nenguva, sekunge nemusi - kuwedzera, kubvisa, nezvimwe.

Pane nuance imwe chete pano. Kana, pakuwedzera nguva dzakati wandei, huwandu hwakazove hunopfuura maawa makumi maviri nemana, ipapo Excel inoimisazve uye wotanga kupfupisa zvakare kubva ku zero. Kuti udzivise izvi kuti zvirege kuitika, unofanirwa kuisa iyo fomati kune yekupedzisira sero 37:30:55:

• Maitiro ekuverenga zera (ruzivo) mumakore akazara-mwedzi-mazuva
• Maitiro ekuita yekudonha-pasi karenda kuti ikurumidze kuisa chero zuva mune chero sero.
• Wedzera otomatiki zuva razvino kusero paunenge uchipinda data.
• Maitiro ekuverenga zuva reSvondo yechipiri munaFebruary 2007, nezvimwe.