This is sort of related to a previous question. My formula, which seemed to work fine yesterday now gives strange results.
Today is the 30th of March (30/03/10). It's 10:11am on the clock that the computer is using for the time stamp in the NOW() part of my worksheet. Below is the formula and a screen shot of the results/columns.
Why does it show 1/2 day, and also where does 23 1/2 come from?
The NOW() is in a hidden column (F2)...which I forgot to unhide before I took the screen shot.