Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 311
  • Last Modified:

Calculating business hours elapsed between two dates

I have two dates coming in from a database that I need to calcuate the total elapsed business hours from. The rules would be only 8-5 hours on Monday through Friday would be counted. So for example if I have a start time and date of 7/10/2003 at 2:49:15pm and a end time of 7/25/2003 at 4:16:57 pm (both of these are datetime values), I should get something like 89:37 as the result. I have tried using datediff and excluding the weekend days, which is closer, but does not exclude the non-working hours.

Thanks!
Ken
0
kabaker55
Asked:
kabaker55
  • 2
1 Solution
 
ebolekCommented:

go to here and search for businessdays.zip
http://support.crystaldecisions.com/downloads

You will find the ufl for calculating business days and how to do it

Regards
Emre
0
 
mlmccCommented:
Glad I could help

mlmcc
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now