Excel: ROUND & MOD giving me strange DATE results
- by Mike
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.
QUESTION: Why ddoes 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))
Thanks
Mike