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?
- 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.