R Renee Feb 11, 2010 #1 How do I round up a time in increments of 30 mins? Example: 0.75 Hr = 1.0 hour, 1.15 = 1.50 hour , 5.10 hour= 5.50
How do I round up a time in increments of 30 mins? Example: 0.75 Hr = 1.0 hour, 1.15 = 1.50 hour , 5.10 hour= 5.50
J John Feb 11, 2010 #2 Renee, Try using the Round function. Something similar to (Round[number1]) John
J James A. Fortune Feb 11, 2010 #4 How do I round up a time in increments of 30 mins? Example: 0.75 Hr = 1.0 hour, 1.15 = 1.50 hour , 5.10 hour= 5.50 Click to expand... See: http://groups.google.com/group/microsoft.public.access/msg/9614be58d0485dd0 Try: -Int(-X / 0.5) * 0.5 James A. Fortune (e-mail address removed)
How do I round up a time in increments of 30 mins? Example: 0.75 Hr = 1.0 hour, 1.15 = 1.50 hour , 5.10 hour= 5.50 Click to expand... See: http://groups.google.com/group/microsoft.public.access/msg/9614be58d0485dd0 Try: -Int(-X / 0.5) * 0.5 James A. Fortune (e-mail address removed)
