AnsweredAssumed Answered

How to format a summary field using a calculation ?

Question asked by wladdy on Mar 17, 2011
Latest reply on Mar 25, 2011 by philmodjunk

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.

Outcomes