Overtime

[mtyrrell13]

I am trying to calculate Overtime using one formula. Here is what I have so far

=SUM(C17*E17),SUM((E17/2) * (D17))

E17=Rate
C17=Regular Hours
D17=Overtime Hours

Can someone point out what I have wrong here

 

[Russ At Index]

Hi mtyrrell13

Pearson's webpsge will giude you through the
time sheet / overtime senario's.

http://www.cpearson.com/excel/overtime.htm

Hope this helps you out ( So you can pay the correct overtime )


Russ

 

[barry houdini]

I am trying to calculate Overtime using one formula. Here is what I have so far

=SUM(C17*E17),SUM((E17/2) * (D17))

E17=Rate
C17=Regular Hours
D17=Overtime Hours

Can someone point out what I have wrong here

Assuming your hours are in time format, overtime pays half as much again as regular pay and rate is per hour

=(C17+D17*3/2)*24*E17

 

[mtyrrell13]

actualy no the time is in straight hours format 8 hrs straight time 4 hrs OT etc..

 

[barry houdini]

actualy no the time is in straight hours format 8 hrs straight time 4 hrs OT etc..

then you don't need to multiply by 24

=(C17+D17*3/2)*E17