Converting Text to Time Format

mdemp311

New Member
Joined
Apr 25, 2014
Messages
2
I have data in excel with the following time format (07:03:56.903); however, some of the times are in text format (0710251) and only to seven digits.

I am trying to convert the text to the same format as the above time "hh:mm:ss.000"

thanks in advance for any suggestions

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

XOR LX

Well-known Member
Joined
Jul 2, 2012
Messages
4,517
Hi,

So what would you expect the conversion of that example to be?

Regards
 

Watch MrExcel Video

Forum statistics

Threads
1,095,973
Messages
5,447,648
Members
405,460
Latest member
stuartbennett

This Week's Hot Topics

Top