Comparing 12-hour time data

[aduval]

I want to calculate the amount of time that has passed between the start time and the end time. The data comes from an external database so I have to analyze it in Excel. Here is a sample of the data:

BEGIN_TIME END_TIME
91945 93105
93109 94139
94143 95327
95331 101015
101020 101514
101520 101951
101954 103522
103526 104744
71125 71529
71604 71736

It is in (hhmmss) format but some times are 5 digit numbers and some are 6 digit numbers.

I need a formula that I can put in a third column that will calculate the hhmmss that has passed between the two time values.

Can you help?

Andre

 

[Andrew Poulsom]

If A1 contains 91945 this formula:

=TEXT(A1,"00\:00\:00")+0

will return a true serial time.

To subtract the times you can use:

=TEXT(B1,"00\:00\:00")-TEXT(A1,"00\:00\:00")

formatted as [h]:mm:ss.

 

[aduval]

Perfect! Thanks for the quick help.