AnsweredAssumed Answered

Summing up time field (in minutes) to give HH:MM result - how?

Question asked by MaximilianDeCourten on Jan 29, 2013
Latest reply on Jan 29, 2013 by philmodjunk

Title

Summing up time field (in minutes) to give HH:MM result - how?

Post

      

     I'm struggling with a time summary issue here: I have one time field (= duration in minutes) per record in a duration table and then want to summarize the total time spent from a number of records in a different table/layout using the Portal Tool. 

     I created in the duration table the calculation field summing up the time field - but have a problem there, the sum function doesn't quite work with only one variable/field!?;

     alternatively I used a Summary field type which sort of works except giving me a formating challenge: minutes are summed up like 35 +45 = 80 instead of 1:20 - or I get the 35 minutes translated into 35x60 hrs etc.

     So: how do I sum up one time field (do I use calculations or summary) and then how do I format the result from mm to hh:mm?

Outcomes