Rounding & Sum

I am trying to get something to round to a quarter of an integer. So
1.25 or 2.5 or 4.75. Thing like that. I have gotten my rounding to
get to different decimal places, but I cannot seem to get it to round
to the quarter of a place. It is for keeping track of hours.

In that same note I want to keep track of hours on different projects
I am working on. So I am putting all the project info in and have it
set up with a field that is the sum of hours per day spent on a
project. How can I make sums that sort by projects. That way I get a
report with the total number of projects and the number of hours spent
on each.

Re: Rounding & Sum

> I am trying to get something to round to a quarter of an integer. So
> 1.25 or 2.5 or 4.75. Thing like that. I have gotten my rounding to
> get to different decimal places, but I cannot seem to get it to round
> to the quarter of a place.

Multiply your number with 4.
Round it so that it's integer.
Divide the result by 4. You get your original number, but roundet to
quarters.

--
http://clk.ch