excel - timevalue("23:50") -

excel - timevalue("23:50") -

this nuts.

i have cell (in excel) in type "23:50" (without quotes). next, cell selected, go immediate window , type

msgbox activecell = timevalue("23:50")

..and gives me "false"!

i true else, eg 23:49 or 23:51 (or other time matter) in cell , correspondingly in code, 23:50 breaking downwards no reason.

this line part of bigger code, status needs true rest of execute. using excel 2007 on win 7.

test instead:

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

likely mismatch due numeric equivalents not matching exactly:

activecell.value = 0.99305555555555_5_

but

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

excel excel-vba