Calculate the hours per bed in a week

Solved/Closed
Cecil - Jul 31, 2011 at 09:31 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 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 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
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