Dan, Wayne's solution will work -- the INT() is in fact Truncate(number,x)

where x is # of decimal places; in your case should be zero. This formula

will round down to the next lower quarter hour (15 minutes).

Truncate( PayHours * 4, 0 ) / 4

If you want to round to the nearest 15 minutes use this:

Truncate(( PayHours + .125 ) * 4, 0 ) / 4

Good Luck

Jim Stetter

-----Original Message-----

From: Wayne Cox [mailto:wmc@...]

Sent: Friday, August 11, 2000 10:48 AM

To: vantage@egroups.com

Subject: Re: [Vantage] Wildcard usage in report builder

At 10:36 AM 8/11/2000 , you wrote:

integer(PayHours * 4) / 4

You'll have to check for the proper name of the INT() function in R.B.

-Wayne

[Non-text portions of this message have been removed]

where x is # of decimal places; in your case should be zero. This formula

will round down to the next lower quarter hour (15 minutes).

Truncate( PayHours * 4, 0 ) / 4

If you want to round to the nearest 15 minutes use this:

Truncate(( PayHours + .125 ) * 4, 0 ) / 4

Good Luck

Jim Stetter

-----Original Message-----

From: Wayne Cox [mailto:wmc@...]

Sent: Friday, August 11, 2000 10:48 AM

To: vantage@egroups.com

Subject: Re: [Vantage] Wildcard usage in report builder

At 10:36 AM 8/11/2000 , you wrote:

>to round payhours to the nearest 15 minute increment. How can a wildcardbe

>used in this formula: IIF(PayHours >= 8.0 and PayHours < 8.25,8.0,0) toMultiply by 4, truncate, divide by 4

>replace the 8.0, 9.0, 10., and so on?

integer(PayHours * 4) / 4

You'll have to check for the proper name of the INT() function in R.B.

-Wayne

[Non-text portions of this message have been removed]