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
PS i have this placed here as well http://www.excelforum.com/exce…fit-hour.html#post3479276 and [INDENT]http://www.excelguru.ca/forums/showt...st-profit-hour