Convert TEXT to Elapsed Time

[Gary Schultz]

How do I convert a text string representing elapsed time to MINUTES:SECONDS?

Example:

Cell A1 contains the TEXT string "010646" representing 01 Hours, 06 MINUTES, 46 SECONDS. I would like to display this data in cell B1 as 66:46 or 66 MINUTES, 46 SECONDS of elapsed time. What formula should be used in cell B1?

 

[Jonmo1]

Welcome to the board...

Try

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

This will give 1:06:46 (1 hour 6 minutes 46 seconds.)
Then format the cell as custom [mm]:ss

Hope that helps.

 

[mole999]

could be

=CONCATENATE(LEFT(A1,2)*60+MID(A1,3,2)," Minutes, ",RIGHT(A1,2)," Seconds")