01 ka 01
Umsebenzi WOMSEBENZI
Thola Usuku Lwephrojekthi noma Usuku Lokuphela ku-Excel
I-Excel ineziningana ezimbalwa ezakhiwe emisebenzini yamanje ezingasetshenziselwa ukubalwa kwosuku lomsebenzi.
Umsebenzi wamalanga ngamunye wenza umsebenzi ohlukile ukuze imiphumela ihluke kusuka komunye umsebenzi kuya olandelayo. Yiyiphi oyisebenzisayo, ngakho-ke, incike kwimiphumela oyifunayo.
Umsebenzi we-Excel WORKDAY
Endabeni yomsebenzi we-WORKDAY, ithola usuku lokuqala noma lokuphela kweprojekthi noma isabelo esinikezwe inombolo ehleliwe yosuku lokusebenza.
Inani lezinsuku zokusebenza alithinte ngokuzenzakalelayo ngezimpelasonto nanoma yimiphi izinsuku ezikhonjiswe njengeholide.
Ukusetshenziswa komsebenzi we-WORKDAY kubandakanya ukubala:
- usuku lokuphela kwephrojekthi enezinombolo zokusebenza izinsuku ezilandelayo ngosuku oluthile olunikeziwe
- usuku lokuqala lwephrojekthi enezinombolo zomsebenzi wezinsuku zokusebenza ngaphambi kosuku lokuphela olunikeziwe
- usuku olufanele lwe-invoyisi
- usuku lokulethwa kulindeleke lwezimpahla noma izinto
I-Syntax neMisebenzi yokusebenza yomsebenzi
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .
I-syntax yomsebenzi we-WORKDAY yile:
= WORKDAY (Qala_ukuqala, izinsuku, amaholide)
Qala_kudinga - (okudingekayo) usuku lokuqala kwesikhathi esikhethiwe. Usuku lokuqala langempela lungangena kule ngxabano noma ukubhekisela kweseli endaweni yalomdatha ekhasini lokusebenzela kungangena esikhundleni.
Izinsuku - (ezidingekayo) ubude bephrojekthi. Lena yinani elikhombisa inani lezinsuku zomsebenzi ezenziwa kule phrojekthi. Kule mpikiswano, faka inani lezinsuku zomsebenzi noma ireferensi yeseli endaweni yile datha kushidi lokusebenzela.
Qaphela: Ukuze uthole usuku olwenzeka ngemuva kokungqubuzana kwe- Start_date sebenzisa inombolo enhle yezinsuku . Ukuze uthole usuku olwenzeka ngaphambi kokuthi i-argument ye- Start_date isebenzise inani elibi lezinsuku . Kulesi simo sesibili i- Start_date ingxabano ingabonwa njengosuku lokuphela kwephrojekthi.
Amaholide - (okukhethwa kukho) izinsuku ezilodwa noma ngaphezulu ezingeziwe njengengxenye yenani lezinsuku zokusebenza zokusebenza. Sebenzisa izikhombisi zeseli endaweni yedatha kushidi lokusebenzela le ngxabano.
Isibonelo: Thola Usuku Lokuphela Lwephrojekthi
Njengoba kuboniswe esithombeni ngenhla, lesi sibonelo sizosebenzisa umsebenzi we-WORKDAY ukuthola usuku lokuphela kwephrojekthi eqala ngo-Julayi 9, 2012 futhi iqede izinsuku ezingu-82 kamuva. Amaholide amabili (September 3 no-Okthoba 8) okwenzeka phakathi nalesi sikhathi ngeke kubalwe njengengxenye yezinsuku ezingu-82.
Qaphela: Ukugwema izinkinga zokubala ezingahle zenzeke uma izinsuku zingena ngengozi njengoba umbhalo we-DATE uzosetshenziselwa ukungena izinsuku ezisetshenziswe kulo msebenzi. Bona isigaba se- Error Values section ekupheleni kwalesi sifundo ngolwazi oluthe xaxa.
Ukufaka idatha
D1: Usuku Lokuqala: D2: Inombolo Yezinsuku: D3: Iholide 1: D4: Iholide 2: D5: Usuku Lokuphela: E1: = UMHLABA (2012,7,9) E2: 82 E3: = UMHLABA (2012,9,3 ) E4: = UMHLA (2012,10,8)- Faka idatha elandelayo kwiseli elifanele:
Qaphela: Uma izinsuku kumaseli E1, E3, no-E4 zingabonakali njengoba kuboniswe esithombeni esingenhla, hlola ukuze ubone ukuthi lawa maseli afomatiwe ukuze abonise idatha esebenzisa ifomethi yosuku olufushane.
Ukufaka umsebenzi we-WORKDAY
- Chofoza ku-cell E5 ukwenza kube iseli elisebenzayo - yilapho imiphumela yomsebenzi we-WORKDAY izoboniswa
- Chofoza kuthebhu yefomula
- Khetha usuku nosuku lomsebenzi> UMSEBENZI ovela ebhokisini ukuze ukhulise ibhokisi lengxoxo lomsebenzi
- Chofoza kumugqa we- Start_date ebhokisini lengxoxo
- Chofoza ku-cell E1 kushidi lokusebenzela ukuze ufake leli referensi yeseli ebhokisini lengxoxo
- Chofoza kulayini lezinsuku ebhokisini lengxoxo
- Chofoza ku-cell E2 kushidi lokusebenzela ukuze ufake leli referensi yeseli ebhokisini lengxoxo
- Chofoza kulayini weholide ebhokisini lengxoxo
- Hudula ukhethe amaseli e-E3 no-E4 kushidi lokusebenzela ukufaka lezi zikhombisi zeseli ebhokisini lengxoxo
- Chofoza OK ku-ibhokisi lengxoxo ukuze uqedele umsebenzi
- Usuku lomhla ka-11/2/2012 - usuku lokuphela kwephrojekthi - kufanele luvele kuseli-E5 lephepha lokusebenzela
- Indlela i-Excel ebala ngayo lolu suku yilo:
- Usuku olunezinsuku ezingu-82 emva kukaJulayi 9, 2012 ngo-Okthoba 31 (usuku lokuqala alubalwa njengenye yezinsuku ezingu-82 ngomsebenzi WOMSEBENZI)
- Ukwengeza ngalolu suku izinsuku ezimbili zeholide ezichaziwe (September 3 no-Okthoba 8) ezingazange zibalwa njengengxenye yempikiswano yama-82 Days
- Ngakho-ke, usuku lokuphela kwalolu hlelo nguLwesihlanu ngoNovemba 2, 2012
- Uma uchofoza ku-cell E5 umsebenzi ophelele = WORKDAY (E1, E2, E3: E4) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela
UMSEBENZI UMSEBENZI WEMPHUMO YOKUSEBENZA
Uma idatha yezingxabano ezihlukahlukene zalolu msebenzi ayifakiwe ngendlela efanele amanani wephutha alandelayo avela esitokisini lapho umsebenzi we-WORKDAY ukhona:
- #VALUE! : ivela engxenyeni yesiphenduli Uma esinye seziphakamiso ze-WORKDAY akusona usuku oluvumelekile (uma usuku lufakwe njengombhalo ngokwesibonelo)
- #NUM !: ivela engxenyeni yesiphenduli uma usuku olungavumelekile luphumela ekungeza izimpendulo ze - Start_date kanye nezinsuku
- Uma ukungqubuzana kwezinsuku kungenisiwe njenge-integer - njengezinsuku ezingu-82.75 - inombolo izobe ikhonjwe - kunokuba ihlanganiswe noma ibheke phansi - kwinani eliphelele lenombolo: izinsuku ezingu-82.