I need to create a spreadsheet that will record tardies, excused call-ins and unexcused call-ins for employees.
For example, one tardy = 0.5 points, one excused call in = 1 point, and one unexcused call in = 3 points.
I plan to record these figures monthly. If I enter that Amy was tardy 7 times with one unexcused call-in that month, I want Excel to show that she has accumulated 6.5 points [(0.5 x 7) + 3].
I have attached an example spreadsheet. I'm new to excel so any help is appreciated!! Thank you!
ABSENT.xlsx
Bookmarks