Mar 17, 2006 #1 mikeyb540 Programmer Joined Jul 7, 2003 Messages 173 Location US Hello, Trying to figure out how to round 45min to the nearest hour 60min. I have tried Round(45*24,0)/24 Thanks in advance.
Hello, Trying to figure out how to round 45min to the nearest hour 60min. I have tried Round(45*24,0)/24 Thanks in advance.
Mar 17, 2006 1 #2 Hypetia Programmer Joined Feb 26, 2003 Messages 1,279 Location US [tt]Dim Minutes As Long Minutes = 45 Minutes = ((Minutes + 30) \ 60) * 60[/tt] Upvote 0 Downvote