Hello all, this is my first post and I am excited to start sharing information. As my first, rather complicated question, I've decided to ask for help in building a very difficult (for me) DateDiff Expression in a simple Select Query.



I need to find the number of hours between two dates ([COMPLETED] and [OPENDATE]). The kicker, however, comes with only wanting to measure work days (8 hour days, excluding weekends, holidays are ok). Is this even possible? Currently, I am using the following (weekends are currently included):

Hrs: (DateDiff("h",CDate([OPENDATE]),CDate([COMPLETED])))+(Format(CDate([COMPLETED]-[OPENDATE]),"hh"))+((Format(CDate([COMPLETED]-[OPENDATE]),"nn")/60))

Any help is appreciated!