hey all,
I need help please to find a formula that accurately calculates my total shift time. Most of my guys work a split shift. So I have a formula that works for that, but if they work past midnight that formula fails. So I tried a MODE function that works ok, but I am still missing two things how to subtract the break time form my total and then split this into two cell one showing the worked hrs and the other the overtime or if the hrs worked are less than 8 .. I have spend the last 5 hrs reading threats and I found a lot but there is always one component missing. So I appreciate any help I can get.. Thanks
Bookmarks