Thread: Elapse Time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Elapse Time

In D1 put ......ElapsedTime
In D3 put.......=C2-B2 and copy this formula down column D

hth
Vaya con Dios,
Chuck, CABGx3



"Art" wrote:

I would to calculate the elapsed time between the start and end
Time, to the nearest second. So that I can generate a chart to graphically
show what day the job took longer to process.

Example:
Date: start end
Monday 11:00 12:33
Tuesday 11:05 12:05
Wednesday 11:10 11:30

Any suggestion would be appreciated.