Filter date time data so I only get one data point per hour

[jappi]

Hi - data sample attached. The date time reporting intervals in column A are every 10 mins, all day, across multiple dates. My goal:

1. Create a line graph that only has an event per hour. I don't really mind what time within the hour it is, as long as its consistent. E.g. show every event at h:06m
2. I want to filter out anything that is before 8am and after 6pm and ideally, not include Saturday or Sunday but the latter is a nice to have which I could manage manually if need be
3. I can then select which of the columns from B onwards I want to show in the line graphs

Thanks in advance

 

[awoohaw]

what version of excel do you have? please display this on your profile button, by updating your profile.
How are you breaking ties? What if there is no value at exactly an "00:06:00" (or whichever minute interval) you want?

Is this a question on an excel competency exam?

 

[jappi]

what version of excel do you have? please display this on your profile button, by updating your profile.
How are you breaking ties? What if there is no value at exactly an "00:06:00" (or whichever minute interval) you want?

I'm on Mac v16.81 (profile updated). Not sure what you mean by "breaking ties". The intervals are set, there should always be an event at each interval. Thanks

 

[awoohaw]

What version of excel???
and your data seems to already be filtered at 00:06:00 intervals then.

 

[jappi]

What version of excel???
and your data seems to already be filtered at 00:06:00 intervals then.

As per above, excel version is 365 for Mac v16.81. This is all it says for my version.

Yes, data is already filtered at10min intervals but I want to filter it to show only one interval per hour. e.g. 1/3/2024 8:06:00 am, 1/3/2024 9:06:00 am, 1/3/2024 10:06:00 am and so on.....

 

[awoohaw]

where is 365 mentioned here:

 

[jappi]

where is 365 mentioned here:
View attachment 108408

Seriously?......I just edited it to help you further. Sorry to bother you. If someone else is more happy to help then that would be great.

 

[Cubist]

Can you post the sample data using the XL2BB?

 

[jappi]

Can you post the sample data using the XL2BB?

Thanks. I downloaded the plugin and I can see it in my Excel menu but when I click on the icon, nothing happens. Any suggestions please? See image

 

[Peter_SSs]

Seriously?.

We are just asking you to include your version (365) in your account details so that it is always visible to your helpers - like this.

Click your user name at the top right of the forum, then ‘Account details', update the details & don’t forget to scroll down & ‘Save’

I downloaded the plugin and I can see it in my Excel menu but when I click on the icon, nothing happens.

Have a look through this thread.