I am trying to calculated vehicle availability. I have a column which records the vehicle "downtime" in hours. In a standard 10 hour day I need to find the total percentage of it's actual working time and show the availability as a percentage. I have tried to get it right and I have got it to do a basic calculation, but it's not displaying as a percentage. When I formatted it...lets say 99.8 as a percentage...it gave me 998% in the cell. The other problem is that I haven't got a formula that takes into account that 100% of a workday is in fact only 10hours.

Can someone help me with this one please??

LOL...