Hi. I have an attendance tracker created for work, on a weekly basis I need the ir attendance percentage. Im sure its pretty simplistic of a formula, and whoever gives me this answer is my God forever!
Basically, its a 5 day work week. Their attendance is marked A= Absent(0%), P=Present(20%), LS=Late Start(10%), LE=Leave Early(10%). I just need to add up the 5 days for each worker, and input it into another cell with their attendance percentage. So essentially they work 4 days = 80% attendance...3 days = 60%...etc.
If I confused anyone and you need to see a spreadsheet to understand, just ask.
Thanks SO much in advance!