I was just doing some date calculations, and was wondering if this happens to other people, and if so, does anyone know why.
Copy this into a module:
Code:
Function WierdThing()
Debug.Print DateDiff("n", #7/2/2003 12:15:00 AM#, #7/2/2003 1:55:00 AM#)
Debug.Print DateDiff("n", #11/15/2003 6:55:00 AM#, #11/15/2003 8:00:00 AM#)
Debug.Print DateDiff("h", #7/2/2003 12:15:00 AM#, #7/2/2003 1:55:00 AM#)
Debug.Print DateDiff("h", #11/15/2003 6:55:00 AM#, #11/15/2003 8:00:00 AM#)
End Function
The results I get are:
100
65
1
2
Which confuses me. For some reason, 100 minutes = one hour, but 65 minutes = 2 hours.
Any ideas why this happens?
Steven
I am a loud man with a very large hat. This means I am in charge