Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Using interval function should be correct.
What does =sum(Duration) show? A number a little larger than 3?
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?
Why do you think your sum of durations should be some 80 hours instead 12320 then?
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.
What's the problem then? The format of the data on the y-axis?
Yes, and in the straight table. The grand total of Duration with no filters whatsoever is "8:14", which is not right at all.
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
That solved the problem - it was set as Time not Interval. Thank you, Stefan!