Elapse Time

[Guest]

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.

 

[Guest]

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

hth
Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Chuck, Would it be possible to change 1.86 to 2.26 ( hh:mm ).

(End Time) 9.24 - (Start Time) 7.38 = (Elapsed Time) 1.86

So that when the chart is displayed the folks don't have to the math.

Really appeciate..

 

[Guest]

With EndTime in C2 and StartTime in B2....

=INT(C2-B2)+INT((C2-B2-INT(C2-B2))*100/60)+(((C2-B2-INT(C2-B2))*100/60-INT((C2-B2-INT(C2-B2))*100/60))*60)/100

All in one cell, watch out for word-wrap

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Thanks Chuck that worked..

With EndTime in C2 and StartTime in B2....

=INT(C2-B2)+INT((C2-B2-INT(C2-B2))*100/60)+(((C2-B2-INT(C2-B2))*100/60-INT((C2-B2-INT(C2-B2))*100/60))*60)/100

All in one cell, watch out for word-wrap

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Chuck, sorry for the inconvenience but hopefully these question will help
others too.

Your formula worked fine till I had to enter the time after midnight.

(Start Time) 22.42 – (End time) 00.59 = ( Elapsed time) -21.83

How can I get the -21.83 to 2.17 ?


I appreciate your Help..

 

[Guest]

You can't solve that problem properly unless you use DATES as well as times.
See Chip's page for much more info about working with TIMES.........

http://www.cpearson.com/excel/datetime.htm#AddingTimes

hth
Vaya con Dios,
Chuck, CABGx3