Round number to nearest .25 1

[juliam921]

Does anyone know how I can take a value and round it to the nearest .25? I have values like 1.33 and .40 and 5.20 and they need to be in quarters (1.25, .5, 5.25). It is a time entry value and they need to be displayed in the nearest quarter hour increments.
Thanks.
Julia

 

[skrandel]

=Round(<Time>*4 ,0)/4

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[juliam921]

Thank you! I feel stupid for not thinking of that!
Julia

 

[skrandel]

Don't feel stupid. I worked on it for a while. How 'bout a thank you vote.

This board needs more voting.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[juliam921]

How do you do that?

 

[skrandel]

The little link at the bottom of each post. It says Thank whomever for this valuable post.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com