Group with respect to date and time

[abdul khader]

I do have weekly data consisting of orders.
How to find which 12hour was the busiest..?
The grouping option available in the pivot table doesn't display what my Boss wants.
My Boss wants the data something Like

01/01/2018-00:00-01/01/2018 12:00 - x orders.
01/01/2018-01:00-01/01/2018 13:00 - y orders.
.
.
.
.
.
01/01/2018- 20:00-02/01/2018 08:00-z orders.
.
.

[FerdyHar]

This is a duplicate post of https://www.excelforum.com/excel-gen...t-to-time.html.

This is against forum rule 5 (link)

...
5. Do not open more than ONE thread per issue here. Expect duplicates to be closed.
...

[abdul khader]

Nope, the question isn't the same.
I wanted constant hourly analysis in the previous question and hourly analysis with respect to date in this one

[JeteMc]

Seems as if Kaper answered your question in the 'hourly analysis' thread, so it would be appropriate to mark that one as 'Solved' using the thread tools drop down in the ribbon above your first post in that thread.
As for this thread it might help if you could upload a sample spreadsheet that shows an example of the data as well as the output format your boss wants displayed based on that data.
To upload a sample workbook (not a picture or pasted copy), click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.