1 Reply Latest reply: May 10, 2013 10:13 AM by Gysbert Wassenaar RSS

    Covert hh:mm:ss to Days hh:mm:ss

      Hi,

       

      I have a field called Fix_date_true, which currently pulls out a time format such as 73:01:24 (hh:mm:ss).  However I want to be able to convert this date into Days hh:mm:ss, so the above will show : 2 01:01:24 (This will shows 2 Days 01 Hour 01 Minutes and 24 Seconds).  Is this possible in an Expression.

       

      Regards,

       

      Jon Ditchfield