Formula that converts the sum of a "Time" field from 7.50, to a proper 7hrs 30min display

[DB7]

Is there a formula that can do this? Any help is appreciated. Thank you.

[pbaldy]

?int(7.5) & "hrs " & (7.5-int(7.5)) *60 & "min"
7hrs 30min

[aytee111]

Not sure about the 7.5 being a "time" field? This code works if it is a double:

Dim aa As String, mins As Double
mins = 7.5 * 60
aa = Int(mins / 60) & " hours " & Format(mins Mod 60, "00") & " minutes"

[Micron]

Int(7.5) & "hrs " & (7.5-Int(7.5))*60 & "min"

7hrs 30min

Sorry. I should pay more attention to what's already been posted, or refresh the page if I take a break somewhere between starting and finishing.

[DB7]

Thank you Paul! This is very helpful - I will try it out!

[DB7]

I apologize aytee111, you are exactly right - my mistake. I was talking about a double field.
Thanks for the formula - Ill try it out!

[DB7]

Thank you Micron! No problem about the extra post - It confirms what I needed. Everyone is so willing to help and I appreciate all of the replies.
I will try the formula. Thanks again!