Inserting Missing Dates and Times in a long Timeseries

Hello all,
I am in need of your expertise! (Please!) I am not proficient in VBA at all and need help inserting dates and times of day in a long timeseries dataset. Some dates are missing completely while others are missing certain times of day. I need both the date and corresponding hour inserted (all the times of day are in 1 hr intervals).

Example:
4/19/1992 12
4/19/1992 13
4/19/1992 14
4/20/1992 0
4/20/1992 1
4/24/1992 22
4/24/1992 23

and so on....

I have also attached the sample sheet if you need more info. Much much thanks in advance.