Slicer for 12 hour period

[c3ham]

Hi

Is it possible to make slicer for 12 hour period from 6am to 6pm and 6pm to 6am? If so how would I do this

Any help would be greatly appreciated

Thank you
Craig

 

[tyija1995]

Hey & welcome to the forum!

Are you trying to filter a table between the hours of 6am - 6pm?

Do you have a Time column in your data?

It depends how your data is laid out, we would need to see some sample data to fully understand the request.

 

[c3ham]

Hi tyija

Yes I am trying to filter data to a shift basis, I have a plc data logging counts to a table every 15minutes. I would like to be able to slice a pivot table or chart to show the shift ie 6am to 6pm or 6pm to 6am. The data I have has date and time in the same cell example (12/01/19 14:07)

 

[SpillerBD]

You will want to round your time values to the appropriate 15 minute mark.

=MROUND(A2,TIME(0,15,0))-TIME(0,15,0)

or

=MROUND(A2,TIME(0,15,0))

You will also need the time mark by itself. This would be used as your slicer

=MOD(MROUND(A2,TIME(0,15,0)),1)

 

[c3ham]

Thanks for the help will try it tomorrow ?