01 ea 01
Mosebetsi oa WORKDAY
Fumana Letsatsi la Qala kapa la ho Qala ho Excel
Excel e na le mesebetsi e 'maloa e hahiloeng mesebetsing ea letsatsi e ka sebelisetsoang lipalo tsa letsatsi la mosebetsi.
Mosebetsi o mong le o mong o etsa mosebetsi o fapaneng e le hore liphetho li fapane ho tloha ho e mong ho ea ho o mong. Ka hona, seo u se sebelisang, se itšetlehile ka liphello tseo u li batlang.
Excel Mosebetsi oa Mosebetsi
Tabeng ea mosebetsi oa WORKDAY, o fumana letsatsi kapa qalo ea morero kapa kabelo e fanoeng ka palo e behiloeng ea matsatsi a mosebetsi.
Hangata palo ea matsatsi a mosebetsi ha e kenyellehe mafelo-beke le matsatsi afe kapa afe a tsejoang e le matsatsi a phomolo.
Sebeliso ea mosebetsi oa WORKDAY e kenyeletsa ho bala:
- letsatsi la ho qetela la morero o nang le lenane la matsatsi a sebetsang ka mor'a letsatsi la qalo le fanoeng
- letsatsi le qalileng la morero o nang le lenane la matsatsi a sebetsang pele letsatsi la ho qetela le filoeng
- letsatsi le loketseng la invoice
- letsatsi le lebeletsoang la ho fana ka thepa kapa thepa
Syntax le Mesebetsi ea Mesebetsi ea WORKDAY
Syntax ea mosebetsi e bua ka boemo ba mosebetsi mme o kenyelletsa lebitso la mosebetsi, li-brackets le likhang .
Tlhaloso ea mosebetsi oa WORKDAY ke:
= WORKDAY (Start_date, Matsatsi, Phomolo)
Qala_date - (e hlokehang) letsatsi la qalo ea nako e khethiloeng. Letsatsi la pele le qalang le ka kenngoa bakeng sa khang ena kapa ho hlahloba sele ho ea sebakeng sa data ena mosebetsing ho ka kenngoa ho e-na le hoo.
Matsatsi - (a hlokehang) bolelele ba morero. Ena ke lenane le bontšang palo ea matsatsi a mosebetsi a neng a etsoa mosebetsing. Bakeng sa khang ena, kenngoa palo ea matsatsi a mosebetsi kapa selefouno ea sebaka seo data ena a leng ho sona mosebetsing.
Tlhokomeliso: Ho fumana letsatsi le hlahang ka mor'a khang ea Start_date sebelisa lenane le nepahetseng bakeng sa Matsatsi . Ho fumana letsatsi le hlahang pele khang ea Start_date e sebelisa lenane le fosahetseng bakeng sa Matsatsi . Nakong ena ea bobeli qabang ea Start_date e ka khetholloa e le letsatsi la ho qetela la morero.
Matsatsi a Phomolo - (ka khethollo) matsatsi a le leng kapa a mang a eketsehileng a sa baloang e le karolo ea matsatsi a sebetsang. Sebelisa litšupiso tsa sele ho ea sebakeng seo data e sebetsang ho sona bakeng sa khang ena.
Mohlala: Fumana Letsatsi la ho qetela la morero
Joalokaha ho bonngoe setšoantšong se ka holimo, mohlala ona o tla sebelisa mosebetsi oa WORKDAY ho fumana letsatsi la ho qetela la morero o qala ka la 9 Phutuho 2012 'me o phethela matsatsi a 82 hamorao. Matsatsi a mabeli a phomolo (la 3 le la 8 Phuthehong) e tla etsahala nakong ena e ke ke ea nkoa e le karolo ea matsatsi a 82.
Tlhokomeliso: Ho qoba mathata a ho bala a ka hlahang haeba matsatsi a kenngoa ka phoso ha ho ngoloa mosebetsi oa DATE o tla sebelisoa ho kenya matsatsi a sebelisitsoeng mosebetsing. Sheba karolo ea Lihlopha tsa Maemo a Phoso qetellong ea thupelo ena bakeng sa tlhahisoleseling e eketsehileng.
Ho kenya Dintlha
D1: Letsatsi la Qalong: D2: Palo ea Matsatsi: D3: Matsatsi a phomolo 1: D4: Matsatsi a phomolo 2: D5: Letsatsi la ho qetela: E1: = DATE (2012,7,9) E2: 82 E3: = DATE (2012,9,3) ) E4: = DATE (2012,10,8)- Kenya data e latelang ka seleng e loketseng:
Tlhokomeliso: Haeba matsatsi a liseleng tsa E1, E3 le E4 a sa hlahe joalokaha ho bontšoa setšoantšong se ka holimo, hlahloba ho bona hore lisele tsena li hlophisitsoe ho bonts'a dintlha ka mokhoa o khutšoanyane oa letsatsi.
Ho kena Mosebetsing oa WORKDAY
- Tobetsa ho cell E5 ho etsa hore e be sele e sebetsang - ena ke moo liphetho tsa mosebetsi oa WORKDAY li tla bontšoa
- Tobetsa Thabiso ea Tlhahlobo
- Khetha letsatsi le nako ea nako> ETSA MOSEBETSI ho tloha ka lekareche ho tlisa lebokose la lebokose la mosebetsi
- Tobetsa ho Start_date line lebokoseng la lebokose
- Tobetsa ka cell cell E1 kahare ea mosebetsi ho kenya reference ea sele ena ho lebokoseng la lebokose
- Tobetsa Molaong oa Matsatsi lebokoseng la lebokose
- Tlanya ka cell cell E2 lefatsheng la mosebetsi ho kenya reference ea sele ena ho lebokoseng la lebokose
- Tlanya molaong oa Matsatsi a Phomolo ka lebokoseng la lebokose
- Etsa lisele tse ling tsa E3 le E4 kahare ea lipampiri ho kenyelletsa litšupiso tsa lisele tsena ka lebokoseng la lebokose
- Tobetsa OK ho lebokoseng la lebokose ho phetha mosebetsi
- Letsatsi la 11/2/2012 - letsatsi la ho qetela la morero - le lokela ho hlaha ka seleng ea E5 ea leqephe la mosebetsi
- Kamoo Excel e lekanyang letsatsi lena ke:
- Letsatsi le leng la matsatsi a 82 ka mor'a la 9 Phupu, 2012 ke la 31 October (letsatsi la qalo ha le nkoe e le e 'ngoe ea matsatsi a 82 ka mosebetsi oa WORKDAY)
- Ho phaella letsatsing lena matsatsi a mabeli a phomolo a hlalositsoeng (September 3 le la 8 October) a sa kang a nkoa e le karolo ea phehisano ea Matsatsi a 82
- Kahoo, letsatsi la ho qetela la morero ke Labohlano la la 2 November, 2012
- Ha o tobetsa ka cell E5 mosebetsi o feletseng = WORKDAY (E1, E2, E3: E4) e hlaha kahare ea foromo ka holim'a leqephe
Mosebetsi oa WORKDAY Phoso ea Melao
Haeba lintlha tsa lintlha tse fapaneng tsa mosebetsi ona li sa kenngoa ka mokhoa o nepahetseng litekanyetso tse latelang tsa phoso li hlaha ka seleng moo mosebetsi oa WORKDAY o leng teng:
- #VALUE! : e hlaha seleng ea karabo Haeba e mong oa litsekisano tsa WORKDAY hase letsatsi le nepahetseng (haeba letsatsi le ne le kenngoa e le mohlala ka mohlala)
- #NUM !: e hlaha seleng ea karabo haeba letsatsi le sa sebetseng le hlaha ka ho eketsa lintlha tsa Start_date le Matsatsi
- Haeba Matsatsi khang e sa kenngoa e le lenane - joalo ka matsatsi a 82.75 - nomoro e tla behoa ka thōko - ho e-na le ho pota-pota kapa ho theoha-ho karolo e kholo ea palo: matsatsi a 82.