# Wildcard usage in report builder
**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2000-08-11 11:44 UTC
**Views:** 564
**Replies:** 3
**URL:** https://www.epiusers.help/t/wildcard-usage-in-report-builder/750
---
## Post #1 by @system
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:
>to round payhours to the nearest 15 minute increment. How can a wildcard
be
>used in this formula: IIF(PayHours >= 8.0 and PayHours < 8.25,8.0,0) to
>replace the 8.0, 9.0, 10., and so on?
Multiply by 4, truncate, divide by 4
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]
I am writing a weekly attendance audit report for importing into ADP. I want
to round payhours to the nearest 15 minute increment. How can a wildcard be
used in this formula: IIF(PayHours >= 8.0 and PayHours < 8.25,8.0,0) to
replace the 8.0, 9.0, 10., and so on?
Thanks
Dan Shallbetter
States Electric Mfg.
---
## Post #3 by @system
At 10:36 AM 8/11/2000 , you wrote:
>to round payhours to the nearest 15 minute increment. How can a wildcard be
>used in this formula: IIF(PayHours >= 8.0 and PayHours < 8.25,8.0,0) to
>replace the 8.0, 9.0, 10., and so on?
Multiply by 4, truncate, divide by 4
integer(PayHours * 4) / 4
You'll have to check for the proper name of the INT() function in R.B.
-Wayne
Thank you Wayne works great.
Dan
-----Original Message-----
From: Wayne Cox [mailto:
wmc@...]
Sent: Friday, August 11, 2000 9: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 wildcard
be
>used in this formula: IIF(PayHours >= 8.0 and PayHours < 8.25,8.0,0) to
>replace the 8.0, 9.0, 10., and so on?
Multiply by 4, truncate, divide by 4
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]