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.

```
=IF(ISBLANK(I2),ROUND(MOD(H2-F2,24),2),ROUND(MOD(I2-F2,24),2))
```