Win xp, xl2003

For some reason when I do a web query the time sometimes comes across as AM
when it should be PM. I have looked at the html code and there is no
designated AM or PM.
So what I am trying to do is to check the time and if necessay change it
from AM to PM.
I have tried the code below but it is not working.

Dim AnyString, Time
Time = Range("C2").Value
If Right(Time, 1) = "A" Then
Right(Time, 2) = "P"
End If

The format is H:mm with not AM/PM designation but once it has been copied
from the web query it looks like 12:35:00 PM or 12:35:00 AM

Any help would be greatly appreciated.
Ta,
Martin