I need to add a colon to military time. I don't want am/pm to show. Only
change for example 1730 to 17:30. How do I do this?

"Bob Phillips" wrote:

=TIME(INT(A1/100), MOD(A1,100),0)

--

HTH

RP

"Vincdc" wrote in message
...
Hello:
I have some data like 415, 537, 2012...
Which function I can use to convert this number to hh:mm format, e.g.
4:15,
5:37 and 20:12?
Thanks in advance!