Thank you for helping me plotting the time especially on holidays, but there's one thing that I really need to solve. Here's what i want to happen:

If I logged in (time in @column B) at 9:00 and logged out (time out @ column C) at 20:00, column D will determine or plot the time 19:00 (for this the excess or beyond 8 hours of work (less 1 hour non-working time 12:00-13:00)). For column E, will only replicate the data entered at column C.

Thanks again.