Converting numeric values into time values

[velcrowe]

I have a travel time database that should tally the number of minutes traveled and convert them into a time (hours and minutes). I, however, am having difficulty converting the numeric values cleanly. Is there anyway to convert 102 minutes + 100 minutes + 110 minutes = 312 minutes to 5 hours and 12 minutes cleanly? I need to take averages of time traveled and hours worked but cannot do this correctly. Thank you for any help in advance.

 

[mresann]

(SumTotalMinutes)\60 gives you the total hours, while
(SumTotalMinutes) Mod 60 gives you the total minutes.

Format appropriately.

 

[raskew]

Hi -

Example from debug (immediate) window:

x = 312
y = x\60 & " hour" & iif(x\60 <> 1, "s ", " ") & x mod 60 & " minute" & iif(x mod 60 <> 1, "s", "") 
? y
5 hours 12 minutes

HTH - Bob