Creating a macro to import data from a table

[Si1209]

Hello

I'm running a CMS Avaya report that imports data based on half hour bands. Now the report will only import things up until the last half hour, for example if its run at 10:35 it will pull through information from 8:00 until 10:30, which would be 5 results per skill for the 9 skills.

My issue comes as it will only paste up to the last half hour band so in Excel when it pastes the information in it looks like so:-
[TABLE="width: 64"]
<tbody>[TR]
[TD]Skill[/TD]
[/TR]
[TR]
[TD="align: right"]08:00[/TD]
[/TR]
[TR]
[TD="align: right"]08:30[/TD]
[/TR]
[TR]
[TD="align: right"]09:00[/TD]
[/TR]
[TR]
[TD="align: right"]09:30[/TD]
[/TR]
[TR]
[TD="align: right"]10:00[/TD]
[/TR]
[TR]
[TD="align: right"]10:30[/TD]
[/TR]
[TR]
[TD="align: right"]11:00[/TD]
[/TR]
[TR]
[TD="align: right"]11:30[/TD]
[/TR]
[TR]
[TD="align: right"]12:00[/TD]
[/TR]
[TR]
[TD="align: right"]12:30[/TD]
[/TR]
[TR]
[TD="align: right"]13:00[/TD]
[/TR]
[TR]
[TD="align: right"]13:30[/TD]
[/TR]
[TR]
[TD="align: right"]14:00[/TD]
[/TR]
[TR]
[TD="align: right"]14:30[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD="align: right"]08:00[/TD]
[/TR]
[TR]
[TD="align: right"]08:30[/TD]
[/TR]
[TR]
[TD="align: right"]09:00[/TD]
[/TR]
[TR]
[TD="align: right"]09:30[/TD]
[/TR]
[TR]
[TD="align: right"]10:00[/TD]
[/TR]
[TR]
[TD="align: right"]10:30[/TD]
[/TR]
[TR]
[TD="align: right"]11:00[/TD]
[/TR]
[TR]
[TD="align: right"]11:30[/TD]
[/TR]
[TR]
[TD="align: right"]12:00[/TD]
[/TR]
[TR]
[TD="align: right"]12:30[/TD]
[/TR]
[TR]
[TD="align: right"]13:00[/TD]
[/TR]
[TR]
[TD="align: right"]13:30[/TD]
[/TR]
[TR]
[TD="align: right"]14:00[/TD]
[/TR]
[TR]
[TD="align: right"]14:30[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD="align: right"]08:00[/TD]
[/TR]
[TR]
[TD="align: right"]08:30[/TD]
[/TR]
[TR]
[TD="align: right"]09:00[/TD]
[/TR]
[TR]
[TD="align: right"]09:30[/TD]
[/TR]
[TR]
[TD="align: right"]10:00[/TD]
[/TR]
[TR]
[TD="align: right"]10:30[/TD]
[/TR]
[TR]
[TD="align: right"]11:00[/TD]
[/TR]
[TR]
[TD="align: right"]11:30[/TD]
[/TR]
[TR]
[TD="align: right"]12:00[/TD]
[/TR]
[TR]
[TD="align: right"]12:30[/TD]
[/TR]
[TR]
[TD="align: right"]13:00[/TD]
[/TR]
[TR]
[TD="align: right"]13:30[/TD]
[/TR]
[TR]
[TD="align: right"]14:00[/TD]
[/TR]
[TR]
[TD="align: right"]14:30[/TD]
[/TR]
</tbody>[/TABLE]

It doesnt leave any gap for the rest of the day, up until 18:00 and will only pull through the data for the times passed. My question is, is there a formula or a work around in Excel where I can correct this so that Excel realises where the skills break off and change and I can run a Macro or a formula to be able to import the required skills numbers in to my actual spreadsheet for that required skill?