3 Replies Latest reply: Jun 12, 2013 7:46 AM by jagan mohan rao appala RSS

    Convert seconds in decimal hour

    Giorgia Michieli

      Hi all,

      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?