convert total minutes to hh:mm

S

Song Su

How to convert total minutes into HH:MM?

If I have 90 minutes, I want to display 1:30
If I have 50 minutes, I want to display 0:50
etc..

Thanks.
 
K

Ken Snell \(MVP\)

Assuming that Mints is the field holding the number of minutes:

Format(Mints \ 60, "0") & ":" & Format(Mints Mod 60, "00")
 
D

Duane Hookom

Divide your number by the number of minutes in a day and then format your
display as time.

=90/(24*60)
 
Top