How to change the chart display of time

[Jeffrey_Marler]

Is there a way to have this info display in a more useful format like days and weeks?

[Stephen_Li]

@Jeffrey_Marler - could you open one of those number charts and screenshot your setup? In my experience, I have mostly (only?) seen numbers rolled up to weeks/days instead of hours, which is actually annoying IMO. There’s actually an open feedback request to present data as you see it now, so I’m curious if there’s some kind of test being run.

Number formatting of "estimated time" in charts in hours instead of days

I have created a chart with the sum of estimated time for the upcoming month. The idea is to get an estimation of upcoming invoicing. I have one chart for the goal of invoicing and wanted to compare against the estimated invoicing of upcoming tasks. BUT, when I sum the estimated hours, it counts days and hours instead of just hours. So in order to get the correct number I have to do this in my head: number of days * 24 + hours. I wish I could change the number format so the estimation (and othe…

[Jeffrey_Marler]

I have a custom Dwell formula that takes the completed date - created date. Then I have it filtered by date and by the specific tasks I want to get the dwell time for

[Jeffrey_Marler]

I like the way it displays in the list view

[Stephen_Li]

@Jeffrey_Marler - wow, this is super weird but fields like time tracking and estimated time show in list view as xxHyyM but in number chards as weeks/days/hours while formula fields (like yours, confirmed in my own testing) show in list as the reverse. No idea why that’s the case, and I’m not aware of any workarounds to solve. I know that @Richard_Sather has done some cool work with formula fields; maybe he can share some insight on this

[Richard_Sather]

Hey @Stephen_Li , thanks for looping me in here.

@Jeffrey_Marler , here is how to create a formula field that will format time in hours:

Number formatting of "estimated time" in charts in hours instead of days

Note: Not a solution but marked as such to elevate a key reply For all Business, Advanced & Enterprise users (who have the Advanced Editor for Formulas), there is a workaround for you! [image] For all your projects that you are using Asana’s native Estimated or Actual hours fields, do the following for either field: The examples below are for Estimated time, but you can follow exactly the same for Actual time field also. To get results in hh:mm Create a new Formula custom f…

In your particular case, you may need to end up both fields, if you want them displayed on list view in weeks and days, also.

You could tweak the formula to divide the hours by 24 to give you the result in decimal days only. Or divide by 168 (24h x 7d) to give you the result in decimal weeks (but not weeks and days).