Calculate Time Between Two Date/Time Fields

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: jlo <jlo@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 19 Aug 2008 06:01:01 -0700

I have the expression using Datediff to extract the hours between two
date/time fields however, I am unclear on how to exclude Holidays and
Weekends.

Any help would be appreciated:

My fields are [TimeReceived] and [TimeAcknowledged]

I have a Holidays table with the fields [Holdate] and [Description]
.

Follow-Ups:
- Re: Calculate Time Between Two Date/Time Fields
  - From: Ron2006

Prev by Date: found record base on count records on child table
Next by Date: Re: Update field with contents of another field
Previous by thread: found record base on count records on child table
Next by thread: Re: Calculate Time Between Two Date/Time Fields
Index(es):
- Date
- Thread

Relevant Pages

Counting time instances Challenge
... This is really hard to explain, and I'm just as unclear as to what I ... I have to extract and manipulate the data I have. ... My problem comes with just realizing what I have to do. ...
(microsoft.public.excel.misc)
Re: from String to DATE format?
... Sorry, it was really unclear. ... What I want is to extract the date from a HTTP header in this format, ...
(comp.lang.java.help)
Re: extracting value from a field in awk
... I want to extract from these lines the value after rule and before '.' ... Your description/text is a little murky (unclear what you mean by ... I'm guessing you want something like: ...
(comp.lang.awk)