Weekly Hours calculation sheet with Breaks and OT

Hi all,

Having some difficulty with creating a time sheet that takes into consideration breaks, overtime, holiday pay, sick leave etc.

Have the basics set up but when it comes to adding holiday pay where you enter a H in the cell (K2 - K4 in attachement) it returns a Value error in L2 as it is trying to deduct what is in Cell K3 (a 30 min unpaid break) this inturn creates a Value error in the Q2 and R2. This also is the case where their Rest day is entered in the cell as an R (See Cells I2 - I4)

Ideally i would like it all to be relitively automated with only having to add in their Start/Lunch and Finish time and the Total hours is calculated (Cell Q2) up to 42 Hours and then anything over the 42 Hours is Calculated as OT in Cell R2.

Any help would be appreciated, Sorry if i havent described it properly

?? Your formula in L2 is attempting to perform mathematical operations on the entries in cells K2, K3 and K4, which are all letters! Similarly for your formula in J2. You cannot subtract the letter "h" from the letter "h", nor any other letters.

What exactly were you wishing to do?