Hello I have a rooming list and need to identify what will be the total cost per person depending on the hotel they stay in and dates. Here is the information:
I have 4 hotels each with a different price that we have pre-paid for the guest. If I add the name of the hotel to the row I would like it to generate the total cost of the room for that individual by automatically calculating it against the number of nights.
On top of that I need to add 24.20€ per room. We pre-pay the rooms, however some might extend their stay and this they will have to pay upon departure and this needs to be summed up in another column.
Thanks
I have 4 hotels each with a different price that we have pre-paid for the guest. If I add the name of the hotel to the row I would like it to generate the total cost of the room for that individual by automatically calculating it against the number of nights.
On top of that I need to add 24.20€ per room. We pre-pay the rooms, however some might extend their stay and this they will have to pay upon departure and this needs to be summed up in another column.
Hotel | 06/12 | 07/12 | 08/12 | 09/12 | Pre paid | Pay onsite |
Hotel A | 1 | 1 | 1 | 1 | Price for 07/12 + 08.12 + 24.20€ | Price for 06/12+09/12 |
Hotel B | 1 | 1 | Price for 07/12 + 08.12 + 24.20€ |