I want to calculate overtime hours for employees
 

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

I want to calculate overtime hours for employees
 

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.

"ChefFrank" wrote:

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

I want to calculate overtime hours for employees
 

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

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

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


HTH,
JP


On Nov 16, 6:10 pm, ChefFrank
wrote:
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