Time lapse calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I calculate the time lapse for business days only (excluding weekends
& holidays)? For example, how do I calculate the time difference from
5/11/06 10:32
to 5/16/06 14:45? The weekend 5/20-5/21 would need to be excluded. Any
help would be greatly appreciated. Thank you!
 
5/11/06 10:32 to 5/16/06 14:45?
Click to expand...

diffInDays = #2006-05-16 14:45# - #2006-05-11 10:32#

diffInMinutes = diffInDays * 24 * 60
The weekend 5/20-5/21 would need to be excluded.
Click to expand...

Inadequate definition. I guess you don't just mean subtract 48 hours;
what about holidays etc; do you really want office hours; etc etc?

There are various custom functions around -- try googling something like
"MS Access workdays datediff" or go straight to the Oracle:

http://www.mvps.org/access/datetime/date0012.htm

Hope that helps


Tim F
 
Back
Top