Hi to All,
I am trying to fine tune my time sheet so I don't have to manually subtract 1/2 hr for lunch. I also need it to automatically add overtime hrs if more than 8 hrs are worked a day.I copied a formula from this forum but it still took 1/2 hr off even though they only worked 4 hrs.
Regular hours are from 7am-3:30pm with a 1/2 hr lunch from 12 pm-12:30 pm. On days that employees work from 7 am- 12pm we don't subtract lunch.
I am attaching my timesheet if that will help.
I hope someone can help me with this, I am going crazy.
Thanks
Solray
calc hrs worked.xlsx
Bookmarks