Fumana Letsatsi la Qala kapa la Qetello ho Google Spreadsheets

Google Spreadsheets e na le mesebetsi e mengata ea letsatsi e kenyelletsoeng 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.

01 ea 03

Mosebetsi oa WORKDAY.INTL

Google Spreadsheets WORKDAY.INTL Mosebetsi

Tabeng ea mosebetsi oa WORKDAY.INTL, o fumana letsatsi kapa qalo ea morero kapa kabelo e fanoeng ka palo e behiloeng ea matsatsi a mosebetsi.

Matsatsi a boletsoeng e le matsatsing a mafelo-beke a tlosoa ka ho feletseng ho palo. Ho phaella moo, matsatsi a tobileng, a kang matsatsi a phomolo a molao, a ka tlosoa hape.

Kamoo mosebetsi oa WORKDAY.INTL o fapaneng kateng le mosebetsi oa WORKDAY ke hore WORKDAY.INTL e u lumella hore u bolele matsatsi a mang le hore na ke mang a nkoang matsatsi a mafelo-beke ho e-na le ho tlosa ka boomo matsatsi a mabeli ka beke - Moqebelo le Sontaha ho tloha matsatsing a matsatsi.

Sebeliso ea mosebetsi oa WORKDAY.INTL 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.INTL

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.INTL (qala_date, num_e matsatsi, mafelo-beke, matsatsi a phomolo)

qala_date - (e hlokehang) letsatsi la qalo ea nako e khethiloeng
- letsatsi le qalileng la ho qala le ka kenngoa bakeng sa khang ena kapa ho hlahloba sele ho ea sebakeng sa data ena lefapheng la mosebetsi ho ka kenngoa ho e-na le hoo

matsatsing a mangata - (a hlokehang) bolelele ba morero
- bakeng sa khang ena, kenyelletsa lengolo le leng le bontšang palo ea matsatsi a mosebetsi a neng a etsoa mosebetsing
- kenya nomoro ea matsatsi a mosebetsi - joalo ka 82 - kapa selefouno ea sebaka seo data ena a leng ho sona mosebetsing
- ho fumana letsatsi le hlahang ka mor'a puisano ea qalang-ts'ebetsong, sebelisa e kholo e kholo bakeng sa matsatsi a num_e
- ho fumana letsatsi le hlahang pele ho qhoebeshano-qala, sebelisa intekanyo e fosahetseng bakeng sa matsatsi a num_

mafelo-beke - (ka khethollo) e bontša matsatsi afe a beke a nkoa e le matsatsing a mafelo-beke mme ha a kenyelle matsatsi ana ho tloha matsatsing a ho sebetsa
- bakeng sa khang ena, kenya khoutu ea nomoro ea mafelo-beke kapa lisele tsa sele ho sebaka sa data ena mosebetsing
- haeba khang ena e sa lumelloe, moeli oa 1 (Moqebelo le Sontaha) o sebelisetsoa khoutu ea mafelo-beke
- bona lenane le feletseng la lits'ebetso tsa manane leqepheng la 3 la thuto ena

matsatsi a phomolo - (ka ho khetheha) matsatsi a mang kapa a mang a eketsehileng a khethiloeng matsatsing a ho sebetsa
- Matsatsi a matsatsi a matsatsi a phomolo a ka kenngoa e le linomoro tsa morao-rao kapa li-cell reference tsa sebaka seo letsatsi le leng la bohlokoa ka sona leqepheng la mosebetsi
- haeba litlaleho tsa sele li ntse li sebelisoa, litekanyetso tsa letsatsi li lokela ho kenngoa liseleng tse sebelisang mesebetsi ea DATE , DATEVALUE kapa TO_DATE ho qoba liphoso tse ka khonehang

Mohlala: Fumana Letsatsi la ho qetela la morero ka mosebetsi oa WORKDAY.INTL

Joalokaha ho bonngoe setšoantšong se ka holimo, mohlala ona o tla sebelisa mosebetsi oa WORKDAY.INTL ho fumana letsatsi la ho qetela la morero o qala ka la 9 Phupu 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.

Ho qoba mathata a ho bala a ka hlahang haeba matsatsi a kenngoa ka phoso e le mongolo, mosebetsi oa DATE o tla sebelisoa ho kenya matsatsi a sebelisitsoeng e le likhang. Sheba karolo ea Lihlopha tsa Maemo a Phoso qetellong ea thupelo ena bakeng sa tlhahisoleseling e eketsehileng.

Ho kenya Dintlha

A1: Nako ea Qala: A2: Palo ea Matsatsi: A3: Matsatsi a phomolo 1: A4: Matsatsi a phomolo 2: A5: Letsatsi la ho qetela: B1: = DATE (2012,7,9) B2: 82 B3: = DATE (2012,9,3 ) B4: = DATE (2012,10,8)

1. Kenya data e latelang ka seleng e loketseng:

Haeba matsatsi a liseleng tsa b1, B3, le B4 a sa hlahehe joalokaha ho bontšitsoe setšoantšong se ka holimo, sheba hore lisele tsena li hlophisitsoe ho bonts'a dintlha ka mokhoa o khutšoanyane oa letsatsi.

02 ea 03

Ho kenya mosebetsi oa WORKDAY.INTL

Ho kenya mosebetsi oa WORKDAY.INTL

Li-spreadsheet tsa Google ha li sebelise lebokose la li- dialog box ho kenya likhopolo tsa mosebetsi joalokaha li ka fumanoa Excel. Ho e-na le hoo, e na le lebokose le bontšang likoloi tse hlahisang ha lebitso la mosebetsi le kenngoa ka seleng.

1. Tobetsa seleng ea B6 ho e etsa sele e sebetsang - ena ke moo liphetho tsa mosebetsi oa WORKDAY.INTL li tla bontšoa
2. Tšoaea letšoao le lekanang (=) le lateloa ke lebitso la mosebetsi oa mosebetsi, intl
3. Ha u ntse u thaepa, lebokose le nang le maikutlo a ikemetseng le hlaha ka mabitso le li-syntax tsa mesebetsi e qalang ka lengolo W
4. Ha lebitso la WORKDAY.INTL le hlaha lebokoseng, tobetsa lebitso ka mohoeletsi oa mouse ho kenya lebitso la mosebetsi le ho bula sesebelisoa se pota-potileng seleng ea B6

Ho kenya litlhaloso tsa mosebetsi

Joalokaha ho bonngoe setšoantšong se ka holimo, lintlha tsa mosebetsi oa WORKDAY.INTL li kenngoa ka mor'a kopo e bulehileng ka seleng ea B6.

1. Tobetsa seleng ea B1 kahare ea mosebetsi ho kenya reference ea sele ena e le qabang ea qala_date
2. Ka mor'a hore ho buuoe sele, khetha mofuta oa comma ( , ) ho iketsa karohano pakeng tsa likhang
3. Tobetsa seleng ea B2 ho kenyelletsa sebaka sena sa kakaretso ea sele ho tšoana le num_days argument
4. Ka mor'a hore ho buuoe sele, khetha mofuta o mong oa lihlahisoa
5. Tobetsa seleng ea B3 ho kenyelletsa setšoantšo sena sa sele e le khang ea mafelo-beke
6. Totobatsa lisele tsa B4 le B5 lefapheng la mosebetsi ho kenya litemana tsena tse kang linyeoe tsa phomolo
7. Tobetsa konopo ea ho kena ka lebokoseng ho kenya khalase ea ho qetela " ) " ka mor'a khang ea ho qetela le ho phetha mosebetsi
8. Letsatsi la 11/29/2012 - letsatsi la ho qetela la morero - le lokela ho hlaha ka seleng ea B6 ea leqephe la mosebetsi
9. Ha o tobetsa seleng b5 mosebetsi o feletseng
   = WORKDAY.INTL (B1, B2, B3, B4: B5) e hlaha kahare ea foromo ka holim'a leqephe

Math ka mor'a mosebetsi

Kamoo Excel e lekanyang letsatsi lena ke:

• Letsatsi le leng la matsatsi a ts'ebetso a 82 ka mor'a la 5 August, 2012, ke la 27 November (letsatsi la qalo ha le nkoe e le e 'ngoe ea matsatsi a 82 ka mosebetsi oa WORKDAY.INTL)
• Ho phaella letsatsing lena matsatsi a matsatsi a phomolo a hlalositsoeng (August 19 le la 15 November) a sa kang a nkoa e le karolo ea qabang ea Matsatsi a 82
• Letsatsi la ho qetela la morero ke ka Labone la 29 November, 2012

WORKDAY.INTL Phoso ea Mesebetsi ea Phoso

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 palo e kholo - e kang matsatsi a 83.25 - nomoro e tla romeloa karolong e kholo ea palo: matsatsi a 83

03 ea 03

Lethathamo la Mekhoa ea Bofelo ba Libeke le Libeke le Matsatsi a Matsatsi a Libeke

Lethathamo la Mekhoa ea Bofelo ba Libeke le Libeke le Matsatsi a Matsatsi a Libeke

Bakeng sa libaka tse nang le beke ea matsatsi a mabeli a letsatsi

Matsatsi a Matsatsi a Libeke-beke 1 kapa a siea Moqebelo, Sontaha 2 Sontaha, Mantaha 3 Mantaha, Labobeli 4 Labobeli, Labohlano Labobeli, Labone 6 Labone, Labohlano 7 Labohlano, Moqebelo

Bakeng sa libaka tse nang le letsatsi le leng la beke

Number Weekend letsatsi 11 Sontaha Mantaha 13 Labobeli Labobeli Labobeli 15 Labone Labone Labohlano 17 Moqebelo