I have a spreadsheet containing timekeeping data - hours worked, vacation leave, sick leave, etc.

Our policy is that all entries must be in increments of 0.25. Due to a technical glitch, we had to 'turn off' a setting that ensures entries are in 0.25 increments. Now, I need to find out if any of the entries are not in 0.25 increments.

Can anybody think of a formula that can search a row of data (for each employee on the spreadsheet) that will determine if any of the pay code entries within the row were not an increment of 0.25?

For example

- one row might contain 74.5 hrs worked and 5.5 vacation hours; this is okay because both values are in increments of 0.25.
- However, if someone had 74.5 hours worked and 4.87 hours of vacation, I need to find the 4.87 usage because it's not in an increment of 0.25.

`=mod(A1,.25)`

- anything not 0 is off – Raystafarian Jan 4 '16 at 13:53