I'm a college teacher. I have created a presence sheet. I have a calculation:

C3+D3+E3+F3+G3+I3+J3+K3+L3+N3+O3+P3+Q3+R3+S3+T3
(H3 is not included because it is spring break.)

That gives me a total of 48 hours of presence.

First I want to include rubriks:
"ex" = presence excused = 3 hours
"x" = absence = 0 hours
"l" = late = 2.9 hours

Second, I would like to make the maximum for each cell = 3

Can you help please. I think this is the first time I have used Excel for anything serious.
John