Booking

• • Reply

  14 years ago

  by Miika

  Miika Suonio

  , Finland

  Joined 14 years ago

  I have a table with hall bookings. In the table there are: Date, Weekday and Sesion. Each weekday has three sesions, Morning, Afternoon and Evening. I have recorded the bookings as they have come in, the are not in calendar format. Now I need to calculate the monthly procentage booking of each slot e.g. how often there is a booking on Monday Evening for a particular month.

  I think I need to use (number of bookings in a month) / (total number of slots ina month)

  Thank you

  Report abuse