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

[Brad]

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

 

[Allen Browne]

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