Thanks everyone for your contributions, I have certainly learned a lot through this discussion, and where I misinterpreted the function was that I saw it as ELAPSED TIME.

In terms of...

Thanks Dave, but the same behaviour also applies to the DateDiff function in Microsoft Visual Studio (VB.NET, C#, VB6), so this seems to be a Microsoft decision and definition.

To recap,...

Thanks a lot Dave for the speedy response and links.

I am very curious as to WHY this behaviour is by design, because it does not make sense.