Darrelljenkins1985
New Member
- Joined
- May 1, 2017
- Messages
- 1
Hello,
Here is my situation I'm creating a new rental spreadsheet at my workplace We rent scooters and wheelchairs. The rental fee is $50 per 24hrs.
many of our renters like to keep them over the 24 hours, so I would like a way to keep track of how much is owed, past the initial rental fee. So, lets say they rent on 4/25/17, pay the initial fee (or not) and return it on 4/2717, they owe us an additional $50(or $100). I'm looking for something similar to this, any help would be great.
Date rented Date Returned Amount owed
4/25/17 4/27/17 $100
4/26/17 4/27/17 $50
4/28/17 4/28/17 $150
Here is my situation I'm creating a new rental spreadsheet at my workplace We rent scooters and wheelchairs. The rental fee is $50 per 24hrs.
many of our renters like to keep them over the 24 hours, so I would like a way to keep track of how much is owed, past the initial rental fee. So, lets say they rent on 4/25/17, pay the initial fee (or not) and return it on 4/2717, they owe us an additional $50(or $100). I'm looking for something similar to this, any help would be great.
Date rented Date Returned Amount owed
4/25/17 4/27/17 $100
4/26/17 4/27/17 $50
4/28/17 4/28/17 $150