Time formula

D

Donald

I need a time formula that wll give me a break down of regular time
over time, and double time: example

12.75 = 10 2 .7
 
C

Celtic_Avenger

Would you not put the results in separate cells such as


You would need to calculate the double time first.



A1 = Hours Worked
B1 = Regular Hours
C1 = Overtime
D1 = Double Time

Based on your answers for the 12.75 hours worked, the formular in eac
cell would be.

A1 = Enter hours Worked

B1 =IF(A1>10,10,A1)

C1 =IF(A1>10,A1-B1-D1,0)

D1 =IF(A1>12,A1-12,0)


These are based on regular hours being first 10 hours, overtime bein
next 2 hours and double time being anything over that.


Hope this helps

Celtic_Avenge
 
J

Jason Morin

Per your example, 0-10 hrs = regular time, 10.01-12 hrs is
OT, and anything over 12 hrs is DOT.

A1: 12.75

Regular:
=MIN(A1,10)

OT:
=MIN(2,A1-10)*(A1>10)

DOT:
=MAX(0,A1-12)

HTH
Jason
Atlanta, GA
 
Top