Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
try this
interval(Field, 'D hh:mm:ss') or perhaps interval(interval#(Field, 'hh:mm:ss'), 'D hh:mm:ss'). .
What I get is 0 days, 11 hours, 18mins and 58 seconds. Which sounds very high...
try this
=sum(Interval(Interval#(Time,'hh.mm.ss'),'dd.hh.mm'))
Returns nothing...
Right now it is formatted in the Load Script as:
Timestamp#(A,'hh:mm:ss') AS A2
remove # and try
Timestamp(A,'hh:mm:ss') AS A2
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.
thanks try this below
=interval(Your_field/24,'D HH:mm:ss')
or
=interval(Your_field, 'd hh:mm:ss')