Classroom Attendance with Forms and Sheets and Fancy Formulas to track student attendance by month

[@CarlaArias-Chavez]

Great formulas! I have a very similar sheet and was wondering if you had any advice on how to also calculate tardies with the timestamp?

[@redtailfanschool]

I guess if you are collecting the attendance in real time as students arrive, you could calculate a T if the timestamp was later than when they were supposed to check in. This formula would put a T if this time is after 8 am; =IF(TEXT(A2, "HH:MM") > TEXT(TIME(8, 0, 0), "HH:MM"), "T", "P")

[@andersonmenezes6374]

I loved it. Congrats.