I'm stumped on how to write a formula to accomplish this. Hopefully someone can help.
My start time at work is 7:00 AM. We have a 10 minute leeway either side of 7:00. If you clock in at 6:53, it rounds to 7:00. Punch in at 7:05, it rounds to 7:00. Punch in more than 10 minutes either side of 7:00 (6:45 for example) and there is no rounding. How can I write a formula to apply this rounding if I'm within the 10 minute rule?
(INFO - the "rounded" time can be shown in another cell, it doesn't have to be adjusted in the original entry)
This message was edited by gmeeks on 2002-09-26 15:05
My start time at work is 7:00 AM. We have a 10 minute leeway either side of 7:00. If you clock in at 6:53, it rounds to 7:00. Punch in at 7:05, it rounds to 7:00. Punch in more than 10 minutes either side of 7:00 (6:45 for example) and there is no rounding. How can I write a formula to apply this rounding if I'm within the 10 minute rule?
(INFO - the "rounded" time can be shown in another cell, it doesn't have to be adjusted in the original entry)
This message was edited by gmeeks on 2002-09-26 15:05