Max usage of Avail Business Hours

[Eddieduce]

I have data for customer visits but want to build up on what I have.

month: Jan
Hours open: 116.5
Visits: 412
Average hours per visitor: 2

I am trying to find out what percentage of the 116.5 hours were taken advantage of by customers.

I have been testing modifying this formula: (xx / 24)*10/100 but didn't seem quite right.

Thanks.

 

[dfenton21]

Hi. Welcome to the Board. The syntax for percentage calculate is:

e.g. 75 as a percentage of 200:

=(75*100)/200

Hope this helps.