I wish I was done.
1 more question:
On the formula
=IF(B4="", 0, IF(COUNTA(B4:C4)=2, (C4-B4) * 24 - 0.5, IF(ISNUMBER(MATCH(B4, 'Lists for Stores'!$C:$C,)), INDEX('Lists for Stores'!$D:$D, MATCH(B4,'Lists for Stores'!$C:$C,)), 0)))
I need this to calculate between both store 3 and 15.
I have also added the formula (chart) in store 15. It calculates great for each of the 2 stores separately but, I need it to calculate (reference) both stores on the chart.
Thanks,
Laura