Filter Weekend and Evening Hours (1 Viewer)

[yahazim]

Allright.

I have an Access frontend that is tracking Queues and Statuses of a specific process. When a Queue or Status changes, a timestamp is taken at the end of the old status, and the beginning of the new. I want to be able to track the number of hours something stays in that Status, however I want to filter out any weekend or evening hours from the total number of hours.

How can I do this?

Thanks in advance.

Jim Meyer
EDS, Inc.

 

[GKite]

I had to do something similar to this and it went kinda like this:

Do the normal calculation including nights and weekends. Then, look at the time 'in' stamp. If the total time from the time 'in' stamp to the time 'out' stamp is greater than the time from the time 'in' stamp to a night or weekend, simply recalculate by subtracting the time 'in' stamp from the beginning of the night/weekend instead of subtracting from the time 'out' stamp.

Hopefully this makes sense at all and will help..

-Greg

 

[yahazim]

This makes sense, I'm not quite sure how to do this in code.

Do you have an example?

Jim

 

[yahazim]

Also -- what if the status spans multiple days? through a weekend? how would the calculation look logically then?

 

[Travis]

Look here
http://www.access-programmers.co.uk/ubb/Forum7/HTML/003161.html

 

[yahazim]

Travis -- that's it. Thanks for showing me the logic. I can figure it out from here.

Jim