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?
Jonas Möller Nielsen