Number of hours worked not weekends

[SimonJ]

Hi

I am working in enyterprise guide 9.1 i am trying to identify how i can calulate the time between to given dates not including weekends and going forward bank holidays.

I lknow i can use the INTCK function this works great for the number of hours elapsed but does not consider weekends, i know there is a weekday element but this does not work its like i need workhours can anyone help?

Thanks

Simon

[PeterClemmensen]

check this out

http://blogs.sas.com/content/sasdummy/2011/05/09/calculating-the-number-of-working-days-between-two-...

[SimonJ]

Hey thanks for this i think that would help when i get to the bank holiday stage, What about hours this is where i am struggling with at the moment?

[Reeza]

It's essentially the same as the blog post, but INTCK can take an hour parameter and you should have datetime variables not date variables. 

[Reeza]

Post sample data and expected output.