time seperation

  • Thread starter Thread starter doughman
  • Start date Start date
D

doughman

Hi Im getting knocked about with this one and sure could use assistance from
someone in the know>>>
I am applying the following formula
=IF(C12>$W$5,(C12-$W$5)*24,IF(C12<$Y$5,($Y$5-C12)*24,"0")) to work shifts
i.e.(time format) 4:00 pm to 10:00 pm when increased rate is between 5pm and
6.30 am and normal rate is 6.30am to 5pm. I need the formula to be able to
handle all posabilities i.e. 1am to 9am so calculates hrs 1am to 6.30am and
next adjacent cell has remaining hrs can you assist
 
You'll need to answer some questions before we can get a solution.

1. What are you trying to calculate? Regular hours? Overtime hours?

2. What is C12? Start time?

3. What is W5? Start of bonus period (ie, 5pm)?

4. What is Y5? End of bonus period (ie, 6:30 am)?

5. If you are tying to calculate the amount of time worked, where is finish
time?

6. Does anyone work a shift which spans midnight?

Regards,
Fred.
 
Back
Top