Rota - Hourly Calculation

Hi Premy,

Please put the following formula into Cell B16 and then hold down Ctrl+Shift and hit the Enter key. Then copy that cell, highlight cells C16 through G16 and right click them, past special - formula.

=SUM((MID(B5:B14,FIND("-",B5:B14)+1,20))-(LEFT(B5:B14,FIND("-",B5:B14)-1)))/(100)

That should do it for all 6 columns.

I added the example I've been working with into my previous post. Please take a look at it. All of the columns add up correctly.