MOD Function or how to convert total minutes to hours and minutes

simple question.. maybe
i have a total number of minutes and i want to convert to
hours and minutes.. example 125 total minutes i want it
to be 2 hours and 5 minutes so i figured out how to change
the minutes to hours
i did
= INT(([duration])/60) which gave me 2

how do i do the same with the remaining minutes i have
tried
= MOD (([duration]),60) but cant get it to work

FYI duration is the field that has the total minutes'
thanks you
brad

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

For an explanation, see:
Calculating elapsed time
at:
http://members.iinet.net.au/~allenbrowne/casu-13.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Brad" wrote in message
...
simple question.. maybe
i have a total number of minutes and i want to convert to
hours and minutes.. example 125 total minutes i want it
to be 2 hours and 5 minutes so i figured out how to change
the minutes to hours
i did
= INT(([duration])/60) which gave me 2

how do i do the same with the remaining minutes i have
tried
= MOD (([duration]),60) but cant get it to work

FYI duration is the field that has the total minutes'
thanks you
brad