Hi

I'm trying to do a basic workshift for adding up my timesheets for work. I
work 07:00 to 14:00 on the morning shift, 14:00 to 21:00 on the afternoon
shift and 21:00 to 07:00 on nights. Then I have to add 20% for the shift
premium. In column A I've put the start time, Column B the finish time,
Column C the total and Column D the extra 20%. My problem lies when I take
column A from Column B, It won't calculate night shift because the first
figure is greater than the second

TIA
Steve