I am setting up an Access database that will count how many hours it take from the time a record is received to the time it is released. The two fields hold the date and time in this format 2/13/04 10:00PM. I want to calculate the time in hours between the two dates but not including weekends.
Ex. I would want the following example listed below to equal 60.5 hours

Received 2/13/04 10:00PM
Released 2/18/04 10:30AM

Note that I do not want it to count the weekends (2/14/04 & 2/15/04)

Does anyone know how to set this up?

Here is an article that will help with converting the time your looking for.

http://support.microsoft.com/default...b;EN-US;210604