Coverting Minutes-Need a remainder function

  • Thread starter Thread starter Michael D. McGill
  • Start date Start date
M

Michael D. McGill

I need to convert a number of minutes to a time. If I have say 662 minutes.
I know I can divide it by 60 to get the hour (11) is there a function in
Access that will give me a remainder? So I would divide 662 by 60 to give me
my hours (11) the remainder of 2 is my minutes so my time is 11:02.

Any Ideas?
Thanks,
Mike
 
The Mod operator is used to find the remainder
From Help
MyResult = 10 Mod 5 ' Returns 0.
MyResult = 10 Mod 3 ' Returns 1.
MyResult = 12 Mod 4.3 ' Returns 0.
MyResult = 12.6 Mod 5 ' Returns 3.
 
Back
Top