Okuyisisekelo kokusebenza ngezinsuku nezikhathi ku-Excel

Ividiyo

Njengokujwayelekile, ngubani odinga ukushesha - bukela ividiyo. Imininingwane nama-nuances - embhalweni ongezansi:

Ungawafaka kanjani amadethi nezikhathi ku-Excel

If we keep in mind the regional settings, then Excel allows you to enter the date in very different ways – and understands them all:

Ukubonakala (ukubonisa) kosuku kuseli kungahluka kakhulu (nonyaka noma ngaphandle kwawo, inyanga njengenombolo noma igama, njll.) futhi kusethwa kumenyu yokuqukethwe – chofoza kwesokudla kuseli bese Ifomethi yeseli (Fometha Amaseli):

Isikhathi sifakwa kumaseli kusetshenziswa amakholoni. Ngokwesibonelo

16:45

Uma uthanda, ungaphinda ucacise inani lamasekhondi - ukuwafaka futhi ahlukaniswe ikholoni:

16:45:30

Futhi, ekugcineni, akekho onqabela ukucacisa usuku nesikhathi ngesikhathi esisodwa ndawonye ngesikhala, okungukuthi 

27.10.2012 16: 45

Ukungena okusheshayo kwamadethi nezikhathi

Ukuze ufake idethi yanamuhla kuseli yamanje, ungasebenzisa isinqamuleli sekhibhodi Ctrl + Ж (noma CTRL+SHIFT+4 uma unolimi oluhlukile lwesistimu).

Uma ukopisha iseli enosuku (hudula ekhoneni elingezansi kwesokudla seseli), ubambe kwesokudla inkinobho yegundane, ungakhetha indlela yokukopisha idethi ekhethiwe:

Uma ngokuvamile kufanele ufake izinsuku ezihlukene kumaseli weshidi, kulula kakhulu ukwenza lokhu usebenzisa ikhalenda le-pop-up:

Uma ufuna iseli ukuthi lihlale liqukethe idethi yangempela yanamuhla, kungcono ukusebenzisa umsebenzi NAMUHLA (NAMUHLA):

I-Excel igcina kanjani futhi isebenza kanjani izinsuku nezikhathi

Uma ukhetha iseli elinedethi bese ulibekela lona Ifomethi evamile (chofoza kwesokudla kuseli Ifomethi yeseli – ithebhu Inombolo - General), ungabona isithombe esithokozisayo:

Okusho ukuthi, ngokombono we-Excel, 27.10.2012/15/42 41209,65417:XNUMX pm = XNUMX

Eqinisweni, i-Excel igcina futhi icubungule noma iyiphi idethi efana ncamashi nalena - njengenombolo enenombolo ephelele kanye nengxenye eyingxenye. Ingxenye ephelele yenombolo (41209) iyinani lezinsuku ezidlulile kusukela ngoJanuwari 1, 1900 (ethathwe njengendawo eyireferensi) kuze kube yidethi yamanje. Futhi ingxenye eyingxenye (0,65417), ngokulandelana, isabelo sosuku (usuku olungu-1 = 1,0)

Kuwo wonke la maqiniso kulandela iziphetho ezimbili ezisebenzayo:

• Okokuqala, i-Excel ayikwazi ukusebenza (ngaphandle kwezilungiselelo ezengeziwe) ngezinsuku ezingaphambi kukaJanuwari 1, 1900. Kodwa sizosinda kulokhu! 😉
• Okwesibili, kungenzeka ukwenza noma yimiphi imisebenzi yezibalo ngezinsuku nezikhathi ku-Excel. Impela ngoba ziyizinombolo empeleni! Kodwa lokhu sekuvele kuvulele amathuba amaningi kumsebenzisi.

Inani lezinsuku phakathi kwamadethi amabili

Kuthathwa njengokususa okulula - sikhipha idethi yokuqala kusukela osukwini lokugcina bese sihumushela umphumela General (Okujwayelekile) ifomethi yenombolo ukukhombisa umehluko ngezinsuku:

Inombolo yezinsuku zebhizinisi phakathi kwamadethi amabili

Lapha isimo sinzima kakhulu. IMigqibelo, amaSonto namaholide akumele kubhekwe. Ukubala okunjalo, kungcono ukusebenzisa umsebenzi ABASEBENZI ABAHLANZEKILE (NETWORKDAYS) kusukela esigabeni Idethi nesikhathi. Njengama-agumenti kulo msebenzi, kufanele ucacise amadethi okuqala nawokugcina namaseli anedethi yempelasonto (amaholide omphakathi, izinsuku zokugula, amaholide, izinsuku zokuphumula, njll.):

Note: Lo msebenzi uvele kusethi ejwayelekile yemisebenzi ye-Excel kusukela kunguqulo ka-2007. Ezinguqulweni ezindala, kufanele uqale uxhume isengezo Iphakheji yokuhlaziya. Ukuze wenze lokhu, yiya kumenyu Isevisi - Izengezo (Amathuluzi — Izengezo) bese uhlola ibhokisi eliseduze Iphakheji yokuhlaziya (I-Analisys Toolpak). Ngemva kwalokho, ku-Function Wizard esigabeni Idethi nesikhathi umsebenzi esiwudingayo uzovela ABASEBENZI ABAHLANZEKILE (NETWORKDAYS).

Inani leminyaka ephelele, izinyanga, nezinsuku phakathi kwamadethi. Iminyaka ngeminyaka. Isipiliyoni.

Mayelana nendlela yokubala kahle, kungcono ukufunda lapha.

Shintsha idethi ngenani elishiwo lezinsuku

Njengoba usuku olulodwa ohlelweni lwereferensi yedethi ye-Excel luthathwa njengeyunithi (bheka ngenhla), ukubala usuku okusho ukuthi, izinsuku ezingama-20 ukusuka konikeziwe, kwanele ukwengeza le nombolo osukwini.

Shintsha idethi ngenani elithile lezinsuku zebhizinisi

Lo msebenzi wenziwa umsebenzi USUKU LOMSEBENZI (USUKU LOMSEBENZI). Ikuvumela ukubala idethi eya phambili noma eya emuva ngokuhlobene nedethi yokuqala ngenombolo oyifunayo yezinsuku zokusebenza (kucatshangelwa iMigqibelo namaSonto namaholide omphakathi). Ukusebenzisa lo msebenzi kufana ncamashi nokusebenzisa umsebenzi ABASEBENZI ABAHLANZEKILE (NETWORKDAYS) kuchazwe ngenhla.

Ibala usuku lwesonto

Awuzalwanga ngoMsombuluko? Hhayi? Uqinisekile? Ingahlolwa kalula ngomsebenzi DAY (USUKU LWEVIKI)kusukela esigabeni Idethi nesikhathi.

Ingxabano yokuqala yalo msebenzi iyiseli enedethi, eyesibili uhlobo lwezinsuku zokubala zesonto (okulula kakhulu u-2).  

Ukubalwa kwezikhawu zesikhathi

Njengoba isikhathi ku-Excel, njengoba kushiwo ngenhla, iyinombolo efanayo nosuku, kodwa ingxenye yayo eyingxenye kuphela, khona-ke noma yikuphi ukusebenza kwezibalo kungenzeka futhi ngesikhathi, njengosuku - ukuhlanganisa, ukususa, njll.

Kune-nuance eyodwa kuphela lapha. Uma, lapho wengeza izikhawu zesikhathi ezimbalwa, isamba sivele saba ngaphezu kwamahora angama-24, i-Excel izosetha kabusha futhi iqale ukufingqa futhi isuka kuziro. Ukuvimbela lokhu ukuthi kungenzeki, udinga ukusebenzisa ifomethi kuseli lokugcina 37:30:55:

• Ungabala kanjani ubudala (isipiliyoni) eminyakeni egcwele-izinyanga-izinsuku
• Ulenza kanjani ikhalenda lokudonsela phansi ukuze ufake ngokushesha noma iyiphi idethi kunoma iyiphi iseli.
• Engeza ngokuzenzakalelayo idethi yamanje kuseli lapho ufaka idatha.
• Ungabala kanjani usuku lweSonto lesibili ngoFebhuwari 2007, njll.