Hi I an trying to generate a formula to enable my wife to calculate the off
duty for her section.
i have used 3 cells to start off with just to see if i could get it to work,
cell 1 = start time, Cell 2 = end time, Cell 3 = total.
e.g. start time =08.00, end time =13:00, then total time = 5hrs, formula say
=sum(d3-d2) simple. Ok
Well this is the part were i have got stuck. If the total is equal or more
than 7 hours then i need to subtract 0.5hr, but only if it is equal or
greater
so say start time is 10:00, end time is 22:00 then is should = 11.5 and not
12 hrs as the sum is greater than 7hrs
Can some kind person out there help with the formula

cheers