Need Help to get a formula that calculates my total shift time pls

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

thank you Olasa for your swift help.... this is great help, but it does not work if the finishing time is past midnight. Any idea? I also need to keep track if the total hrs worked are less than 8 , as seen in row 23. Would really appriciate your help.

TY

Originally Posted by olasa

This might give a hint
//Ola

O11: =SUM((E11-D11)+(G11+(F11>G11)-F11)-H11) --- could be enclosed by =IFERROR(...,"")
Q11: =IF(O11>8/24,8/24,O11)
R11: =IF(O11>Q11,O11-Q11,0)

O11: =SUM((E11-D11)+(G11+(F11>G11)-F11)-H11)

SUM function doesn't do any better in this case, just remove i t.

O11: = (E11-D11) + (G11+(F11>G11)-F11) - H11

Thanks...The formula works. Now to my other issues, if the worked amount of hrs Q is less than 8 than R should be a negative, as in hours owed. How can I include that into the formula =IF(O12>P12,O12-P12,0)..... and on top of that I really feel confused how to you enclose an IFERROR funcion into my formula...thanks guys..!!

excellent thank you.. One more please.. how do I enclose a IFERROR to my formula.=SUM((E24-D24)+(G24+(F24>G24)-F24)-H24)...thank you