Best profit hour

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

PS I have this posted here also http://www.ozgrid.com/forum/showthread.php?t=184192

Take a look at this.

write your wish date at D2, and put this formula at E2 for Best Profit
=MAX(IF(AND((DATE(YEAR(A2:A1738,MONTH(A2:A1738),DAY(A2:A1738))=D2),HOUR(A2:A1738)<>8),B2:B1738))

Put this at F2 for Hour
=SUMPRODUCT((DATE(YEAR(A2:A1738),MONTH(A2:A1738),DAY(A2:A1738))=D2)*(B2:B1738=E2)*(HOUR(A2:A1738)))

Remove first all 8:00 rows.
And what about the hours of 20 jun 1:00 -4:00 (rows 1200-1204)?

Hi, censura,

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

http://www.ozgrid.com/forum/showthread.php?t=184192

Ciao,
Holger