Convert Minutes to HH:MM

  • Thread starter Thread starter DF
  • Start date Start date
D

DF

I have elasped time in minutes. How do I get it into
Hours:Minutes format?

I also have it in total seconds if that works better...

Thanks!
 
Thanks for your quick response, Bruce!

This works...I think. But the "hh:nn" turns into "Short
Time" when I save the query. Should that be a problem?

Dee
-----Original Message-----
I have elasped time in minutes. How do I get it into
Hours:Minutes format?
Click to expand...

Try:

Format(Int([Minutes]/60) & ":" & [Minutes] mod 60, "hh:nn")

--
Bruce M. Thompson, Microsoft Access MVP
(e-mail address removed) (See the Access FAQ at http://www.mvps.org/access)within the newsgroups so that all might benefit.<<


.
Click to expand...
 
Thanks for your quick response, Bruce!
This works...I think. But the "hh:nn" turns into "Short
Time" when I save the query. Should that be a problem?
Click to expand...

As long as the display remains as you want it, it won't be a problem.

:-)
 
Back
Top