Fumana iQela loMhla okanye Umhla wokugqibela kwi-Google Spreadsheets

Iipredishithi zeGoogle zineemisebenzi ezinomhla ezakhiweyo ezingasetyenziselwa ukubala kwimihla yomsebenzi.

Umsebenzi ngamnye womsebenzi wenza umsebenzi ohlukeneyo ukwenzela ukuba iziphumo zihluke kumsebenzi omnye ukuya olandelayo. Yiyiphi na oyisebenzisayo, ngoko, kuxhomekeke kwiziphumo ozifunayo.

01 ka 03

Umsebenzi we-WORKDAY.INTL

I-Google Spreadsheets UMSEBENZI we-WORKDAY.INTL

Kwimeko yomsebenzi we-WORKDAY.INTL, ufumana umhla wokuqalisa okanye wokuphela kweprojekthi okanye isabelo esinikezwe inombolo ehleliweyo yeentsuku zomsebenzi.

Iintsuku ezichaziweyo njengeentsuku zeveki zitshatyalaliswa ngokuzenzekelayo kwixabiso. Ukongezelela, iintsuku ezithile, njengeeholide ezisemthethweni, zingashiywa kwakhona.

Indlela umsebenzi we-WORKDAY.INTL ohlukileyo ngayo umsebenzi we-WORKDAY kukuba i-WORKDAY.INTL ikuvumela ukuba uchaze ukuba yeyiphi intsuku kunye nokuba zingaphi iintsuku ezithatyathwa njengeentsuku zeveki kunokuba ususe ngokuzenzekelayo iintsuku ezimbini ngeveki - ngoMgqibelo nangeCawa - ukusuka kwinani leentsuku.

Ukusetyenziswa komsebenzi we-WORKDAY.INTL kubandakanya ukubala:

• Umhla wokuphela kweprojekthi eneenombolo zomsebenzi wentsuku emva komhla wokuqalisa owenziwe
• Umhla wokuqala weprojekthi eneenombolo zomsebenzi weentsuku phambi komhla wokuphela
• umhla ofunekayo we-invoyisi
• Umhla wokulindeleka wokuhanjiswa kwempahla okanye izinto

I-Syntax yeMisebenzi ye-WORKDAY.INTL kunye neeArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano .

I-syntax yomsebenzi we-WORKDAY ngu:

= WORKDAY.INTL (qalisa_ukuqala, i-num_ukugqibela, iveki, iiholide)

qala_date - (efunekayo) umhla wokuqala wexesha elikhethiweyo
- umhla wokuqala wokuqalisa ungangeniswa kule ngxabano okanye isalathisi yesalathisi kwindawo yendawo kule fom yokusebenzela ingeniswa endaweni

inombolo_ukugqibela - (efunekayo) ubude beprojekthi
- kule ngxabano, faka inani elibonisa inani leentsuku zomsebenzi ezenziwe kwiprojekthi
- faka inani langempela leentsuku zomsebenzi - njengama-82 - okanye isalathisi yesalathisi kwindawo yolu datha kwiphepha lokusebenzela
- ukufumana umhla owenzeka emva kokuqala kwe-argument argument, sebenzisa inani elipheleleyo kwi-num_days
- ukufumana umhla owenzeka ngaphambi kokuqala kwe-argument argument, sebenzisa inombolo eninzi ye-num_days

ngeveki - (ngokukhethayo) ibonisa ukuba yeyiphi intsuku yeveki ithathwa njengemihla yokuphela kweveki kwaye ingabandakanyi kule mihla ukusuka kwinani leentsuku zokusebenza
- kule ngxabano, faka ikhowudi yenombolo yeveki okanye iselferensi yeseli kwendawo yale datha kwiphepha lokusebenzela
- ukuba le ngxabano ishiywe, i-default 1 (ngoMgqibelo nangeCawa) isetyenziselwa ikhowudi yeveki
- khangela uluhlu olupheleleyo lweekhowudi zamanani kwikhasi 3 yale khokelo

iiholide - (okukhethwa kukho) enye okanye eminye imihla eyongezelelweyo engabandakanyiyo kwinani leentsuku zokusebenza
Imihla yeeholide ingafakwa njengamanani omhla wee-serial okanye iinkcukacha zeseli kwindawo yokubaluleka kwamanani kwiphepha lokusebenzela
- ukuba izitenferensi zesetyenzisiweyo zisetyenzisiweyo , ixabiso lexesha kufuneka lifakwe kwiiseli zisetyenziswe ngomhla we- DATE , DATEVALUE okanye TO_DATE ukuphepha iimpazamo ezinokwenzeka

Umzekelo: Fumana usuku lokuphela kweprojekthi kunye nomsebenzi we-WORKDAY.INTL

Njengoko kuboniswe kumfanekiso ongentla, lo mzekelo uya kusebenzisa umsebenzi we-WORKDAY.INTL ukufumana umhla wokuphela kwiprojekthi eqala ngoJulayi 9, 2012 kwaye iphetha iintsuku eziyi-82 emva koko.

Iholide ezimbini (Septemba 3 no-Oktobha 8) ezenzeka ngeli xesha aziyi kubalwa njengenxalenye yeentsuku ezingama-82.

Ukuze ugweme iingxaki zokubala ezinokuthi zenzeke ukuba iintsuku zingena ngengozi njengombhalo, umsebenzi we-DATE uya kusetyenziswa ukufaka imihla esetyenziswa njengeengxabano. Bona iCandelo leMilinganiselo yeZiphumo ekupheleni kwesi sihloko ngolwazi olungakumbi.

Ukungena kwiDatha

I-A1: Usuku lokuqala: I- A2: Inani leentsuku: A3: Iholide 1: A4: Iholide 2: A5: Umhla Wokuphela: B1: = UMHLA (2012,7,9) B2: 82 B3: = UMHLA (2012,9,3 ) B4: = UMHLA (2012,10,8)

1. Faka idatha elandelayo kwiseli efanelekileyo:

Ukuba imihla kumaseli b1, B3, kunye ne-B4 ayibonakali njengokuba iboniswe kumfanekiso ongentla, khangela ukuba ezi festile zifomathiweyo ukuba zibonise idatha isebenzisa ifomathi emfutshane.

02 ka 03

Ukufaka umsebenzi we-WORKDAY.INTL

Ukufaka umsebenzi we-WORKDAY.INTL

Iipredishithi zeGoogle ayisebenzisi ibhokisi yencoko yababini yokufaka iingxabano zomsebenzi njengoko zifumaneka kwi-Excel. Endaweni yoko, inebhokisi ephakanyiswa yi- auto ephakamisa njengoko igama lomsebenzi lifakwe kwiseli.

1. Cofa kwifowuni B6 ukwenzela ukuba yenze i- cell esebenzayo- yilapho iziphumo zomsebenzi we-WORKDAY.INTL ziza kuboniswa
2. Thayipha uphawu olulinganayo (=) olulandelwe igama lomsebenzi wosuku lomsebenzi, intl
3. Njengoko uthayipha, ibhokisi ye -auto-suggestion ibonakala ngamagama kunye ne-syntax yemisebenzi eqala ngeleta W
4. Xa igama le- WORKDAY.INTL livela kwibhokisi, nqakraza egameni nge-pointer ye mouse ukuze ufake igama lomsebenzi kwaye uvule ibhondi ejikelezayo kwi-cell B6

Ukungena kwiSigqibo seMisebenzi

Njengoko kuboniswe kumfanekiso ongentla, iingxoxo zomsebenzi we-WORKDAY.INTL zingeniswa emva kwebhokisi evulekile ejikelezweni kwi-cell B6.

1. Cofa kwiseli B1 kwiphepha lokusebenzela ukufaka le ferensi yeseli njengengqungquthela ye- start_date
2. Emva kwereferensi yeseli, thayipha i-comma ( , ) ukuba usebenze njengomhluli phakathi kweengxoxo
3. Cofa kwiseli B2 ukungena kule ferensi yeseli njengengxabano ye- num_days
4. Emva kwereferensi yeseli, thayipha enye i-comma
5. Cofa kwifowuni B3 ukungena kule ferensi yeseli njengengxabano yeveki
6. Phakamisa iiseli zeB4 kunye ne-B5 kwiphepha lokusebenzela ukuze ufake ezi ngqamaniso zeselfowuni njengengxabano yeeholide
7. Cinezela ukhiye wokungena kwibhodibhodi ukufaka ibakaki yokuvala yokuvala " ) " emva kwengxabano yokugqibela kwaye uzalise umsebenzi
8. Umhla 11/29/2012 - umhla wokuphela kweprojekthi - kufuneka uvele kwiseli B6 kwiphepha lokusebenzela
9. Xa ucofa kwi-cell b5 umsebenzi opheleleyo
   = WORKDAY.INTL (B1, B2, B3, B4: B5) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela

IMathembu emva koMsebenzi

Indlela i-Excel ebala ngayo lo mhla:

• Umhla oneminyaka engama-82 yokusebenza emva ko-Agasti 5, 2012, nguNovemba 27 (umhla wokuqalisa awubalwa njengenye yeentsuku eziyi-82 ngumsebenzi we-WORKDAY.INTL)
• Yongeza kule mihla imini yeeholide echaziweyo (uAgasti 19 noNovemba 15) ezingabalwa njengenxalenye yeengxabano ezingama- 82 kwiintsuku
• Umhla wokuphela kwiprojekthi ke ngoko, NgoLwesine, Novemba 29, 2012

WORKDAY.INTL Iimpazamo zeMpazamo yeeNkohlakalo

Ukuba idatha yeengxabano ezahlukahlukeneyo zalo msebenzi ayifakwanga ngokuchanekileyo, ixabiso lesiphumo elilandelayo livela kwiseli apho umsebenzi we-WORKDAY ukhona:

• #VALUE! : ibonakala kwisicatshulwa sentsuku Ukuba enye ingxoxo ye-WORKDAY ayilona usuku oluvumelekileyo (ukuba umhla ungeniswa njengombhalo ngomzekelo)
• #NUM !: ibonakala kwisicatshulwa sentsholongwane ukuba umhla wokungafanelekanga uvela ekungeniseni i- Start_date kunye neentsuku zokubambisana
• Ukuba iintsuku zeNtsuku azifakwanga njenge-integer - njengeentsuku eziyi-83.25 - inombolo iya kuthathwa kwinxalenye eninzi yenani: iintsuku eziyi-83

03 ka 03

Ithebhile yeeveki zeeNombolo zeeveki kunye neentsuku zeeveki ezihambelanayo

Ithebhile yeeveki zeeNombolo zeeveki kunye neentsuku zeeveki ezihambelanayo

Kwiindawo ngeveki ezimbini zeeveki

Inani leveki yokuphela kweentsuku 1 okanye ukushiywa ngoMgqibelo, ngeCawa 2 ngeCawa, ngoMvulo 3 ngoMvulo, uLwesibini 4 NgoLwesibili, uLwesithathu 5 uLwesithathu, uLwesine 6 NgoLwesine, uLwesihlanu 7 NgoLwesihlanu, ngoMgqibelo

Kwiindawo ngeveki enye yeveki

Inani leveki yeveki 11 ngeCawa 12 ngoMvulo 13 uLwesibini 14 uLwesithathu 15 uLwesine 16 uLwesihlanu 17 ngoMgqibelo