How to VBA for a Table missing Time increments

I have call data in a table format. I input this data into the table on a daily basis. The data is formatted for every 30 minutes for 24 hours (12:00, 12:30, 1:00, etc). Many days are missing various times (12:00,1:00,1:30 (missing 12:30)). I want to write a VBA to go through my entire table (27k rows) to add a time slot on each day for every missing 30 min time slot. At each time slot I add, I want to add 0's across the row (data is missing because no calls happened during that time frame).

Thank you to any who assists!

Please attach an Excel file for example

Yes I am working on.
Have you noticed that the time info is in text format ...!

Is it what you need ?

Please Login or Register  to view this content.

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

Good news.
Thx for the feed back