Split Rental Costs by % of time used

At "Price", enter the total rental price. At "Participants", add the total number of people that'll pay. Afterwards, you can select the number of users that only used the rental for a part of the time, to calculate their shares.

Please use a dot (.) as a decimal instead of a comma (,)

General Information

Partial "Renters"

Only enter participans that only used the rental for a part of the time. The cost and number of people that participated full time is calculated automatically. Leave "Group" fields you don't need empty.
To successfully use this formula, start with the (group of) people that participated for the shortest amount of time., increasing the participation time per used group.

Group 1

Group 2

Group 3

Group 4


Back

Result

Participants in Group 1 will have to pay

Participants in Group 2 will have to pay

Participants in Group 3 will have to pay

Participants in Group 4 will have to pay

Full time participants will have to pay