I wonder if anybody could give me any ideas as to how to calculate the total time on a grid 'Group By', and would also be nice to utilise the same method on a PDF Report later on.

Put simply, I have a series of records, each have a start and end DATETIME field, and I am calculating the difference between the times using TIMEDIFF and then inserting that in to the DB against each record every time the grid loads to ensure it is up to date, however... what I cannot work out how to do, is to calculate the total time of all records on the 'Group By' selections as this only gives the option of COUNT for time fields.

Is there a simple way of this, or does the total time need to be converted to seconds to calculate as a SUM and then converted back to time format, and if so, what is the best method within scriptcase?

Thanks in advance

Put simply, I have a series of records, each have a start and end DATETIME field, and I am calculating the difference between the times using TIMEDIFF and then inserting that in to the DB against each record every time the grid loads to ensure it is up to date, however... what I cannot work out how to do, is to calculate the total time of all records on the 'Group By' selections as this only gives the option of COUNT for time fields.

Is there a simple way of this, or does the total time need to be converted to seconds to calculate as a SUM and then converted back to time format, and if so, what is the best method within scriptcase?

Thanks in advance

## Comment