Project Clock Out Time in Employee Time Sheet

I want excel to project a "clock out time" if we already know the rest of the days ins and outs. I want it to tell me what time I would need to clock out in order to reach 8 hours. Our project does not allow overtime and I am hoping this will help with controlling this. Staff lunches can range from 30 min, 45 min, 1 hour.

Please see attached excel spreadsheet.


IN 9:15 AM
LUNCH OUT 11:32 AM
LUNCH IN 12:36 PM
OUT ???

Try

=B1+B3-B2+TIME(8,0,0)

OR

=B1+B3-B2+(8/24)

Thank you so much!! This worked!!