Sorting data

[youzz]

Hey everyone, 

I'm trying to sort the info on sales by which day sales the most and at what time, but I only have the information as presented below in Column D.

I'm wondering, is there any way I separate date and hour from Column D? 

And/or arrange it so I know which days and hours are the ones that sell the most

Thanks in advance,

Youzz

[#2]

@youzz 

A couple of functions that might get you started are

= WEEKDAY(datetime,2)

= HOUR(datetime)

where 'datetime' is a defined name applied to the column of data.  Then there will be some counting to do.