Nhamba yemazuva ari pakati pemazuva eExcel

Kuita mamwe mabasa muBudiki, iwe unofanirwa kuona kuti mazuva mangani apfuura pakati pemamwe mazuva. Neraki, chirongwa chine maturusi anokwanisa kugadzirisa nyaya iyi. Ngatitsvagei ndedzipi nzira dzaunogona kuwana mutsauko wemazuva muExcel.

Kuverenga kwehuwandu hwemazuva

Usati watanga kushanda nemazuva, iwe unofanirwa kumira masero pasi peichi chimiro. Muzviitiko zvakawanda, apo iyo seti yemavara ichiunzwa, sero racho rinogadziridzwa neiyo zuva. Asi zvichiri nani kuzviita pachikurudziro kumukurudzira kubva kune zvinoshamisa.

1. Sarudza nzvimbo yepepa pane iwe raunoronga kuita kuverenga. Rudyi-tinya pane kugoverwa. Mamambo menyu akaitwa. Mariri, sarudza chinhu "cell fomati ...". Nenzira imwe, unogona kufonera ctrl + 1 makiyi pane keyboard.



2. Iyo windo rinoratidzira rinovhura. Kana kuvhurwa kwakaitika kwete mu "nhamba" tab, zvino zvakafanira kuenda kwazviri. Mu "nhamba yemafungiro" paramita, isa change kune "zuva" chinzvimbo. Rutivi rworudyi rwehwindo, sarudza mhando yedata iri kuenda kubasa. Mushure meizvozvo, kusanganisa shanduko, tinya pane "ok" bhatani.

Iye zvino data rese rave riri mumasero akasarudzwa, chirongwa chacho chinoziva sezuva.

Nzira 1: Kureruka kuverenga

Nzira iri nyore yekuverenga musiyano uripo pakati pemazuva ari pakati pemazuva achishandisa mafomu akajairwa.

1. Isu tinonyora mumasero akapatsanurwa eiyo yakaumbwa zuva renji, musiyano uripo pakati pezvinoda kuverengerwa.



2. Isu tinosimbisa sero umo mhedzisiro icharatidzwa. Inofanira kunge iine chimiro chakajairika. Mamiriro ekupedzisira akakosha, nekuti kana iyo danho racho muchitokisi ichi, mhedzisiro yacho ichave ichionekwa Sero razvino kana renzara racho rinogona kutariswa nekuzviratidzira iyo muTab yeimba. Mu "nhamba" yeTOLOBOX ndiyo munda umo chiratidzo chinoratidzwa ichi.

   

   Kana zvakakodzera kukosha kunze kwekuti "zvakajairika", zvino mune ino nyaya, senguva yapfuura, uchishandisa mamiriro emenyu, tanga hwindo rekugadzira. Mazviri, mu "nhamba" tab, isu tinogadza mhando ye "General" fomati. Dzvanya pane "OK" bhatani.



3. Muchitokisi chakaumbwa pasi peiyo general fomati, isa chiratidzo "=". Dzvanya pane imwe sero, iyo inowanikwa gare gare kubva pamazuva maviri (yekupedzisira). Tevere, isu tinodzvanya pane yekhibhodi chiratidzo "-". Mushure meizvozvo, isu tinosimbisa sero, iro rine zuva rekutanga (rekutanga).



4. Kuti uone kuti ingani nguva yakapfuura pakati pemazuva aya, tinya pane bhatani rePeturu. Mhedzisiro yacho icharatidzwa muchitokisi, iyo inoumbwa nekuda kweiyo general fomati.

Nzira 2: Basa Revanhu

Kuti uverenge musiyano mumazuva, iwe unogona zvakare kuisa basa rakakosha rezvisikwa. Dambudziko nderekuti harina ruri mune rondedzero yemabasa, saka iwe unofanirwa kupinda iyo formula nemaoko. Yayo syntax inotaridzika seiyi:

= Ringats (yekutanga_date; Finite_date; unit)

"Unit" chimiro chacho icho chinofanira kuratidzwa muchitokisi chakaratidzwa. Kubva pane chinoratidzwa neichi muparamende iyi zvinoenderana, mune izvo zvikamu zvichadzoserwa:

• "Y" - yakazara makore;
• "M" - mwedzi yakazara;
• "D" - mazuva;
• "Ym" musiyano mumwedzi;
• "MD" - Musiyano mumazuva (mwedzi uye makore asina kukohwa);
• "YD" - Musiyano mumazuva (makore asina kuiswa muaccount).

Sezvo isu tichida kuverenga mutsauko mune huwandu hwemazuva pakati pemazuva, mhinduro yakanyanya kunaka ichave kushandiswa kwekupedzisira sarudzo.

Izvo zvinodikanwa kuti utarise kune izvo, kusiyana nenzira uchishandisa iyo nzira yakapusa inotsanangurwa pamusoro apa, paunenge uchishandisa chinhu ichi, zuva rekutanga rinofanira kunge riri munzvimbo yekutanga, uye iyo yekupedzisira inofanira kunge iri yechipiri. Zvikasadaro, kuwerengera kuchave kusiri iko.

1. Isu tinonyora formula muchitokisi chakasarudzwa, maererano neyakagadzirwa syntax yakatsanangurwa pamusoro, uye data rekutanga muchimiro chenguva yekutanga uye yekupedzisira.



2. Kuitira kuti uverenge kuverenga, tinya bhatani rePeturu. Mushure meizvozvo, mhedzisiro, muchimiro chakati wandei kuratidza huwandu hwemazuva pakati pemazuva, zvicharatidzwa muchitokisi chakataurwa.

Nzira 3: Kuverenga kwehuwandu hwemazuva ekushanda

Iko kutapwa zvakare kune mukana wekuverenga mazuva ekushanda pakati pemazuva maviri, ndiko kuti, kunze kwekupera kwevhiki nemitambo. Kuti uite izvi, shandisa iyo custube basa. Mukupesana neyekutanga oparidza, iripo mune rondedzero yemabasa wizard. Iyo syntax yeiyi ficha iri seinotevera:

= Chistarabdni (nach_data; kon_data; [zororo])

Muchinhu ichi, nharo huru, yakafanana neyekunyaradza oparesheni - iyo yekutanga uye yekupedzisira zuva. Uye zvakare, pane sarudzo yekusarudzika "mazororo".

Panzvimbo iyoyo, inodikanwa kutsiva mazuva emazuva ekupembera asingashande, kana paine chero nguva yakafukidzwa. Basa rinoita kuti riitike kuverenga mazuva ese eiyo yakatarwa renji, kusasanganisa Mugovera, Svondo, pamwe nemazuva iwayo anowedzerwa nemushandisi ari muhukasha ".

1. Isu tinosimbisa sero umo mhedzisiro yekuverenga ichave. Dzvanya pane "paste basa" bhatani.



2. Wizard inovhura. Muboka "yakazara alfabhethi rondedzero" kana "zuva uye nguva" isu tiri kutsvaga chinhu che "Chistorbdni". Isu tinoratidza uye tinya "OK" bhatani.



3. Nhaurwa dzebasa dzinovhura. Isu tinopinda pakutanga uye kupera kwenguva iri muminda yakakodzera, pamwe nemazuva emazuva ezororo, kana paine. Dzvanya pane "OK" bhatani.

Mushure mekunyengera kuri pamusoro muchitokisi chaangosarudzwa, huwandu hwemazuva ekushanda kwenguva yakatarwa icharatidzwa.

Chidzidzo: Wizard mabasa muExcel

Sezvauri kuona, chirongwa cheEkunyura chinopa mushandisi wayo nechishandiso chakanakira chekuverenga huwandu hwemazuva pakati pemazuva maviri. Panguva imwecheteyo, kana iwe uchingoda kuverenga mutsauko mumazuva, kushandiswa kwemazuva ari nyore fomula kuchave kwakakwana sarudzo, uye kwete kushandiswa kwebasa rekugadzirisa. Asi kana zvichidikanwa, semuenzaniso, kuverenga huwandu hwemazuva ekushanda, saka basa reChistorbdni richauya kuzonunura. Ndokunge, senguva dzose, mushandisi anofanira kuona chishandiso chekuuraya mushure mekunge aisa rimwe basa.