Time conversion

[Jane]

I have a simple database which allows engineers to log time spend on support
calls. The time is logged in minutes (thought this would be easier than
hours:mins). Each form displays the total amount of time spend so far and I
would like to show this total in hours/minutes both on the form footer and
the report.

Any ideas gratefully received.

 

[Wayne Morgan]

You just need to "reformat" the data back to hours and minutes.

Possible ControlSource for textbox.

=[TotalMinutes]\60 & Format([TotalMinutes] Mod 60, "\:00")

The first back slash if for "integer division", the second is telling the
format function to display the ":" as a just a display character.