Excel - Time cell format 24 hour? How? - Printable Version
-Shoutbox (https://shoutbox.menthix.net)
+-- Forum: MsgHelp Archive (/forumdisplay.php?fid=58)
+--- Forum: Skype & Technology (/forumdisplay.php?fid=9)
+---- Forum: Tech Talk (/forumdisplay.php?fid=17)
+----- Thread: Excel - Time cell format 24 hour? How? (/showthread.php?tid=66184)
Excel - Time cell format 24 hour? How? by M73A on 09-13-2006 at 04:52 PM
how can i format cells so that the time is displayed like 17:15 etc i can only get 12:30:00 ¬_¬
Thanks
RE: Excel - Time cell format 24 hour? How? by Veggie on 09-13-2006 at 05:03 PM
can you use google?
i googled your thread title:
http://www.google.co.uk/search?q=Excel%20-%20Time...20hour%3F%20How%3F
first result...
click format cell, custom, then enter: hh:mm
RE: Excel - Time cell format 24 hour? How? by M73A on 09-13-2006 at 05:08 PM
what the websites say gives me the same problem. i type 0930 (9:30 AM) and it goes to: 7:12:00 AM
(press f2 and the bar next to functions says 09/01/1900 7:12:00 AM)
RE: Excel - Time cell format 24 hour? How? by Veggie on 09-13-2006 at 05:11 PM
cant you type 09:30 ?
RE: Excel - Time cell format 24 hour? How? by M73A on 09-13-2006 at 05:15 PM
quote:hm, i was typing 09.30 (just using the keypad)
Originally posted by Veggie
cant you type 09:30 ?
EDIT: argh! now ive changed it to time i can't do the maths.... 18:00 - 09:30 =0.35
wtf!
RE: Excel - Time cell format 24 hour? How? by MeEtc on 09-13-2006 at 05:34 PM
on the cell, right click and go to Format Cell
There will be a tab labeled Number (the first one)
select the appropriate Category from the list (Time, in yor case)
choose one of the formats listed. (one of the bottom two, at least in Office 2003)
If none of the formats matches what you want, select one that is close to what you want, then choose the Custom category. You can now edit the format however you choose using the format you chose to customize and the other pre-defined custom formats as a guide
RE: Excel - Time cell format 24 hour? How? by M73A on 09-13-2006 at 08:56 PM
quote:
Originally posted by MeEtc
on the cell, right click and go to Format Cell
There will be a tab labeled Number (the first one)
select the appropriate Category from the list (Time, in yor case)
choose one of the formats listed. (one of the bottom two, at least in Office 2003)
If none of the formats matches what you want, select one that is close to what you want, then choose the Custom category. You can now edit the format however you choose using the format you chose to customize and the other pre-defined custom formats as a guide
i got it sorted now
i was typing 9.30 instead of 9:30 >.<
RE: Excel - Time cell format 24 hour? How? by markee on 09-13-2006 at 11:31 PM
For more infomation on showing diffe4rent times in excel have a look at markee's reply to Excel problem. Help please!