I have a Dashboard with an Index Widget to a field in a table named completion time which is formatted as (for example) 04448 where the first character is hours, second 2 is minutes and the last 2 is seconds and is calculated and inserted into the database by using a sc_timediff macro on each record.
The index widget is calculating the average per day and displaying the exact record which is 04448, id like to format it as 0H44M48S, the formatting only seems to allow for currency or integer / decimal, not time.
Any ideas on how i can achieve this?