Change date format?

[WJHamel]

In column M, i have a long series of times (times of day) which are currently formatted as "1654", "1021", "1628", etc. In column AI, i need to reformat those dates to look like: "00:00:00.000"

What would the formula to accomplish that look like?

thanks!

James

 

[barry houdini]

Hello James,

Try this formula in AI2

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

format cell as hh:mm:ss.000

 

[WJHamel]

Bada-bing.

Thanks!