Calculating Time

[Steve]

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

 

[DDM]

Steve, take a look at Chip Pearson's discussion of date and time arithmetic
at http://www.cpearson.com/excel/datearith.htm, and scroll down to "Time
Intervals."