Best profit hour

censura

New member
Joined
Nov 17, 2013
Messages
2
Reaction score
0
Points
0
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
 

Attachments

  • imageprofit.jpg
    imageprofit.jpg
    99.4 KB · Views: 20
  • profit by hour.xls
    104 KB · Views: 16
Top