Formatting time in a report

[justlearnin]

I have a report that I am running from a query. The time in the tables is
just a general number, since most of the time the time is entered as '15',
'30', all depending on the length of time. When I run the report, I need it
to calculate the time for me. So if the total is 150, it should put 2:30. How
do I do this?

 

[Duane Hookom]

Divide the sum of your time field by 1440 (the number of minutes in a day).

 

[John Spencer]

I would use the following formula.
Assumption: Time is entered as a duration of minutes with no fractional
entries.

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

First part is integer math ( reverse slash). You could also try
Int(TotalMinutes/60).