Write out time format from cell with numbers

[Weeble]

Hi MrExcel forum! ( first post )

at work I can withdraw a "timestamp" from a QRY. The time is shown like this. [71131], so basicly it's 07:11:31 HH:MM:SS.

In short I am trackin a time activity of a person and I need to know how many mintues pass each task.

Tasks might look like this.
71131
71219
71327
93512
121015

How can I calculate the time difference between them in a good way?

 

[Tetra201]

The following formula will give you the difference in Excel time:

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

Then you can format it as h:mm:ss, or multiply by 86400 to get seconds, or multiply by 1440 to get minutes, etc.

 

[Special-K99]

You need to format them all as time
This will do it, but there may be a better way

=SUBSTITUTE(TEXT(RIGHT("0"&A1,6),"00-00-00"),"-",":")+0

and copy down the column
format as time

 

[Weeble]

This was exactly what I was looking for, Thx a bunch!

 

[Tetra201]

Glad to be of a help.