vba Finland
  • 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

  • 14 years ago

    HI Miika,


    This sort of thing could be accomplished with formulas i guess.


    Can you provide a sample of the data you are using and i will code a formula to do it for you?



Post a reply

Enter your message below

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Computer Science is no more about computers than astronomy is about telescopes.” - E. W. Dijkstra