Maitiro ekuona zuva revhiki kubva pazuva muExcel

Kazhinji, vashandisi veExcel spreadsheet vanofanirwa kuita chiito senge kuratidza zita rezuva revhiki rinoenderana neimwe sero. Excel ine huwandu hwakawanda hwemabasa ayo anobvumidza iwe kuita iyi maitiro. Muchinyorwa ichi, isu tichatarisa zvakadzama nzira dzinoverengeka dzekunyatsoratidza zuva revhiki nemazuva.

Kuratidza zuva revhiki uchishandisa sero fomati

Chinhu chikuru cheiyi nzira ndechekuti panguva yekushandiswa chete kuburitsa kwekupedzisira kucharatidzwa zvichiratidza zuva revhiki. Zuva racho pacharo harizoratidzwa, nemamwe mazwi, zuva riri mumunda richatora zuva raunoda revhiki. Zuva richaonekwa mumutsara weformula yakatarwa kana sero rasarudzwa. Kufamba

1. Semuenzaniso, tine tablet cell inoratidza zuva chairo.

2. Kurudyi tinya pane iyi cell. Menyu diki yemukati yakaratidzwa pachiratidziri. Isu tinowana chinhu chinodaidzwa kuti "Format Cells ..." uye tinya pachiri nebhatani rekuruboshwe.

3. Takazopinda mufafitera rakanzi "Format Cells". Tinoenda kuchikamu che "Nhamba". Mune diki runyorwa "Nhamba mafomati" sarudza chinhu "(ese mafomati)". Isu tinotarisa kunyorwa "Type:". Dzvanya bhatani rekuruboshwe rembeva pane yekupinda ndima iri pazasi ichi chinyorwa. Isu tinotyaira pano kukosha kunotevera: "DDDD". Mushure mekuita zvese manipulations, tinya pakanzi "OK".

4. Ready! Nekuda kweizvozvo, takazviita kuti zuva musero retafura rive zita revhiki. Sarudza sero iri nekudzvanya bhatani rekuruboshwe uye tarisa mutsetse wekupinda mafomula. Zuva rekutanga pacharo rinoratidzwa pano.

Zvinokosha! Iwe unogona kushandura kukosha kwe "DDDD" ku "DDDD". Nekuda kweizvozvo, zuva richaratidzwa muchitokisi mune yakapfupikiswa fomu. Kutarisa kunogona kuitwa muhwindo rekugadzirisa mumutsara unonzi "Sample".

Kushandisa TEKSTO basa kuona zuva revhiki

Nzira iri pamusoro inotsiva zuva musero yetafura yakasarudzwa nezita rezuva revhiki. Iyi nzira haina kukodzera kumarudzi ese emabasa akagadziriswa muExcel spreadsheet. Kazhinji vashandisi vanofanirwa kuita kuti zuva revhiki uye zuva rioneke mumaseru akasiyana. Mushandi akakosha anonzi TEXT anobvumidza iwe kuita iyi nzira. Ngatitarisei nyaya yacho zvakadzama. Kufamba

1. Somuenzaniso, muhwendefa redu pane zuva chairo. Pakutanga, tinosarudza sero yatinoda kuratidza zita rezuva revhiki. Isu tinoshandisa kusarudzwa kwesero nekudzvanya bhatani rekuruboshwe. Isu tinodzvanya bhatani re "Insert Function" riri padivi pemutsara wekupinda mafomula.

2. Hwindo diki rainzi "Insert Function" rairatidzwa pachiratidziri. Wedzera rondedzero padivi pechinyorwa "Chikamu:". Muchinyorwa chekudonhedza, sarudza chinhu che "Text".

3. Muhwindo "Sarudza basa:" tinowana mushandisi "TEXT" uye tinya pairi nebhatani rekuruboshwe. Mushure mekuita zvese manipulations, tinya bhatani rekuti "OK" riri pazasi pehwindo.

4. Hwindo rinoonekwa pachiratidziro chaunofanira kuisa nharo dzemushandisi. Maonero ese emushandisi: =TEXT(Kukosha;Output Format). Pane nharo mbiri dzekuzadza pano. Mumutsara we "Value" unofanirwa kuisa zuva, zuva revhiki ratinoronga kuratidza. Iwe unogona kuita iyi nzira iwe pachako nekuipinda nemaoko kana nekutaura kero yesero. Dzvanya pamutsara weiyo seti yezvinokosha, wobva wadzvanya LMB pane sero rinodiwa rine zuva. Mumutsara we "Format" tinotyaira mumhando inodiwa yekubuda kwezuva revhiki. Yeuka kuti "DDDD" ndiyo kuratidzwa kuzere kwezita, uye "DDD" ipfupi. Mushure mekuita zvese manipulations, tinya bhatani rekuti "OK" riri pazasi pehwindo.

5. Pakupedzisira, sero ine fomula yakapinda icharatidza zuva revhiki, uye zuva rekutanga richaramba riri rekutanga.

6. Zvakakosha kucherechedza kuti kugadzirisa zuva kunongochinja zuva revhiki muchitokisi. Ichi chimiro chakanyanya kushandiswa.

Uchishandisa WEEKDAY basa kuona zuva revhiki

Basa re WEEKDAY nderimwe rinokosha rekuita basa iri. Ziva kuti kushandiswa kwemushandisi uyu kunoreva kuratidzwa kwete zita rezuva revhiki, asi nhamba yeserial. Uyezve, semuenzaniso, Chipiri haifanire kunge iri nhamba 2, sezvo kurongeka kwenhamba kwakaiswa nemushandisi wespredishiti pachake. Kufamba

1. Semuenzaniso, tine sero rine zuva rakanyorwa. Isu tinodzvanya pane chero imwe sero yatinoronga kuratidza mhedzisiro yeshanduko. Isu tinodzvanya bhatani re "Insert Function" riri padivi pemutsara wekupinda mafomula.

2. Idiki "Insert Function" hwindo rakaratidzwa pachiratidziri. Wedzera rondedzero padivi pechinyorwa "Chikamu:". Mariri, tinya pane "Date uye Nguva" chinhu. Mu "Sarudza basa:" hwindo, tsvaga "WEEK ZUVA" uye tinya pairi neLMB. Mushure mekuita zvese manipulations, tinya bhatani rekuti "OK" riri pazasi pehwindo.

3. Hwindo rinoonekwa pachiratidziro chaunofanirwa kuisa kukosha kweanoshanda. Maonero ese emushandisi: =ZUVAWEEK(zuva, [rudzi]). Pane nharo mbiri dzekuzadza pano. Mumutsara we "Date" isa zuva rinodiwa kana kutyaira mukero yemunda. Mumutsara we "Type" tinopinda zuva iro kurongeka kunotanga. Pane matatu maitiro eiyi nharo yekusarudza kubva. Kukosha "1" - kurongeka kunotanga kubva Svondo. Kukosha "2" - zuva rekutanga richava Muvhuro. Kukosha "1" - zuva rekutanga richava zvakare Muvhuro, asi nhamba yaro ichava yakaenzana ne zero. Isa kukosha "3" mumutsetse. Mushure mekuita zvese manipulations, tinya pakanzi "OK".

Teerera! Kana mushandisi akasazadza mutsara uyu nechero ruzivo, ipapo "Type" inongotora kukosha "1".

4. Musero iri nemushandisi, chigumisiro chakaratidzwa munhamba yenhamba, iyo inoenderana nezuva revhiki. Mumuenzaniso wedu, ichi ndicho Chishanu, saka zuva rino rakapiwa nhamba "5".

5. Zvakakosha kucherechedza kuti kugadzirisa zuva kunongochinja zuva revhiki muchitokisi.

Mhedziso uye mhedziso nezve nzira dzakatariswa

Takatarisa nzira nhatu dzekutaridza zuva revhiki nemusi muspredishiti. Imwe neimwe yenzira yacho iri nyore kushandisa uye haidi chero humwe hunyanzvi. Yechipiri inotariswa nzira ndiyo yakapfava, sezvo ichishandisa data inobuda mune imwe sero isina kushandura ruzivo rwekutanga neimwe nzira.