Converting Minutes to hh:mm format

[renee_ld]

In a query I used the function datediff to calculate the number of
minutes between two time periods on a given day. This function returned
the number of minutes as a long integer data type. I then formatted the
summed number in my report footers using:

=Format(Int(Sum([Total Time])/60),"00") & ":" & Format(([Total Time]
Mod 60),"00")

This displayed my number in hh:mm format.

I tried using a similar format in the detail portion of my report.

=Format(Int([Total Time]/60),"00") & ":" & Format(([Total Time]
Mod 60),"00")

However, I receive an #error as the result in my report. Formatting the
field into "short time" returns 0:00. I believe that's because Access
converts the number into the entire date. For example, 205 minutes
equates to 7/23/00 12:00 am.

Thanks,

Any suggestions on how I can format the detail line of my report to
display the hh:mm format?

Thanks,

Renee
--
Posted via http://dbforums.com

[renee_ld]

I found I missing a "(" in my formula.

=Format(Int(([Total Time])/60),"00") & ":" & Format(([Total Time]
Mod 60),"00")

Thanks for checking,
--
Posted via http://dbforums.com