I am having trouble getting the sum of a column from my data table.
I have this table:
and I want the results to look like this:
I want to remove the multiple names and get the sum of the duration column for that specific name. My problem is I’m not sure of the syntax for getting the sum of DURATION/TIMESPAN. I tried converting into double as well but no luck.
I’m currently using this:
but it gives me this error:
Any assistance would be greatly appreciated.