Results 1 to 7 of 7

Adding HH:MM:SS not working

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-04-2009
    Location
    New York, New York
    MS-Off Ver
    Excel 2010
    Posts
    113

    Adding HH:MM:SS not working

    Hi,
    I have a column with hours in the following format HH:MM:SS, that looks like this:

    12:16:00
    1:35:00
    1:35:00
    12:47:00
    12:46:00
    12:51:00
    4:33:00
    4:05:00
    12:54:00
    3:19:00
    3:19:00


    I am trying to add the sum total of all hours, but its not working.
    I have my column formatted as time -> 37:30:55

    Any suggestions?
    Thanks.
    Last edited by nmss18; 02-18-2009 at 01:53 PM.

Thread Information

Users Browsing this Thread

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

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