I IanT Registered User. Local time Today, 21:18 Joined Nov 30, 2001 Messages 191 Jun 20, 2002 #1 I want to convert minutes to hours. I have tried minutes / 60 but this shows incorrect minutes i.e. 165 min = 2hr75min Does anyone no how to do this so the 75 is 45 min. Thanks in advance
I want to convert minutes to hours. I have tried minutes / 60 but this shows incorrect minutes i.e. 165 min = 2hr75min Does anyone no how to do this so the 75 is 45 min. Thanks in advance
R rich.barry Registered User. Local time Today, 21:18 Joined Aug 19, 2001 Messages 176 Jun 20, 2002 #2 Format(165 / 1440, "hh:nn") 1440 is minutes per day
J Jon K Registered User. Local time Today, 21:18 Joined May 22, 2002 Messages 2,209 Jun 20, 2002 #3 Or you can get the string "2 hr 45 min" with this: Int(165/60) & " hr " & 165 Mod 60 & " min" where 165 Mod 60 gives you the remainder of 165/60 Last edited: Jun 20, 2002
Or you can get the string "2 hr 45 min" with this: Int(165/60) & " hr " & 165 Mod 60 & " min" where 165 Mod 60 gives you the remainder of 165/60
