I have 2 variables occupancy and turnover; I have 3 'absolutes' tariff ,
spaces and 10 operating hours per day.

The tariff is set at$1,1,2,2,1,1,2,2,2,2 for each operating hour in the day.
I need a formula to manipulate the data to show revenue generated per space
during the day. So:

09:00-10:00. $1. 95%(occ). 0%(t/o) Revenue = 95c
10:00-11:00. $1. 95% . 45%. Revenue = $2.35 [progressive]

The math is wrong but you get the idea

Thanks


--
Dan