Problem With Noon/Midnight

So, in Cell F55, I have a start time and in J55 I have an end time.

F55 = 12:00:00 PM and J55 = 3:00:00 PM. I'm working on a macro that prints all the hours between the two in the immediate window, but I was getting something weird, it was printing from 1:00 AM until 3:00 PM, so I put "?timevalue(Range("F55").Value)" in the immediate window just to see what Excel thinks "12:00:00 PM" means and I got this:

'Immediate Window

?timevalue(Range("F55").Value)
12:05:00 AM

Weird, huh? So to see what the value of "12:00 PM" as a double is, I got this:

'Immediate Window

?cdbl(timevalue("12:00:00 PM"))
 0.5

And then, when I wanted to know what the time value of "0.5" is:

'Immediate Window

?timevalue(" 0.5 ")
12:05:00 AM

So, if I have 12:00 PM as the value of a cell, both of these come up with the same answer, and are both wrong:

'Immediate Window

?timevalue(cdbl(timevalue("12:00:00 PM")))
12:05:00 AM 

?timevalue(Range("F55").Value)
12:05:00 AM

To sum it up, Excel thinks 12:00 PM is 12:05 AM and it's killing me.

Oh, nevermind, I just changed "Value" to "text" and it worked. Thanks!

My problem is that timevalue(Range("F55").Value) comes out as 12:05:00 AM, so

Dim i as integer
dim d as date
dim STime as string
dim ETime as string

STime = Range("F55").Value
ETime = Range("J55").Value

for i = 0 to datediff("h",STime ,ETime)
d = dateadd("h", i, STime)

debug.print d
next i

prints as

12:05:00 AM 
1:05:00 AM 
2:05:00 AM 
3:05:00 AM 
4:05:00 AM 
5:05:00 AM 
6:05:00 AM 
7:05:00 AM 
8:05:00 AM 
9:05:00 AM 
10:05:00 AM 
11:05:00 AM 
12:05:00 PM 
1:05:00 PM 
2:05:00 PM 
3:05:00 PM

INSTEAD OF

12:00:00 PM 
1:00:00 PM 
2:00:00 PM 
3:00:00 PM

You did, I just misunderstood.

Try converting the fraction value to a double before the conversion to time:
timevalue(Cdbl(Range("F55").Value))