Hi everyone!

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.