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