Time conversion

  • Thread starter Thread starter Jane
  • Start date Start date
J

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.
 
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.
 
Back
Top