Creating a split shift timesheet

[dangallagher]

Hi guys I have created a timesheet for my crew that will work out how many hours worked each day and then work out their pay.

At the moment i've done it for one shift per day, however, i need it to be for two just incase.

Can anyone advise me the formula to use.

I currently have

=(IF([@[Time In]]>[@[Time Out]],[@[Time Out]]+1-[@[Time In]],[@[Time Out]]-[@[Time In]]))

My 2nd shifts have the headings Time In 2 and Time out 2.

 

[123rickfear]

=(IF([@[Time In]]>[@[Time Out]],[@[Time Out]]+1-[@[Time In]],[@[Time Out]]-[@[Time In]]))+(IF([@[Time In 2]]>[@[Time Out 2]],[@[Time Out 2]]+1-[@[Time In 2]],[@[Time Out 2]]-[@[Time In 2]]))

would this not work?