+ Reply to Thread
Results 1 to 6 of 6

Excel Time Format Question

  1. #1
    Registered User
    Join Date
    06-07-2010
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2003
    Posts
    3

    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.

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,222

    Re: Excel Time Format Question

    Hi and welcome to the board
    how to you enter the time and is it more than 24 hours?
    Quoting entire posts clutters the forum and makes threads hard to read !

  3. #3
    Registered User
    Join Date
    06-07-2010
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Excel Time Format Question

    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

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,526

    Re: Excel Time Format Question

    Time in XL is Decimal - ie 0.5 is equivalent of 12 hours, 24 hours being 1.

    8 is thus seen as 8 Days and thus 192 hours rather than 8 hours (if you format as [h]:mm you will see 192:00)

    If you want to enter 8 hours as a time value you should type in: 8:00

    (the colon tells XL it's a time value - ie 0.33333333... )

  5. #5
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,222

    Re: Excel Time Format Question

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

  6. #6
    Registered User
    Join Date
    06-07-2010
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Excel Time Format Question

    Wow! Thanks for the tip! It worked!

    I will look at the other tips!

    Julie

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1