D
Don Lowe
I need a formula to calculate time with overtime variances automaticly. The
following is how the time structure is set up:
Mon. - Thur. Fri. & Sat.
Sun.
1st (10) hours 1 1.5
2
..1 - 2 hrs. OT 1.5 1.5
2
over 2 hrs. OT 2 2
2
Each day the supervisor inputs the hours in perspective cells:
Mon. (J9), Tues. (M9), Wed. (P9), Thur. (S9), Fri. (V9), Sat. (Y9), Sun. (AB9)
In column AD (AD9) is where I need the calculation. Currently, I am
calculating time without overtime. I am using the following formula to
accomplish that:
=J9+M9+P9+S9+(V9*1.5)+(Y9*1.5)+(AB9*2)
This formula correlates with the 1st (10) hours only.
I need to some how integrate the overtime. Please help!!!
following is how the time structure is set up:
Mon. - Thur. Fri. & Sat.
Sun.
1st (10) hours 1 1.5
2
..1 - 2 hrs. OT 1.5 1.5
2
over 2 hrs. OT 2 2
2
Each day the supervisor inputs the hours in perspective cells:
Mon. (J9), Tues. (M9), Wed. (P9), Thur. (S9), Fri. (V9), Sat. (Y9), Sun. (AB9)
In column AD (AD9) is where I need the calculation. Currently, I am
calculating time without overtime. I am using the following formula to
accomplish that:
=J9+M9+P9+S9+(V9*1.5)+(Y9*1.5)+(AB9*2)
This formula correlates with the 1st (10) hours only.
I need to some how integrate the overtime. Please help!!!