Rounding Up Time

[Renee]

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

 

[John]

Renee,

Try using the Round function. Something similar to (Round[number1])

John

 

[Duane Hookom]

Try something like:
Round(([your value]+.249999) * 2,0)/2

 

[James A. Fortune]

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

See:

http://groups.google.com/group/microsoft.public.access/msg/9614be58d0485dd0

Try:

-Int(-X / 0.5) * 0.5

James A. Fortune
[email protected]