Mar 17, 2006 #1 mikeyb540 Programmer Jul 7, 2003 173 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 Feb 26, 2003 1,279 US [tt]Dim Minutes As Long Minutes = 45 Minutes = ((Minutes + 30) \ 60) * 60[/tt] Upvote 0 Downvote