Insert missing data time (Excel)

Hello everybody,

I will attach an excel file with a macro that I found but it doesn't work 100%.

In columns C and D I have the time data and a value of a parameter.
It might seem that the hours and minutes for the data is always the same, so it only changes the number of the day/month, but it is not true. At 04/07/2016 the hour is 04:00:00 and all the data that is not 04:30:00 when I run the macro it transforms the 04:00:00 to 04:30:00 and the value of the parameter from 04:00:00 is changed to blank.

What I want is to fill the missing data to have the data by a step of 1 min

So 01/01/2016 00:00:00, then 01/01/2016 00:01:00, then 01/01/2016 00:02:00.


Hope I was clear about my doubt.
If in Matlab this would be easier I can also work in Matlab.

Thanks for your time
--
Best regards,
Tiago