Example 1:
Sat Sat/Sun
Start Finish
A1 B1
8:00 20:00 Start Saturday morning end Saturday evening.
A2 B2
Roster 12.00


Example :
Start Finish
A1 B1
20:00 08:00 Start Saturday evening end Sunday Morning
A2 B2
Roster 12.00

I am using the following formula to caluclate the hours attibutable to
Sunday. Can some one help as the result is not correct where the shift ends
on Saturday

=if(a2="roster",24*(if B1<A1,B1,B1-A1)),0)


Example 1 above result =12 hours incorrect as all Saturday Hours
Example 2 above result =8 hours which is Correct

Can some-one put me right please

F. Learning