Creating Formulas for overtime

S

SumrGrl318

I need to create two formulas. One for overtime hours worked for 8-12 hours
and then another one for overtime hours worked over 12 hours.
 
B

Bob Phillips

Assuming that the start tgime is in A1, end time in B1,

8-12: =MIN(B1-A1-TIME(8,0,0),TIME(4,0,0))
12+: =MAX(0,B1-A1-TIME(12,0,0))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top