Ive 4 column
First column (A1) is "Time In". Second column (B1) is "Time Out" and the Third Column (C1) is the "Hours Work" and Fouth (D1) is "Overtime"
I have succesfully calculate the time difference to get the "hours work". To do this i subtracted B1-A1. Both cells are formatted with hh:mm

THe problem is now i want to calulcate the overtime hours and minutes. The required amount of hours per day is let say 8 hours. So i want to subtract 8 hours with the "Hours Work" column to get the value.
The value can be a negative value or positve value. I couldt get i working.

Any inputs?