Results 1 to 10 of 10

Sum in dd:hh:mm:ss

Threaded View

AngelJD25 Sum in dd:hh:mm:ss 03-19-2019, 03:53 PM
avk Re: Sum in dd:hh:mm:ss 03-19-2019, 04:04 PM
AngelJD25 Re: Sum in dd:hh:mm:ss 03-19-2019, 04:40 PM
Melvosh Re: Sum in dd:hh:mm:ss 03-19-2019, 04:50 PM
shg Re: Sum in dd:hh:mm:ss 03-19-2019, 05:02 PM
AngelJD25 Re: Sum in dd:hh:mm:ss 03-19-2019, 05:23 PM
AngelJD25 Re: Sum in dd:hh:mm:ss 03-19-2019, 05:30 PM
AngelJD25 Re: Sum in dd:hh:mm:ss 03-19-2019, 05:32 PM
ChemistB Re: Sum in dd:hh:mm:ss 03-19-2019, 05:03 PM
Roel Jongman Re: Sum in dd:hh:mm:ss 03-19-2019, 05:36 PM
  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