Hi, I'm new to this forum so please be gentle with me. I'm trying to write a formula in excel and just can't get my head around it - hopefully someone can help if I explain.
We are trying to work out potential business hours lost when there is any system downtime. This involves a number of assumptions e.g. that they'll be more users at certain times of day e.g. not many 0700-0800 (e.g. ca. 20% of potential users) or 1300-1400, but significantly more from 1000-1200 (e.g. ca. 50% of users). What we want to do is create a calculation that works out the number of minutes within each period so that this can them be multiplied by the weighting we've applied for that period (e.g. 20%, 50%, etc.) and can then sum them up. For example, how many 'man hours' are potentially lost if there is an interruption from 0921 - 1130 to an app that could be used by 300 users, and we assume 40% of users are logged in from 0900-1000 and 50% from 1000 - 1200.
I hope this makes sense. Thanks for any help you can offer.
We are trying to work out potential business hours lost when there is any system downtime. This involves a number of assumptions e.g. that they'll be more users at certain times of day e.g. not many 0700-0800 (e.g. ca. 20% of potential users) or 1300-1400, but significantly more from 1000-1200 (e.g. ca. 50% of users). What we want to do is create a calculation that works out the number of minutes within each period so that this can them be multiplied by the weighting we've applied for that period (e.g. 20%, 50%, etc.) and can then sum them up. For example, how many 'man hours' are potentially lost if there is an interruption from 0921 - 1130 to an app that could be used by 300 users, and we assume 40% of users are logged in from 0900-1000 and 50% from 1000 - 1200.
I hope this makes sense. Thanks for any help you can offer.
