Function or Macro to Insert empty rows above "missing" flag

Hi everyone,
I am again in need of urgent help!

I could not find a solution to my problem in the previous posts and I am not an excel expert.

I am processing an infinite set of data from a meteorological station here in Alaska which gives me half hourly data reading with a time stamp 00.00, 00.30, 01.00, 01.30, 02.00, 02.30 and so on.

I am using this formula to detect every time half hour reading is skipped (=IF(TEXT(MOD(B1936-B1934,1),"[M]")="30","","missing")) and it works pretty well.
Still I have to check and manually insert extra missing for every half hour missing but that's bearable.

This formula inserts a "missing" every time it finds a gap.

My question is: How can I insert a row above every cell with "missing"?

How do I do that? I am not expert in excel macros....actually I know almost nothing.
Here is also my excel sheet.

CR1000_Meteo_20131113_2_CLEANED.xlsx

Thanks a lot in advance!

Best regards

Ron I will give it a try!
If it works it would be a great help already.
I was trying to use the find tool but it didn't find them so, I guess, I was stupid enough to miss something..

I will let you know!

Sal

Ron It works!!
And it's pretty neat!

Sometimes the solution is just under your nose......
Thanks a lot!

PS
I guess there is no simple way to find where there is more than a half hour missng like between 01:30 and 3:30?
Anyway thanks again!

Sal