Hello
I am new to this forum and would love to get some help. I am trying to get all the times aligned and not getting it to work. Every time I fix one the other one fails. I am not good with rules as I am a beginner with excel.
I have two different formulas going right now and I am stuck. I could use the help. At the end of the schedule is a totals column for the weekly hours. The only one working right is the late column because it's not really tied to the bigger cells. I need the late column to minus hours from the weekly total hrs of 37.5 per week.
I was hoping to get this going for Monday at the beginning of the shift. Hope someone can assist me. The headings in red are the two different formulas.
Need: The total hrs worked column to deduct the 30 min lunch. If they stay an hour of OT it will show up as the below. The OT column to calculate the OT with 15 min increments. 1.25, 1.5, 1.75 etc.. depending on how long the employee stays back.
START END TOTAL HRS WRK OT LATE
7:00 AM 4:00 PM 8.5 1
Bookmarks