I have used math to convert dates into durations.
I also stitched together the hour and minute calculations with a template column.
I want to add multiple durations for hours and minutes per user.
Using a relation and lookup for each user I am able to gather up the multiple durations for each individual but I am unable to ROLLUP and SUM due to the column being a template rather than a number.
Please advise.
Rollup the math column instead of the template column, and then convert the rollup value for display.
1 Like