Share
ReportI have a chart which shows time spent in minutes, is there a way to use label format to convert it to hours?
You’re offline. This is a read only version of the page.
155
I have a chart which shows time spent in minutes, is there a way to use label format to convert it to hours?
Clever solution Steve! Like it!
Per my experience, there is no direct way to convert it to hours in the Chart.
Thank you for the idea, but I was hoping to be able to do it without creating a new field.
I thought that since the functionality was there to automatically convert minutes to hours on the view, there would be the same functionality on the chart as well.
Hi,
You can create a calculated column which type is Decimal Number. And use your minute column/60 to set its value.
Something like this:
1. Create a calculated column which type is Decimal Number
2. Edit the action in the calculation.
3. Use this column to replace your minute column in your chart.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (