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?