As a duration custom column user
I need to aggregate duration by project down to the second
So that I can run reports directly in Wrike, without exporting to Excel first
We have a custom column to track something in minutes and seconds. I can manually type 3m 45s and it will save (which is useful, in itself) but the Project Aggregation SUM does not calculate seconds. I also will need to use calculated fields in reports to divide this duration column by the work log data (#h #m). Ideally this feature would normalize everything as seconds, then recompile them to minutes.
My current workaround is to export the data out of Wrike, duration format "#m #s" - I paste the task column and duration column into my excel spreadsheet. In my excel spreadsheet I have a column to extract the number before the "m" and another column to extract the number before the "s".... then add those up as seconds. I then divide by the worklog, normalized as seconds using similar columns to pull apart "#h #m"- then convert it all back into minutes.
If I could at least perform operations on the data (SUM by project) I would be able to cut out a big middle step for my reporting needs.