Forum Discussion
timevalue and if conflict
Hi team, I am using timevalue() function to retrieve the time from a text string. This works well. The result is a time-format hh:mm:ss . Then I am comparing the result with a fixed "time" (also hh:m...
maybe one point to add: when replacing the result of timevalue() by simply edition the number, then if() works perfectly. So in my case timevalue returned "04:00:00" in time format, which was not TRUEd in an if() comparison with "04:00:00" cell (time-format). If replacing the timevalue result by simple editing "04:00:00" (time-fomrat), then the if() results in TRUE. Any idea ?