Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Location
    Toronto, Ontario, Canada
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding Times (XP)

    I thought this would be easy -- but it's not working out that way. I have to add a list of times. (i.e. 8min 20 second, 6 min 15 seconds). When I format cells to any of the time options, or to the custom options, it doesn't seem to work. Any idea as to how I get get Excel to recognize these figures properly?

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Adding Times (XP)

    That should work, what sort of errors are you getting?

  3. #3
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding Times (XP)

    Excel converts dates to a number of days from a fixed start date (I don't know what the start date is). To get the number of days between two dates, you just subtract the two dates (assuming they are in date format). For excel 32000 = Aug 11, 1987.

    Time is the same but it is using fractions of days. For excel 0.4 = 9:36:00 am (or 40% of the way thru the day). If you enter the time as hh:mm:ss, excel auto formats it to time and then you should be able to add them together.

    One thing to watch for is taht if you add 0.4 and 0.4 and 0.4 you will get 4:48:00 am using one time format or 28:48:00 using another time format.
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Adding Times (XP)

    Do you have an excel "time" in the cell or is it text.

    Format it to general and if it is a number it can be formatted to a time, if it stays the same it is text and excel will not interpret it as a time.

    Steve

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Adding Times (XP)

    As Steve notes, Excel is very picky about the formatting of time entries. In the following table, I entered 4 minutes 48 seconds in the second column, formatted to be a valid time in Excel. I had to use a leading zero for no hours, a colon, minutes, a colon, then seconds:
    <table border=1><tr><td>4 min 48 sec</td><td align=right>0:04:48</td><td align=right>
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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