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 education cannot make anybody an expert programmer any more than studying brushes and pigment can make somebody an expert painter” - Eric Raymond