Elapse Time
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..
"CLR" wrote:
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
"Art" wrote:
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..
"CLR" wrote:
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.
|