convert total minutes to hh:mm

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

 

[Ken Snell \(MVP\)]

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

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

 

[Duane Hookom]

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

=90/(24*60)