I am still trying to come up with a formula that will round the time if you punch in or out 6 minutes before the hour or six minutes after the hour example you punch in or out at 8:24 That's 8:30 if you punch in or out after 8:36 that's 8:30 anything after the 6 minutes or before the 6 minutes is the real time. example 8:23 is 8:23 or 8:37 is 8:37
Please email and I can send you the timecard spreadsheet that I need it to work with.
Bookmarks