Return Dates with Missing Values

[Emou]

Hi there,

I have been trying to find a solution to what I thought would be a simple solution. I have a large data set which records rainfall every 15 minutes; however, there are some data gaps where no rainfall is recorded and is left blank.

I am wanting to find out the ranges of missing data ie data gap between 01/01/2000 15:45 and 01/02/2000 23:00. I would like to know the range between all the data gaps, but have not figured out a way to get excel to return what I want.

I have attached a sample sheet as well. Any help would be greatly appreciated!

Thanks,