How to I convert standard time to Military or 24 hour format?

G

Guest

I have data with time in standard fromat i.e. 3:00PM but I need it to be in
24 hour format i.e. 15:00. How can I do this?
 
B

Bob Phillips

Format as hh:mm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
G

Guest

Hi,

Menu - format | Cells | hour ...

hth
regards from Brazil
Marcelo

"Nacho" escreveu:
 
G

Guest

Hi Nacho, just get on the cell, left click your mouse and in the display list
click format cells, once there click on the number page and in there click on
time. You will be able to find it there.

Hope this helps you,

Jessica
 

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

Similar Threads

advice on rounding or ceilng a 24 hour time value 3
military time calculations 1
"h:mm" format, but 12-hour time, not 24-hour time? 4
How many are at work every hour in a 24-hour day? 2
comparing time value 4
Time sheet template military hours problem 6
Changing decimal time into 24 hour time and reverse 4
time calculation, 24:00 - 16:00 = 8 4

Top