Adding two hours to a format that ISN'T classified as a time.

Hi there,

I need to find a way, preferably a quick way ( :-) ), to add TWO hours to a number that isn't classified by Excel as a 'time' format (it is in format 'hh:mm:ss:00 AM/PM', so when trying to add two hours it won't - and I need it in this EXACT format for when I paste it to another macro), and then also changing one of the other cells to have a '2' next to it (for instance, change 'ARENA' to 'ARENA2').

An example of one of the rows of data:

19/06/2011	30	5	06:00:00:00AM	11:58:59:00PM	06:18:54:00AM	XIL 4.9% Waa Le	9	XIL 4.9% Wanna Live  	ARENA 	99	I1-NXT034030TV#	AI68W

Ok, so it is the '06:18:54:00AM' that I need to add two hours to (to signify a '+2' TV channel basically). I have used a VLOOKUP to change the channel 'ARENA' to 'ARENA2' (because not all channels have a +2, so it won't be all rows this is needed on) but am stumped on adding two hours without doing a ton of work (there is sometimes up to 1000+ rows in this). Also when I do the VLOOKUP it obviously means I get a %VALUES when it hits a channel that does not have a +2 channel.

My whole task in a nutshell: Getting a huge list of rows with that information on, duplicating it and adding two hours and changing the channel for the ones with a +2 channel, and then duplicating it and changing the channel (but not the time) for those with a similcast HD channel. It's all very confusing and I wish there was an easy way to do it!

Thanks, and if there's any questions let me know.

Or if you need any extra information.

EDIT: I'VE ATTACHED SOME MORE INFORMATION OF WHAT I NEED IN AN EXCEL FILE, WITH TWO TABS. thanks!