how to calculate the difference between two times in access?
If you add 0.5 to 1/1/2004 you get 1/1/2004 12:00 (which is HALF a day). If you need to figure out the difference between two times, just subtract them. That will give you the difference IN DAYS between those two dates. If it's a fraction, you're dealing with HOURS, just multiply by 24.