Time format in text

[richiebkerry]

Hello, I have the below formula:

="The average driver worked an average of "&ROUND(AVERAGE(F48:G48,H48,F49,G49,H49,F50,G50,H50,F53,G53,H53,F56,G56,H56,F57,G57,H57),0)&" hours per week"

The above gives an answer of "The average driver worked an average of 2 hours per week"... I need an answer of "The average driver worked an average of 51:24 hours per week".

In the "custom" field the data is formatted using [h]:mm;@

If anybody can please help I would be greatly appreciative.

RK

 

[oldbrewer]

if it is 2.16 or close multiply by 24

 

[richiebkerry]

Thank you, now works

 

[richiebkerry]

if it is 2.16 or close multiply by 24

Thanks again, if I wanted the answer to two decimal places do you know how this could be done?

So I'd have:

The average person is working an average of 47:35 hours per week