Convert Time

J

Jim

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.
 
N

Niek Otten

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
 
J

Jim

So how do I convert it into text?

Niek Otten said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top