Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar chart change to hours

Hi again,

I have created a bar chart and here I have minutes showing. I'd prefer to see this in total hours and mins...How can I do that?

Thanks.

2015-10-03_2151.png

1 Reply
MK_QSL
MVP
MVP

You can convert minutes to hours and minutes as below

=interval(YourMinuteField/24/60,'hh:mm')

or

=interval(YourExpressionWhichisGivingMinute/24/60,'hh:mm')