This content has been marked as final. Show 3 replies
I have a field in the format seconds and I need to put it in a pivot table (I have to sum hours). Convert it to hh: mm: ss is not a problem (sum (Interval (hour_field / (3600 * 24), 'hh: mm: ss')))
but I would like to convert it to decimal hours.
For example, if I have 4 hours and 30 minutes I dont want to see 4.3 but I want to see 4.5. Is it possible?