Excel Time Format Question

Hello!

I'm an advanced beginner user with excel, can do basic stufff, but if someone with more experience can help me with this problem I've been having, I would really appreciate it.

When I try to format cells with both the time format hh:mm and the custom format h:mm, I get a date in the front of the time. Actually all the time formats insert a date. I can delete it but it's time consuming for all the cells I work with and if I type in a number the format returns to the date then time! I've tried to highlight it all and delete the date, but that doesn't work. How can I get rid of the date and not the time? Please help!

Thank you.

Hi and welcome to the board
how to you enter the time and is it more than 24 hours?

Hi Arthur!

Thanks for replying!

I enter "8" and I get this 0:00 but in the box that shows what it actually is I see this: 1/8/1900 12:00:00 AM

Thanks for any feedback!

Julie

You'll find useful info at this site concerning Date and Time in XL ( but in fact DO explains it all in 2 sentences ! )

Wow! Thanks for the tip! It worked!

I will look at the other tips!

Julie