Calculate the hours per bed in a week

Solved/Closed
Cecil - Jul 31, 2011 at 09:31 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 1, 2011 at 09:32 AM
Hello,

I need a formula to calculate the hours per bed in a week divided by average occupancy rate. Which formula I should use?

Many thanks!
C

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Aug 1, 2011 at 09:32 AM
Hi Cecil,

Well, if you put the hours per bed in a week in cell A1 and the average occupancy rate in A2 use the formula: =A1/A2.

But I can't imagine that that is the answer. So please provide more details.

Best regards,
Trowa
0