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