convert total minutes to hh:mm

  • Thread starter Thread starter Song Su
  • Start date Start date
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.
 
Assuming that Mints is the field holding the number of minutes:

Format(Mints \ 60, "0") & ":" & Format(Mints Mod 60, "00")
 
Divide your number by the number of minutes in a day and then format your
display as time.

=90/(24*60)
 
Back
Top