add missing hours in hourly data

[ijqureshi]

Hi

I need to add missing hours in 24 hourly data with the help of vba to keep my dynamic charts free from errors

Sample Interval :

06.19.2011 00:00:00
06.19.2011 01:00:00
06.19.2011 02:00:00
06.19.2011 03:00:00
06.19.2011 04:00:00
06.19.2011 05:00:00
06.19.2011 07:00:00
06.19.2011 08:00:00
06.19.2011 09:00:00
06.19.2011 10:00:00
06.19.2011 11:00:00
06.19.2011 12:00:00
06.19.2011 13:00:00
06.19.2011 14:00:00
06.19.2011 15:00:00
06.19.2011 16:00:00
06.19.2011 17:00:00
06.19.2011 18:00:00
06.19.2011 19:00:00
06.19.2011 20:00:00
06.19.2011 21:00:00
06.19.2011 22:00:00
06.19.2011 23:00:00

Sample with missing interval

06.19.2011 00:00:00
06.19.2011 01:00:00
06.19.2011 02:00:00
06.19.2011 03:00:00
06.19.2011 04:00:00
06.19.2011 05:00:00
06.19.2011 07:00:00
06.19.2011 08:00:00
06.19.2011 09:00:00
06.19.2011 10:00:00
06.19.2011 20:00:00
06.19.2011 21:00:00
06.19.2011 22:00:00
06.19.2011 23:00:00

i want all the missing hours to inserted by vba

plz help

 

[Ralajer]

Quick questions is the 06:00:00 supposed to be missing, is there other data on the sheet that needs to stay aligned with the time intervals and what cell does the time interval start in? Also please provide any other details that might be relevant.

Thanks

 

[ijqureshi]

Hi ralajer

missing hours means no data ! in that interval just add missing hour

with blank data

for example if we have 3 hours in 4 hours it will add missing hour

20:00
21:00
23:00
00:00

case:

20:00
23:00
00:00


it should add 21:00 , 22:00 column is A

Thanks for your support :D