7 Replies Latest reply: Oct 5, 2017 8:49 AM by Chanty 4u

# Calculating Duration of a row of times

Hi,

I have a list of duration times and am wondering how I can sum these up to Days, Hours, Minutes and Seconds. It's a phone log and I am trying to calculate the average and total time spent on the phone. Here is an example of some of the rows:

 00:00:02 00:00:03 00:00:03 00:00:03 00:00:04 00:00:04 00:00:04 00:00:05 00:00:05

This is hh:mm:ss

Added Excel sheet also with a column of it.

Don't know why, but I keep getting a total of 11 hours and x amounts of hours / mins?

• ###### Re: Calculating Duration of a row of times

try this

interval(Field, 'D hh:mm:ss') or perhaps interval(interval#(Field, 'hh:mm:ss'), 'D hh:mm:ss'). .

• ###### Re: Calculating Duration of a row of times

What I get is 0 days, 11 hours, 18mins and 58 seconds. Which sounds very high...

• ###### Re: Calculating Duration of a row of times

try this

=sum(Interval(Interval#(Time,'hh.mm.ss'),'dd.hh.mm'))

• ###### Re: Calculating Duration of a row of times

Returns nothing...

Right now it is formatted in the Load Script as:

Timestamp#(A,'hh:mm:ss') AS A2

• ###### Re: Calculating Duration of a row of times

remove # and try

Timestamp(A,'hh:mm:ss') AS A2

• ###### Re: Calculating Duration of a row of times

Didn't work.  Really appreciate the answers but lets wait and see what other suggestions come in.

I am thinking I might have to make it into seconds and then format that differently.

• ###### Re: Calculating Duration of a row of times

thanks try this below

=interval(Your_field/24,'D HH:mm:ss')

or

=interval(Your_field, 'd hh:mm:ss')