> For example if > you look at the real value from "CreateTimeSpan()" you will see it is > 0.041666666666666664
Odd. I guess it's JVM- (or something) specific. On CF8.0.1 (running a 1.6.0_21 JVM), CF9.0.1 (1.6.0_24), OpenBD (1.4, 2010-10-27 14:24:51 GMT; 1.6.0_21) & BD.NET (dunno what version... I D/Led it from their site a coupla months back) I get 0.0416666666667. On Railo (3.2.0.000 rc, 1.6.0_01) I get 0.041666666667 (note that's one fewer DPs). I mean... it all amounts to the same thing (1/24th) - or should do! - but it's interesting you're getting a different value there. And equally, the floating point accuracy should be adequate there for CF (etc) to be able to correctly resolve the values to the correct hours/min/sec when doing an addition such as Scott's. Oh, and FWIW, I get the same results as Scott on OpenBD, whereas it works fine on CF8.0.1, CF9.0.1 & Railo. BD.NET fails miserably, giving this: 10:00 AM 10:00 AM 10:00 AM 10:00 AM 10:00 AM 10:00 AM 10:00 AM 10:00 AM 10:00 AM 10:00 AM 10:00 AM 10:00 AM 10:00 AM 10:00 AM 12:00 AM 12:00 AM 12:00 AM 12:00 AM HTH. -- Adam -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
