themurph2000
Fat, drunk, and stupid
- Local time
- Today, 11:22
- Joined
- Sep 24, 2007
- Messages
- 181
I've seen similar threads for this before, but not ones that specifically meet my issue.
I have a Database that takes the scan of an employee's badge and marks the time by default. What I want to do is set up a field where, if the scan is made within 10 minutes before up to 20 minutes after the start of a shift time, that field will automatically place it at the shift start time; otherwise, it records the time the record was entered.
In other words, if someone was scanned in at 6:52 AM, the extra field would record 7AM, which is the start of the shift. Same if the scan was at 7:18 AM. But if it was at 7:32 AM, then 7:32 AM would be recorded.
Any thoughts? Anyone? Anyone? Bueller? Bueller?
I have a Database that takes the scan of an employee's badge and marks the time by default. What I want to do is set up a field where, if the scan is made within 10 minutes before up to 20 minutes after the start of a shift time, that field will automatically place it at the shift start time; otherwise, it records the time the record was entered.
In other words, if someone was scanned in at 6:52 AM, the extra field would record 7AM, which is the start of the shift. Same if the scan was at 7:18 AM. But if it was at 7:32 AM, then 7:32 AM would be recorded.
Any thoughts? Anyone? Anyone? Bueller? Bueller?