Hi there ! I'm trying to create a template wherein the employees attendance can be monitored.
What I want to do is to have a formula in column S so that if there is a time value in columns M and N, and it equals the value on columns K and L, respectively, then value on column S, shows as "Present".
Then if there is a time value in columns K and L but there are no entries in columns M and N, then column S shows as "Absent".
If columns K and L shows as "VL" and columns M and N are blank, then column S shows as "VL".
If (N:N-M:M)<(L:L-K:K), then column S shows as "Late".
I hope someone can understand what I am trying to do.
I have attached the file so that you can check it.
Bookmarks