Time: Change format

S

Sat

G'day
I have cells with time written as 5.10 which actually
should mean 05:10 in 24 hr format.
How can I change the format to reflect time in 24hr format.
Have tried to replace "." to ":" and also change cell
format but it doesnt work.

Pls help
 
J

Jason Morin

G'day!

Try the formula:

=SUBSTITUTE(TEXT(A1,"0.00"),".",":")*1

and custom format the formula cell as [h]:mm.

HTH
Jason
Atlanta, GA
 
Top