9 Replies Latest reply on Mar 25, 2011 4:17 PM by philmodjunk

    How to format a summary field using a calculation ?

    wladdy

      Title

      How to format a summary field using a calculation ?

      Post

      Field 'Duration_m' contains integers representing minutes.

      Field 'Duration_dhm' is a calculated field using a custom function to display 'Duration_mm' in a text mentioning when relevant days and hours.

      For example, if 'Duration_m'=1550 then 'Duration_dhm' will contain the text '1 day 1 hour 50 minutes'.

      I have various summary fields based on 'Duration_m'. How could I display them in the 'Duration_dhm' format ?

      Many thanks. W.