I'm made a timesheet for work. The problem is that employees come in early - so they sign in prior to 9am. When they work until 5, the sheet caluclates the 10 or 15 min as overtime... the problem is, our staff only get PREapproved overtime, so these early mornings are adding up when they shouldn't be.
I would like to show the actual time in with another column, beside it that displays either 9am if it before 9, or the actual time in if it is after 9. I'd like to do the same, for actual time out - if it is after 5pm, to display 5
Can anybody help?
J
Bookmarks