I want to calculate overtime hours for employees

[Guest]

I have the employees time for the week add up in P and I need regular time in
Q and overtime in R.
something like hours reg ot
54 40 14

 

[Guest]

Chef --
I'm not sure what the rest of your worksheet is like, but this might work:

P Q R
1 54 =MIN(P1,40) =P1-Q1

Hope that helps.

 

[JP]

Regular hours: =IF(P1>40,40,P1)
Overtime: =IF(P1>40,P1-40,"0")

Or if you are listing the hours in column fashion...

Regular: =IF(SUM(P)>40,40,SUM(P))
Overtime: =IF(SUM(P)>40,SUM(P)-40,"0")


HTH,
JP