I am trying to create a formular which will exclude out of hour support
time..

Here's an example

Device A fails at 25/08/05 05:20:00 and recovers on 30/08/05 11:20:00

The total down time is 126:00:00

However

The total fix time is 61:20:00 because the hours between 18:00:00 -
05:59:59 are excluded from the time to fix figure for each day..

I need a formular which will look at the Fail time and the recovery
time and produce a Fix time, rather than a total down time.

Can anyone help ?????


--
wlln001
------------------------------------------------------------------------
wlln001's Profile: http://www.excelforum.com/member.php...o&userid=27022
View this thread: http://www.excelforum.com/showthread...hreadid=437381