AnsweredAssumed Answered

Change Minutes to Hours and Minutes?

Question asked by FarfelKnabe on Jul 25, 2011
Latest reply on Jan 29, 2013 by MaximilianDeCourten


Change Minutes to Hours and Minutes?


Hi all,

I have a newbie question about time?

I have two tables, each has a running time field, 15 minutes, 55 minutes and so on...

In my main layout I have a field with a calculation that adds these two field together - presenting the result as 70 minutes.

I would like that field to show the result in HH:MM - 01:10.

I have tried to fidle with the scripts and the different time functions but to no success.