424,495 Members | 1,231 Online
Need help? Post your question and get tips & solutions from a community of 424,495 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

 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.