8 Replies Latest reply: Aug 8, 2012 12:37 PM by Rebecca Molstad

# Duration greater than 24 hours

I have three fields: StartTime, EndTime, and Duration. They are all in hh:mm:ss format. But when I use the expressions sum(Duration), sum(hour(duration)), or even interval(sum([Duration]),'hh:mm'), it isn't adding correctly. My total duration should be about 80 hours, and it only shows 8. Suggestions?

• ###### Re: Duration greater than 24 hours

Using interval function should be correct.

What does =sum(Duration) show? A number a little larger than 3?

• ###### Re: Duration greater than 24 hours

The total sum shows 12320:14:30, which equals the "sum" in Excel. I have attached the spreadsheet with start time, end time, and duration, because I think the problem may be from the Duration field in Excel?

• ###### Re: Duration greater than 24 hours

Why do you think your sum of durations should be some 80 hours instead 12320 then?

• ###### Re: Duration greater than 24 hours

It shouldn't, sorry for the confusion. The y-axis on my graph shows the following (even though it is in hh:mm format):

I guess this is the real problem.

• ###### Re: Duration greater than 24 hours

What's the problem then? The format of the data on the y-axis?

• ###### Re: Duration greater than 24 hours

Yes, and in the straight table. The grand total of Duration with no filters whatsoever is "8:14", which is not right at all.

• ###### Re: Duration greater than 24 hours

It seems that you format your expression as date not as interval (or that the format of duration field is a date format?).

Try setting an explicite interval format in number tab of your chart.

Attached is my sample file.

Hope this helps,

Stefan

• ###### Re: Duration greater than 24 hours

That solved the problem - it was set as Time not Interval. Thank you, Stefan!