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?

Format as hh:mm

--
HTH

Bob Phillips

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

"Nacho" wrote in message
...
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?

Hi,

Menu - format | Cells | hour ...

hth
regards from Brazil
Marcelo

"Nacho" escreveu:

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?

Custom Format it to HH:MM


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=556597

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

"Nacho" wrote:

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?

Format Cell... Number Time and pick 13:30:55
--
Gary's Student


"Nacho" wrote:

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?