If you know date functions, please read...

[Crevalle]

I have to find the number of weekdays between two dates (to the second decimal). For example, if a ticket is opened at 3pm on Friday, and closed at 4pm on Tuesday, I want to exclude the weekend in the day count and have a result similar to 2.04 days.

I WAS using this formula (which includes the weekend): CLng(([DATE_Max]-[DATE_Min])*100)/100

Then I tried this (to exclude the weekdays) to no avail: DateDiff("w",[DATE_Max],[DATE_Min])

Any ideas? FWIW, the dates are in the following format: "08/09/2004 11:14 PM"

Thanks!

 

[lespaul]

FAQ181-261 has a module to calculate the number of working days.

Leslie

 

[MichaelRed]

but it only returns the # WHOLE days. Additional work needs to be done to get the fractional part and even morfe to convert to the decimal hours. Somewhere in these fora there IS a thread which gets to at least the time in Hrs, and Mins. Look for a routine "basWorkHours" for most of the rest. Be SURE to look over the thread(s) carefully, as there are a couple of 'helper' routines which break down the state and end days to the time start / finish.





MichaelRed