+ Reply to Thread
Results 1 to 2 of 2

adding time together

  1. #1
    Registered User
    Join Date
    05-31-2013
    Location
    avignon, france
    MS-Off Ver
    Excel 2003
    Posts
    1

    adding time together

    i'm sure you are all sick of this - but an hours research via search engines and i'm still none the wiser...

    i want to add time together.

    in column A i have 01:01:03
    and in B i have 00:00:02
    and so on...
    I have 6 columns in total, some are blank, but in col G it SHOULD read 01:01:05

    at the moment all i want to do is just sum the columns? is it that hard?

    column reads 00:00:00 if you do a normal =sum(A1:A6)

    thanks all!

  2. #2
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: adding time together

    It works perfectly well for me. Could you post an example workbook where this is not working for you?
    If I've been of help, please hit the star

+ 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