# How do you assign hours per week for use in dashboards? **URL:** \ **Category:** Asana In Practice\ **Tags:** projects, tasks\ **Created:** [3 February 2023 02:19 UTC](https://forum.asana.com/t/how-do-you-assign-hours-per-week-for-use-in-dashboards/327762 "2023-02-03T02:19:06Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![anon82267988](https://luna1.co/8d76cd.png) [@anon82267988](https://forum.asana.com/u/anon82267988)\ **Post date:** [3 February 2023 02:19 UTC](https://forum.asana.com/t/how-do-you-assign-hours-per-week-for-use-in-dashboards/327762/1 "2023-02-03T02:19:06Z")
I want Asana to display charts based on Estimated Time using 40 hrs/week. It currently thinks a week is 24\*7. For example, 1040 hours should ideally be 26 wks, but it shows up as 6 wks effort. Any way to set this? ---
**Author:** ![Bastien\_Siebman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/bastien_siebman/32/172354_2.png) [@Bastien\_Siebman](https://forum.asana.com/u/Bastien_Siebman)\ **Post date:** [3 February 2023 07:24 UTC](https://forum.asana.com/t/how-do-you-assign-hours-per-week-for-use-in-dashboards/327762/2 "2023-02-03T07:24:09Z")
> [@anon82267988](#): > > it shows up as 6 wks effort Where does it show up like this? You are using tasks with start and end dates? ---
**Author:** ![anon82267988](https://luna1.co/8d76cd.png) [@anon82267988](https://forum.asana.com/u/anon82267988)\ **Post date:** [10 February 2023 00:05 UTC](https://forum.asana.com/t/how-do-you-assign-hours-per-week-for-use-in-dashboards/327762/4 "2023-02-10T00:05:48Z")
It shows up in the dashboards that way. I have charts plotted based on Estimated Time as an axis. When it shows the number of weeks, that is calculated with 24\*7 hours a week rather than 40 hrs/week that I want. ---
**Author:** ![Emily\_Vogt](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/emily_vogt/32/86487_2.png) [@Emily\_Vogt](https://forum.asana.com/u/Emily_Vogt)\ **Post date:** [18 October 2023 14:52 UTC](https://forum.asana.com/t/how-do-you-assign-hours-per-week-for-use-in-dashboards/327762/5 "2023-10-18T14:52:31Z")
@anon82267988 I’m experiencing this as well, have you found any solutions to view the estimated time in hours rather than days or weeks? ---
**Author:** ![Bastien\_Siebman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/bastien_siebman/32/172354_2.png) [@Bastien\_Siebman](https://forum.asana.com/u/Bastien_Siebman)\ **Post date:** [19 October 2023 10:13 UTC](https://forum.asana.com/t/how-do-you-assign-hours-per-week-for-use-in-dashboards/327762/6 "2023-10-19T10:13:33Z")
With the new Formula field you can better decide on units. @Richard_Sather does it apply here? ---
**Author:** ![Richard\_Sather](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/richard_sather/32/276096_2.png) [@Richard\_Sather](https://forum.asana.com/u/Richard_Sather)\ **Post date:** [19 October 2023 11:22 UTC](https://forum.asana.com/t/how-do-you-assign-hours-per-week-for-use-in-dashboards/327762/7 "2023-10-19T11:22:39Z")
Yes, the below advanced formula field should work. It will convert estimate time into number of weeks based on 40hrs per week. ![image](https://us1.discourse-cdn.com/asana/original/3X/e/6/e6e9fd798715f0eda66f3943dcc22251c92068bd.png) 💡 The 2400 number is derived by 60 \* 40hrs/week. So if you have 35hr/week then you should do 60\*35= 2100 Therefore replace 2400 with 2100 in the formula 😉 Then in your dashboard’s chart, use the ‘Weeks’ formula custom field as your measure in a Donut, or Y-axis in a Column or Line chart. ---
**Author:** ![system](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/system/32/276370_2.png) [@system](https://forum.asana.com/u/system)\ **Post date:** [30 May 2025 18:55 UTC](https://forum.asana.com/t/how-do-you-assign-hours-per-week-for-use-in-dashboards/327762/8 "2025-05-30T18:55:00Z")