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

    Duration greater than 24 hours

    Rebecca Molstad

      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?