Is there a formula that can do this? Any help is appreciated. Thank you.
Is there a formula that can do this? Any help is appreciated. Thank you.
?int(7.5) & "hrs " & (7.5-int(7.5)) *60 & "min"
7hrs 30min
Not sure about the 7.5 being a "time" field? This code works if it is a double:
Code:Dim aa As String, mins As Double mins = 7.5 * 60 aa = Int(mins / 60) & " hours " & Format(mins Mod 60, "00") & " minutes"
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.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Thank you Paul! This is very helpful - I will try it out!
I apologize aytee111, you are exactly right - my mistake. I was talking about a double field.
Thanks for the formula - Ill try it out!
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!