timevalue("23:50")

Question

This is just nuts.

I have a cell (in excel) in which I type "23:50" (without quotes). Next, with this cell selected, I go to the immediate window and type

msgbox activecell = timevalue("23:50")

..and it gives me "FALSE"!

I get TRUE for everything else, for eg with 23:49 or 23:51 (or any other time for that matter) in the cell and correspondingly in the code, but with 23:50 its breaking down for no reason.

This line is part of a bigger code, where this condition needs to be TRUE for the rest of it to execute. Using Excel 2007 on Win 7.

+1 but that should really be an answer. For details on why this problem occurs see http://stackoverflow.com/q/235409/53614 — barrowc, Feb 12 '13 at 22:34

score 5 · Accepted Answer · answered Feb 12 '13 at 22:37

5

Test with this instead:

timevalue(activecell.text) = timevalue("23:50")

Likely your mismatch is due to the numeric equivalents not matching exactly:

      activecell.value = 0.99305555555555_5_

but

cdbl(timevalue("23:50"))=0.99305555555555_6_

answered Feb 12 '13 at 22:37

Tim Williams

154,628
8
97
125

Sir Tim Williams I would knight thee if I could.. ! Thanks a lot! – MarioTheHedgehog Feb 12 '13 at 22:40
Though I'm still annoyed why it would work for all the other times except for 23:50. But now I don't have to care. – MarioTheHedgehog Feb 12 '13 at 22:42

timevalue("23:50")

1 Answers1