Hi Folks,
I have set up a dashboard which is pulling in time tracking information, however it is displaying the number as seconds rather than hours, so obviously every looks way over capacity - has anyone come across this and know of a workaround?
In the below example - 12 hours have been entered against the task, but it’s coming up as 43,200 - which is 12 hours in seconds.
Hi @asc-ak, try this:
Add a formula column to your General Tasks board and calculate tracked hours. If you would like to control the number of digits shown, it should look something like this:
ROUND({Time Tracking#Hours},1)
Then change Effort and Capacity in the Workload Widget settings to the new formula column.
Thanks @Sjurd I was playing around with that workaround last week and works well from the hours perspective. Only thing is, it would mean I would need to set up tasks once a week for each person in order to get accurate output, which will add up over time as the team grows.
Just wondering if there is a way that the native dashboard showing as seconds rather than hours can be fixed as this would remove any extra admin. Is this a bug Monday Team that can be looked in to?
@asc-ak have you tried adding the Time Tracking widget to your dashboard?
As i see it, the Workload Widget is for workload planning where you select timeline + people + planned effort columns. The Time Tracking Widget will show registered time on every person on a weekly, monthly or daily basis.
