Hi all,

Please could someone help I have been stuggeling with this all day. I have a columb of shift start and finish times and varing from 8 to 4 hours slots. what i need is to some how match 2 cells together to make a 12 hour slot from 8-8.

the data will look soe thing like this:-
1 8:00 12:00 4:00hrs match
2 8:00 16:00 8:00hrs
3 16:00 20:00 4:00hrs cell a1

please help me

thanks
Brento