Time: Change format

  • Thread starter Thread starter Sat
  • Start date Start date
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
 
G'day!

Try the formula:

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

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

HTH
Jason
Atlanta, GA
 
Back
Top