How I can find breaks in continuity

[tweacle]

I have a workbook of which I check every month for breaks in continuit
on a variety of machines. What im trying to do is see the breaks i
continuity when dates are missing.

I.E say I have a workbook which has start dates.end dates and machin
numbers

Machine 1 Start date= 01/03/2006 end date = 07/03/06 then on the nex
entry Start 08/03 end 16/03. Obviously there no break there so tha
fine.
Machine 2 Start 01/03 end 07/03 start 25/03 end 31/03. Obviously ther
a break there and I need to be able to have that highlighted.

There are about 40 machines which all have there own number. When thei
input they are not in any order cos there input every time ther
emptied. I only need to check the contunity monthly so if to make i
easier they can be sorted into machine no before checking for breaks.

Can anyone help

 

[Dav]

If you sort the data by machine then startdate
then lets say machine is in column a, start b, finish c and the data
starts in row2.
If cell d3 put if(a2=a3, b3-c2,0) if the value is greater than 1 you
have a gap
you can then copy it down all th other rows

Regards

Dav