Timesheet Calculation Help

Hi all,

I am trying to set up a timesheet for various employees(on the same sheet) I have everything pretty much set up except for the calculation for shifts that start on one day and end on the next (22:00 - 6:30).
This is what i Have so far:

Day 1
B3 In
C3 out

Day 2
D3 In
E3 Out

and so on.
at the end of the week it is calculating all the time worked, deducting the 30 minute break and converting the time to decimal.
This is the formula i am using for the weekly total (bare with me)
=((IF(((C3-B3)*24)>=5,C3-(B3+TIME(0,30,0)),C3-B3))*24)+((IF(((E3-D3)*24)>=5,E3-(D3+TIME(0,30,0)),E3-D3))*24)+((IF(((G3-F3)*24)>=5,G3-(F3+TIME(0,30,0)),G3-F3))*24)+((IF(((I3-H3)*24)>=5,I3-(H3+TIME(0,30,0)),I3-H3))*24)+((IF(((K3-J3)*24)>=5,K3-(J3+TIME(0,30,0)),K3-J3))*24)+((IF(((M3-L3)*24)>=5,M3-(L3+TIME(0,30,0)),M3-L3))*24)+((IF(((O3-N3)*24)>=5,O3-(N3+TIME(0,30,0)),O3-N3))*24)

I need the adjustment so that it will calculate the shifts that go from one day to the next. but still do the same calculation i already have set up..

PLease help.

take a look at this one:
Wages.xlsx

Book1.xlsx

bebo021999

Ok so this is what I Have,
in row 3 I tried plugging in your formula. it's giving me an error and I have no idea how to fix it. the other thing I think I failed to mention was that the
formula should only deduct the 30 minute break if the hours worked in the day are greater than 5.
Row 2 has the original formula I was using
and Row 3 shows the problem I am having when the shift goes from one day to the next.

Please help

Thanks

Thank you! but that's not giving me what I need.

Thank you soooo much!!! that is exactly what I needed. Now I will study that formula so I can understand it. lol

Thank you again so much!!!!!

bebo021999

Question, can you explain how the formula works. I cant quite figure it out.

Thanks