Thanks Pete that works fine. I have one last request please.

I need to add up the paid times and put that in K5.

I have this formula:

=IF(H5-G5>=6/24,H5-G5-30/1440,IF(I5<>"",(H5-G5)+(J5-I5),(H5-G5)))

It works fine with entries but gives me value errors when blank. The 6 hours is there so if an employee works at least 6 hours they must take a mandatory lunch of 30 minutes or they will be docked that amount.