How to choose hourly data to make 24 data set daily

Hi,

I want to 24 data set per day on hourly basis on each day. I am attaching sheet with this mail.

With regards,
Arun

See the forumrules

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more days have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.


I advice you also to remove your email adres (unless you are waiting for a lot of spam).

DEFINITELY remove your email address!!!

I have shown you where to start with this. However, there are some problems with your data on 2nd/3rd June. The columns are not correctly aligned. I fixed them and used SUMPRODUCT to deliver the result you want (I hope...).

I am confused. You asked for 24 results per day. I gave you 24 results per day (one per hour for each day in the range)

Now it seems that that may NOT be what you want. However, on your sheet, you do not indicate WHAT results you want or WHERE you want them. Please explain again.

How could I have guessed that is what you wanted from your intitial description!!??

So are these two threads asking for the same answer to the same question?