Results 1 to 10 of 10

Sum in dd:hh:mm:ss

Threaded View

  1. #1
    Registered User
    Join Date
    03-19-2019
    Location
    Mexico
    MS-Off Ver
    Office 2016
    Posts
    7

    Sum in dd:hh:mm:ss

    Hi guys. I'm using a database of the duration time of the different trips that a set of vehicles made during the month. The data is in the format dd:hh:mm:ss. I would like to add these data (more than 300 rows) to obtain the total amount of time of the different trips and with this information get a lot more of averages and relevant information for my customers. The thing is that I can't get the sum.

    For example:

    A1: 00:17:41:24
    A2: 0:01:39:00
    A3: Sum(A1:A2)

    But i just got 0:00:00:00

    Please help me!!
    Last edited by AngelJD25; 03-19-2019 at 05:25 PM. Reason: SOLVED

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