I recently asked how to round a date and time and I got what I was looking
for but I think there may be a flaw in my formula or excel.....
A1 12/5/2008 8:00
A2 12/5/2008 15:45
using the formula
=round((A2-A1)*24*2,0)/2

gives me a result of 7.5 and it should be 8.0 so it is not rounding to he
half hour correctly ..........using the same if I change A1 to 7:00 it shows
9.0 hours and is correct.........so why is the 8 oclock hour rounding
differently......can I fix this...?

--
Mr.B