Calculating Elapsed Time

  • Thread starter Thread starter carl
  • Start date Start date
C

carl

I have time data that looks as so:

114503
124745

which represents:

11:45:03
12:47:45

Is there a good way to calculate the elapsed time so that
it will reflect hours, minutes, seconds ?
 
Hi
I woulld try to convert these values to real Excel times. e.g.
- use Data - Text to columns
- or use a formula like
=TIME(LEFT(A1,2),MID(A1,3,2),RIGHT(A1,2))

After this you could use simply a formula like
=B2-B1

or if the time can span midnight
=B2-B1+(B2<B1)
 
One way

=TIME(INT(A2/10000),INT(MOD(A2,10000)/100),MOD(A2,100))-TIME(INT(A1/10000),I
NT(MOD(A1,10000)/100),MOD(A1,100))

where A2 holds 124745 and A1 holds 114503

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top