downtime in hh:mm:ss.

Hi,

I am trying to calculate downtime in hh:mm:ss.
I have downtime as a percentage and I want to calculate what that equates to per machine in terms of time.

Site Average availability machines. Total downtime per month in hours. Downtime per machine per month in hours. Downtime per machine per Day in hours.
A 88% 13 87.6 6.738461538 0.023397436




Site Average availability machines Total downtime per month in hours. Downtime per machine per month in hours. Downtime per machine per Day in hours
A 0.88 13 =(24*(365/12))*(1-B2) =D2/C2 =(E2/12)/24



I have attached a simple set of sample data containing a few of the calculations but without success. The end goal is to see the average number of seconds, minutes and hours that each machine is down for, per site.

Any help would be much appreciated. Many thanks, Ben

Well, I am a little uncertain as to whether formula calculating downtime in hours is correct, but ultimately I am looking for the above numbers into time format. However, I question whether simply changing the format to 'time' is correct.....

For some reason my post did not work. That worked perfectly. Thank you so much