Calculating Availablity for branches

[kavyaakhil]

I need to calculate downtime for branches which operates on diffrent timings and where the usuall calculation of %uptime:1-(Downtime in minutes/Total Expected Uptime)is not working. As iam stuck due to diffrent timing and stanadard 24hrs cannot be applied.

Got below four sets of timings with no of branches respectively 30/7/15/1

08.00 am to 04.00 pm 08:00 am to 02:30 pm* "08:00 am to 06:00 pm 08:00 am to 08:00 pm/10.00am to 10.00pm and i have taken the total timings as a sum of 14880+12090+18600+22320=67890


Not sure if i calculate downtime as

[pre]

Total Expected Uptime	Downtime in minutes
67890	                 0	         100.00%
67890	                10	          99.99%

[/pre]
PLease help


Kavya

 

[srinidhi]

08.00 am to 04.00 pm when converted to minutes is 480 & 08:00 am to 02:30 pm when converted to minutes is 390. could not understand how you got 14880 & 12090

 

[Hui]

All times in Excel are decimal with

0.00 being midnight

0.25 Being 6am

0.5 being Noon

0.75 being 6pm

1.00 being the next midnight


So

8:00 am is 8/24 = 0.3333

4:00 pm is 16/24 = 0.6667

etc


You have to allow for this in your calcs

eg: 4:00 pm - 8:00 am = 0.6667 - 0.333 = 0.333 etc


You also have to adjust for the next day

eg:


8:00 am - 8:00 pm

=1.333 - 0.83

=0.5


Now 0.5 isn't the time as in Noon

It is 0.5 or 1/2 a day