Convert Time
So how do I convert it into text?
"Niek Otten" wrote:
Depends on what you call "military time"
Anyway, in the new cell, insert the formula:
=A1
assuming that the original time is in A1
Then format custom as hh:mm:ss or hhmmss
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Jim" wrote in message
...
Hello,
In one cell I have the time showing (2:45:59 PM). In another cell I would
like to input a formula that will convert the time into a text cell
showing
military time.
Thanks in advance for the help.
|