Group

[noval45]

How can i group this type of data in my pivot( weekly per hour )where dates and times are combinedined together in  same cells in the raw data 

When i try it says cannot group selection , its an extensive list, 

say nov 12 to nov 18 should be in the same week and for week 1 . it should break it down to hourly 24 hours like in second screenshot, same for week 2 and 3 

[#2]

Attach a sample file and show your desired output to that file manually so that we can make that by formula.

[#3]

Heres a screen shot of expected outcome group by week and24 hrs breakdown for every week

[#4]

@noval45 

When i try it says cannot group selection , it's an extensive list

This error suggests one or both of the following is true:

1. Those dates are texts

2. There's non-dates mixed with the text

From the screen capture, my guess is it's #1.

Convert numbers stored as text to numbers - Microsoft Support

[#5]

@Patrick2788 Thanks, Tried to convert to numbers still doesnt work.

whats the fix for option 2

[#6]

If you want to group for dates in a pivot table, dates must be the only data type in the field.

[#7]

 will check thanks