ExcelBanter - Add missing rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Add missing rows (https://www.excelbanter.com/excel-worksheet-functions/59332-add-missing-rows.html)

Add missing rows

I have a table that has military time values in column A

0000
0030
0100
0130
0200
0300
0330
etc.

I would like to be able to add a row when 1 of the half hour times is
missing ie. 0230 in above example.

Thanks
Art

All times are GMT +1. The time now is 07:42 AM.