Summing up time field (in minutes) to give HH:MM result - how?
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?