Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2003
    Thanked 0 Times in 0 Posts

    Adding times in excel (Excel 2002)

    When I try to add times in Excel - they add ok if I do: =g6+g7+g8 etc., but I get 00, when I do =sum(g6:g8). This appears to happen when my cells g6 - g8 have a formula that calculated the time e.g. =TEXT(E6-C6,"h:mm"). Is there some conversion I have to do to be able to sum an array vs. summing each cell separately? thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Adding times in excel (Excel 2002)

    The TEXT function returns - surprise - text, not a date/time value. The SUM function ignores text. If you want to perform calculations, don't use TEXT, but set the number format (Format | Cells..., Number tab). In your example, use a formula such as =E6-C6 in cell G6, and set the number format of cells G6:G8 to h:mm. Then, the SUM function should add the times correctly.

Posting Permissions

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