I am re-developing a tracking sheet which records the length of system outages over periods of time.
outage occurs during, or extends into non-supported times, we are supposed to stop counting the outage time until the next
support time kicks in.
So how do I get Excel to recognise and ignore those unsupported hours?
an outage extends over a few days, how do I get Excel to ignore the unsupported hours for each day, while tallying the time
of the outage?
An example runs along these lines:
We provide "core support" from 7am-5pm Mon-Fri only.
A system outage occurs at 4:00pm on a Wednesday
night and is not restored until 8:00am the following morning (Thursday).
My sheet needs to return 2 hours (agreed
support times), but it currently returns 16 hours.
Also, how do I handle that calculation over multiple days? A
normal 3 day outage needs to be tallied as 27 hours, not 72 hour. And that calculation needs to hold true over a weekend as
we provide no core support.
Any advice appreciated.