Make the time tracking column work with sprint burndown for actual time spent

I tried to resolve this issue by creating a formula column to get hours from the time tracking column, but the burndown seems to only work with the number column. I tried an automation but there is no free automation that copies the data from a formula column to number column.

Hi @paulzyto :wave:

I am happy to announce that we have released the Time in Status app, which track time the Item has spent in each workflow status without logging hours. So you can monitor how fast the Item moves between statuses using app with reports.
You’ll get user-friendly data on the board in a few seconds.

Also you will be able to track how much time your issue spends in each status and much more by generating 3 types of reports:

:chart_with_upwards_trend: And use charts to visualize your reports a sample of a certain number according to time range/item range, or a single item:

  • Pie Charts
  • Bar Charts
  • Area Charts

The app is also available in the format of board integration.

You can try it on the Monday Marketplace and share your experience with us.
Hope you find this app helpful.