Hello everyone. First time posting. Actually first day being a member.
This might have been asked before. Point me in the right direction if so. I have a spreadsheet that we keep track of one of our employees vacation, overtime and attendance. I attached the file. I am trying to track overtime for both current week and last week. The current week overtime is in cell N5 and previous week is in cell N4. The formula in cell N5 works if I only do January. But when I try to include more than one month it gives an error. If the supervisor puts in "OT" in the code field, it will add it to the overtime. Am I over thinking this? Is there a better way?
Thanks.
Vince
Bookmarks