Indlela yokugqekeza amabhodi wamabhodi

Uma usebenza ku-Excel, umsebenzi uhlelwe ngezinye izikhathi ukuze emva kokufaka usuku oluthile esitokisini, usuku lweviki luboniswa, oluhambisana nalo. Ngokwemvelo, ukuxazulula le nkinga ngokusebenzisa inqubo enamandla ye-tabular njenge-Excel, mhlawumbe, futhi ngezindlela eziningana. Ake sibone ukuthi yiziphi izinketho ezikhona zokwenza lo msebenzi.

Bonisa usuku lwesonto ku-Excel

Kunezindlela eziningana zokubonisa usuku lwesonto ngokusho kokufakwayo, kusukela ekufomeni amangqamuzana nokuphela kokusetshenziswa kwemisebenzi. Ake sibheke zonke izinketho ezikhona zokwenza lolu hlelo ku-Excel, ukuze umsebenzisi angakhetha okuhle kunazo zonke ngesimo esithile.

Indlela 1: Faka isicelo sokufometha

Okokuqala, ake sibone ukuthi ukusebenzisa ukufometha kweseli ungabonisa kanjani usuku lwesonto ngedethi efakiwe. Lolu khetho luhilela ukuguqula usuku ngenani elibekiwe, futhi ungalondolozi ukuboniswa kokubili kwalezi zinhlobo zedatha kushidi.

1. Faka noma yiluphi usuku oluqukethe usuku, inyanga nonyaka esitokeni kushidi.



2. Chofoza kuseli nge inkinobho yesokudla yegundane. Iqala imenyu yokuqukethwe. Khetha isikhundla kuso "Fometha amaseli ...".



3. Ifasitela lokufometha iqala. Hambisa kuthebhu "Inombolo"uma ivuliwe kwelinye ithebhu. Okuqhubekayo ku-parameter block "Amafomu Amanani" setha inkinobho ukuma "Zonke amafomethi". Ensimini "Thayipha" ngesandla faka lokhu okulandelayo:

   DDDD

   Emva kwalokho chofoza inkinobho "Kulungile" phansi kwefasitela.



4. Njengoba ungabona, esitokisini, esikhundleni sosuku, igama eligcwele losuku lwesonto luboniswa kuso. Kulesi simo, ukhethe le seli, kubha yefomula, usabona usuku lokubonisa.

Ensimini "Thayipha" amafomethi wefomethi esikhundleni senani "DDDD" Ungafaka futhi inkulumo:

DDD

Kulesi simo, ishidi lizobonisa igama elifingqiwe losuku lwesonto.

Isifundo: Ungashintsha kanjani ifomethi yeseli ku-Excel

Indlela 2: sebenzisa umsebenzi we-TEXT

Kodwa indlela ebekwe ngenhla ihilela ukuguqula usuku kuze kube usuku lwesonto. Ingabe kukhona okukhethwa kukho kokubili kulawa maxabiso okumele kuboniswe kushidi? Okusho ukuthi, uma singena idethi esitokisini esisodwa, usuku lwesonto kufanele luboniswe kwenye. Yebo, le nketho ikhona. Kungenziwa ngokusebenzisa ifomula Umbhalo. Kulesi simo, inani esiyidingayo lizoboniswa esitokisini esicacisiwe kwifomethi yombhalo.

1. Bhala usuku kunoma yiluphi uhlamvu lweshidi. Bese ukhetha noma iyiphi iseli elingenalutho. Chofoza kusithonjana "Faka umsebenzi"okuyinto eseduze ne-bar yefomula.



2. Ifasitela iqala. Amakhosi omsebenzi. Iya kusigaba "Umbhalo" futhi ohlwini lwabo opharetha bakhetha igama "TEXT".



3. Iwindi lempikiswano yokusebenza ivula. Umbhalo. Lo opharetha yakhelwe ukubonisa inombolo ecacisiwe kunguqulo ekhethiwe yesakhiwo sombhalo. Iqukethe i-syntax elandelayo:

   = TEXT (Inani; Ifomethi)

   Ensimini "Value" sidinga ukucacisa ikheli leseli eliqukethe usuku. Ukuze wenze lokhu, setha isikhombisi kunsimu ecacisiwe nokuchofoza ngakwesokunxele kule seli kushidi. Ikheli liboniswa ngokushesha.

   Ensimini "Fometha" kuye ngokuthi yini esifuna ukuba nomqondo wosuku lwesonto, eligcwele noma elifingqiwe, faka inkulumo dddd noma ddd ngaphandle izingcaphuno.

   Ngemva kokufaka le datha, chofoza inkinobho "Kulungile".



4. Njengoba ungabona esitokisini esiyikhethile ekuqaleni, usuku lwesonto lokuqokwa liboniswa kwifomethi ekhethiwe yombhalo. Manje sineketshi kokubili usuku nosuku lwesonto luboniswa ngesikhathi esisodwa.

Ngaphezu kwalokho, uma inani losuku lishintshwa esitokisini, usuku lwesonto luzoshintsha ngokuzenzakalelayo ngokufanele. Ngakho, ukushintsha usuku ongathola ngalo ngalolo suku lwesonto luzowa.

Isifundo: I-Excel umsebenzi wizard

Indlela 3: sebenzisa umsebenzi we-DENNED

Kukhona omunye opharetha ongabonisa usuku lwesonto ngosuku olunikeziwe. Lona umsebenzi DAY. Iqiniso, alibonisi igama losuku lwesonto, kodwa inombolo yalo. Kulesi simo, umsebenzisi angasetha kusuka kusiphi usuku (kusukela ngeSonto noma kusukela ngoMsombuluko) inani lokubala lizobalwa.

1. Khetha iseli ukubonisa inombolo yosuku lwesonto. Chofoza kusithonjana "Faka umsebenzi".



2. Ifasitela ivula futhi. Amakhosi omsebenzi. Lesi sikhathi siya kusigaba "Usuku Nesikhathi". Khetha igama "BENZWE" bese uchofoza inkinobho "Kulungile".



3. Iya ewindini lempikiswano ye-opharetha. DAY. Iqukethe i-syntax elandelayo:

   = DENNED (usuku_nombuzo_nombolo_yomfanekiso; [uhlobo]

   Ensimini "Usuku ngefomethi yenombolo" sifaka usuku oluthile noma ikheli leseli kushidi lapho liqukethwe khona.

   Ensimini "Thayipha" setha inombolo kusuka 1 kuze kube 3okuyinto enquma ukuthi izinsuku zesonto zizobalwa kanjani. Uma uhlela inombolo "1" ukubalwa kuzokwenzeka kusukela ngeSonto, futhi lolu suku lwesonto luzokwaziswa ngenombolo yokulandelana "1". Lapho usetha inani "2" Ukubalwa kwenombolo kuzokwenziwa kusukela ngoMsombuluko. Lolu suku lwesonto luzonikwa inombolo ye-serial. "1". Lapho usetha inani "3" ukubalwa kwezinombolo kuzophinde kwenzeke ngoMsombuluko, kodwa kulokhu uMsombuluko uzokwaziswa ngenombolo yokulandelana "0".

   Ukuphikisana "Thayipha" akudingeki. Kodwa, uma uyishiya, kubhekwa ukuthi inani lempikiswano lilingana "1"okungukuthi, isonto liqala ngelanga. Ngakho yamukelwa emazweni akhuluma isiNgisi, kodwa lokhu kukhetho akuhambisani nathi. Ngakho-ke, ensimini "Thayipha" setha inani "2".

   Ngemva kokwenza lezi zenzo, chofoza inkinobho "Kulungile".



4. Njengoba ubona, esitokisini esicacisiwe sibonisa inombolo yokulandelana yosuku lwesonto, elihambisana nosuku olungenisiwe. Esimweni sethu, le nombolo "3"okusho ngoLwesithathu.

Njengomsebenzi wangaphambilini, uma ushintsha usuku, inombolo yosuku lwesonto esitokisini lapho opharetha efakwe khona ngokuzenzakalelayo.

Isifundo: Imisebenzi yosuku nosuku ku-Excel

Njengoba ubona, ku-Excel kunezinketho ezintathu eziyinhloko zokwethula usuku njengosuku lwesonto. Zonke zazo zilula futhi azidingi amakhono athile avela kumsebenzisi. Omunye wabo ukusebenzisa amafomethi akhethekile, nezinye izinto ezimbili ezisebenzisayo ezakhelwe ngaphakathi ukufeza lezi zinhloso. Njengoba kunikezwe ukuthi indlela nendlela yokubonisa idatha kuzo zonke izimo ezichazwe ngayo ihluke kakhulu, umsebenzisi kufanele akhethe ukuthi iyiphi yalezi zinketho esimweni esithile esifanelekile kuye.