Convert Minutes to HH:MM

[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!

 

[Bruce M. Thompson]

I have elasped time in minutes. How do I get it into

Hours:Minutes format?

Try:

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

 

[Bruce M. Thompson]

I have elasped time in minutes. How do I get it into

Hours:Minutes format?

Try:

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

 

[df]

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?

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.<<


.

 

[Bruce M. Thompson]

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?

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