Recent content by marshaji

I have a spreadsheet in which i have a date column, start time finishtime and duration. some of the finish times are after midnight and i require to calculate how many hours are after midnight as they have a different pay rate. Midweek eveing hours are paid say £56.00 and overnight £65.00 the...