By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,376 Members | 3,024 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,376 IT Pros & Developers. It's quick & easy.

Hours per WorkWeek calculated from Start / Finish Dates?

P: n/a
My table lists pieces of equipment and the date/time they are taken
down for maintenance, and date/time maintenance is complete (put back
up to production). Sometimes these dates/times are within the same
WorkWeek, but sometimes a piece of equipment is down for multiple weeks
at a time. I need to calculate the % of time "up" per workweek.

For example, if a piece of equipment went down on Wednesday, June 7 and
was not back up until Wednesday, June 21 (2 weeks later), I need to
show that it was up roughly:
50% of WorkWeek 23
0% of WorkWeek 24
50% of WorkWeek 25

A few considerations:
1. What if the same piece of equipment goes down/up, then down again
in the same WorkWeek? The percent "up" needs to decrease accordingly.

2. What if a piece of equipment is not taken down at all. Can I
reflect 100% "up" without an entry in the table?

What else am I not thinking of? I have searched and searched these
groups and haven't found the exact solution I need.
Thanks,
Liana Ottaviano
Bend, Oregon

Jun 7 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
lo********@hotmail.com wrote:
My table lists pieces of equipment and the date/time they are taken
down for maintenance, and date/time maintenance is complete (put back
up to production). Sometimes these dates/times are within the same
WorkWeek, but sometimes a piece of equipment is down for multiple weeks
at a time. I need to calculate the % of time "up" per workweek.

For example, if a piece of equipment went down on Wednesday, June 7 and
was not back up until Wednesday, June 21 (2 weeks later), I need to
show that it was up roughly:
50% of WorkWeek 23
0% of WorkWeek 24
50% of WorkWeek 25

A few considerations:
1. What if the same piece of equipment goes down/up, then down again
in the same WorkWeek? The percent "up" needs to decrease accordingly.

2. What if a piece of equipment is not taken down at all. Can I
reflect 100% "up" without an entry in the table?

What else am I not thinking of? I have searched and searched these
groups and haven't found the exact solution I need.
Thanks,
Liana Ottaviano
Bend, Oregon


If you don't need to use the specific time a piece of equipment went
down, to the minute, then you can use this DateIntersection function:

http://groups.google.com/group/comp....f7500e40e39155

Using that function inside a Sum should handle the "down/up, then down
again" scenario.

If more detail is needed try the following thread:

http://groups.google.com/group/comp....8a5c4e14d10ab7

Hope this helps,

James A. Fortune
CD********@FortuneJames.com

The state of Oregon is usually pronounced like organ by those who live
there. -- Lynn Barna

Jun 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.