最新消息:20210816 当前crifan.com域名已被污染,为防止失联,请关注(页面右下角的)公众号

如何按照入职天数按比例计算第13薪

生活 crifan 2213浏览 0评论

如何按照入职天数按比例计算第13

How to calculate your 13th salary according to you hire date

 

The whole info show in follow table (original is in Excel file):

 

A

B

C

D

E

F

G

1

 

12/31/2010

 

 

 

 

 

2

Hire Date

Service portion

Monthly Base

13th salary

 

 

 

3

10/15/2010

17%

5000.00

833.3

76

2.4918033

2

 

 

Already know:

You first on-board/employment day is: 2010-10-15

The end of year: 2010-12-31

Assume your basic month salary is : 5000

 

The steps to calculate your partly 13th salary:

 

The days between your first day to the end of year is:

E3 = DAYS360(A3, B1)

     = 76 days

 

The corresponding months is:

F3 = IF( E3 >=360, 12, (E3 / 30.5) )

     = IF(76>=360, 12, 76/30.5)

     = IF(76>=360, 12, 2.4918033)

     = 2.4918033

In which:

360 means if you hire days already exceed 360 days, take it as the whole year, 12 months.

30.5 means the average days of each month.

 

Then the actual used number of month is:

G3 = ROUND(F3, 0)

      = ROUND(2.491803279, 0)

      = 2

 

So the final percentage is:

B3 = G3 / 12

     = 2 /12

     = 0.16667

     = 17%

 

Then your partly 13th salary is:

E3 = C3 * D3

     = 17% * 5000

     = 833.3

 

转载请注明:在路上 » 如何按照入职天数按比例计算第13薪

发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址
91 queries in 0.142 seconds, using 20.70MB memory