How to display a duration column as hours

In Wink Reports duration values are formatted as "days:hours:minutes". For example "1:6:30" is 1 day, 6 hours and 30 minutes.

Often you would rather have this value as just the number of hours. In our example we want to see 30.5 hours.

To do this, go in the designer to the Columns section and change the formatting of the duration column to "Numeric (Decimal 2)". This will show the number of days in the column as a decimal.

For example 1.27 days.

We can convert it to hours by simply multiplying the data source value by 24.