Number Chart Format

[Lou_Wesely]

Good Morning,

I have a custom field that calculates the time elapsed between two date fields. The average of those fields provide result in weeks/days. (expected result)

However, when I try to create a number chart, it displays the calculation in hours/minutes.

Any thoughts on how I can get this chart to display in weeks/days?

[Stephen_Li]

@Lou_Wesely - agreed that it’s confusing that the data presents differently in different places. Check out this post for some guidance on workarounds:

How to change the chart display of time

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: 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).