I want to calculate which is the most profitable hour in the day across our business.
I have a table see attached That breaks down the profit per hour from 8 till 9pm.
One thing we need to ignore the first hour in the day as it is not a full hour and not reflective of the day
I want a new column which shows the daily highest hour profit and the hour in the next column ie £6750 11.00am
I have attached a image also hope this helps to explain
Thank you
I have a table see attached That breaks down the profit per hour from 8 till 9pm.
One thing we need to ignore the first hour in the day as it is not a full hour and not reflective of the day
I want a new column which shows the daily highest hour profit and the hour in the next column ie £6750 11.00am
I have attached a image also hope this helps to explain
Thank you