I am trying to create a generic time sheet for employees that work part time, full time, and over time. Employees do not clock out for lunch, so 30 minutes is deducted from the daily total.
My equation for daily is =(((B9-B8)+(B11-B10)+(B13-B12)+(B15-B14)+(B17-B16)+(B19-B18))*(24-0.5))...