Help convert minutes into hours and minutes as average

[denwo2010]

Hi,

I have a column that shows total minutes, I want to create a Gauge (LED) that would convert this to a Average in the format of HH:MM, can this be done?

Thanks

[johnw · Accepted solution]

Well, since an LED gauge doesn't display the ":", no. But to get an interval, divide the minutes by 1440, the number of minutes in a day. The underlying numeric value for an interval, time or date is days. And I wouldn't use an LED anyway. Sure, it's "clever" to make your duration look like a clock, but it's much easier to read at a glance if you just use plain old text. So just a slight modification to your text box:

=interval(avg(DurationMins)/1440,'h:mm')

[denwo2010]

thanks John, do you know what the best font to use to have it look like a LED? thanks

[johnw]

Not off hand. I'd have to experiment with all the available fonts, which I'll leave to you.

[#5]

denwo2010 wrote:
thanks John, do you know what the best font to use to have it look like a LED? thanks<div></div>

http://www.dafont.com/ds-digital.font