N
Nacho
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?
24 hour format i.e. 15:00. How can I do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
Format as hh:mm
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
M
Marcelo
Hi,
Menu - format | Cells | hour ...
hth
regards from Brazil
Marcelo
"Nacho" escreveu:
Menu - format | Cells | hour ...
hth
regards from Brazil
Marcelo
"Nacho" escreveu:
B
Bearacade
Custom Format it to HH:M
J
Jessica C. Jara
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
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
G
Gary''s Student
Format > Cell... > Number > Time and pick 13:30:55