Shoutbox

how can i format cells so that the time is displayed like 17:15 etc i can only get 12:30:00 ¬_¬

Thanks

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

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)

cant you type 09:30 ?

quote:

---

Originally posted by Veggie
cant you type 09:30 ?

---

hm, i was typing 09.30 (just using the keypad)

EDIT: argh! now ive changed it to time i can't do the maths.... 18:00 - 09:30 =0.35 wtf!

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

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

For more infomation on showing diffe4rent times in excel have a look at markee's reply to Excel problem. Help please!