I'm using a sharepoint list to try to calculate the cost of bookings made for sports and other facilities, which are entered by start and end times.
A calculation field in the list, uses the formula below to calculate the cost of the booking in £.
=(End-Begin)*24*[Hourly Cost]
This works fine for 'one off' bookings, but if a booking with a recurrence is created, problems arise, as the cost is calculated as the total number of hours between the beginning of the first and end of thelast session in the
recurrence.
for example, a 10 weekly booking of two hours, rather than being calculated as 20 hours, works out as eg. 1500 hours as this is the total amount of time between the start time and the end time!
Please suggest any ways I could get around this problem.
thanks,
Simon
A calculation field in the list, uses the formula below to calculate the cost of the booking in £.
=(End-Begin)*24*[Hourly Cost]
This works fine for 'one off' bookings, but if a booking with a recurrence is created, problems arise, as the cost is calculated as the total number of hours between the beginning of the first and end of thelast session in the
recurrence.
for example, a 10 weekly booking of two hours, rather than being calculated as 20 hours, works out as eg. 1500 hours as this is the total amount of time between the start time and the end time!
Please suggest any ways I could get around this problem.
thanks,
Simon