View Single Post
  #1  
Old June 2nd, 2010, 11:16 AM posted to microsoft.public.excel.misc
Steve M
external usenet poster
 
Posts: 31
Default Calculate the amount of time over a permitted amount (12 hours)

Hi
I would like to calcualte the time over a permitted amount and display it in
a cell.

Column C is the start time dd/mm/yy hh:mm and Column L is the finish time
dd/mm/yy hh:mm. The alloted time is 12 hours for the job and and need column
M to show the amount of time used over the 12 hours.

Many Thanks.