This is a discussion on how to calculate late and under time within the Excel Questions forums, part of the Question Forums category; Hi everyone! Need your expertise in this field. I have this individual time sheet that can compute for late and ...
Need your expertise in this field. I have this individual time sheet that can compute for late and under time and the applied leave with pay. May problem is that I realized that i didn't include the unpaid breaks (12:30pm to 1:30 pm). Because this I can't think or solve the right formula to include the said unpaid breaks. I hope you could help me solve this matter.
Here's the flow of the time sheet:
work starts at 8:30 am and end at 5:30 pm with the unpaid break at 12:30 pm to 1:30 PM. I can apply for a paid leave either half day (4 hours) or whole day (8hours)
A1 = time in
B1 = time out
C1 = applied leave in AM
D1 = applied leave in PM
E1 = late
F1 = under time
In column A,B,E and F format I use is hh:mm, while on column C and D is in number format.
Thank you in advance and more power in the forum.