Need Time Based Sum In Aggregate Function

[vijay@spinetechnologies]

I would like to calculate Sum of time in (hh.MM) format

Work Hours
10.30
01.45
02.30

Total Work Hours : 14.45

How I can achieve it. Kindly guide us

[paramvir]

You would need to write a custom aggregate.

Here is the example of custom aggregate: https://paramquery.com/pro/demos/group_rows_custom_summary

Code: [Select]

agg.sumdate = function(arr){
//arr is array ['10.30', '01.45', '02.30']
arr.forEach(function(val){

});
return sum_of_hr_and_min;
}

Please let me know if you need help with logic of the method.