Using Datediff to calculate elapsed hours, need help with excluding weekends

[EDubb]

Greetings,



I am fairly new to Access, and have read several threads regarding this topic being done in days, but have been unable to adapt and/or alter any solutions to fit what I am trying to do. What I have is a query that contains a start date, start time, end date, end time of manufacturing orders. I was able to find some code that I adapted to calculate the elapsed time in hours from the start of the order to the end, and it works great, however - I need to it to make that calculation excluding weekends and holidays. Below is what I'm currently using - any help would be greatly appreciated!

ELAPSED: (DateDiff("n",[START_DATE] & " " & [START_TIME],[END_DATE] & " " & [END_TIME]))\60 & Format(((DateDiff("n",[START_DATE] & " " & [START_TIME],[END_DATE] & " " & [END_TIME])) Mod 60)/60,":hh")

Thanks,
Erik

[June7]

Need a custom function.

Has been discussed in forum, search forum.

Google: access vba elapsed time function exclude weekend holiday

Review http://bytes.com/topic/access/answer...idays-weekends