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:
Weird, huh? So to see what the value of "12:00 PM" as a double is, I got this:
And then, when I wanted to know what the time value of "0.5" is:
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:
To sum it up, Excel thinks 12:00 PM is 12:05 AM and it's killing me.
Bookmarks