I have a spread sheet to calculate payroll. I enter the time in and time out with a paid lunch. anything over 7 hours is time owed. When no lunch is taken .30 time is owed.
My columns are Date/ Time In/Time Out/ Regular Hours "=sum(time in-time out)*24"/ Time Owed "=If(Reg hours>7,(Reg hours-7), (0))"/NL/Time Used/Balance "Time Owed+NL-Time Used". How would I set this up? I can not get it to add the .30 when no lunch is taken.
Solved by K. E. in 12 mins