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.

"doughman" wrote in message
...
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