Hi there everyone!

Need your expert help in my file.

Am working on my time sheet that needs to compute for the late and under time. My work starts at 8:30am and ends at 5:30pm. With unpaid break at 12:30 pm to 1:30 pm. So far what I have is that it can compute for the late and under time but is includes the unpaid break. How can solve this?

A1= long date
B1= time in
C1= time out
D1= late
E1= under time

Thanks