AnsweredAssumed Answered

How do I display time in hours and minutes after a calculation?

Question asked by jonasmn on Mar 31, 2018
Latest reply on Jul 10, 2018 by jonasmn

I have two time fields, "time_before" and "time_after" plus the field "elapsed_time". The field elapsed_time is a calculation from the two previouse fields "time_after - time_before". This calculation has been defined where I handle the fields in the tables. Basically the calculation is perfromed alright, the time is entered as 14:30, etc. But the elapsed_time is displayed in SECONDS, and I would like to have it in the format hh:mm. How do I get this?

 

 

Regards

Jonas Möller Nielsen

Sweden

Outcomes