Calculate the hours per bed in a week

Solved/Closed
Cecil - 31 Jul 2011 à 09:31
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 1 Aug 2011 à 09:32
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
Related:

1 response

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
1 Aug 2011 à 09:32
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