Sorting data

Copper Contributor

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,




Screen Shot 2023-10-13 at 12.42.06.png

1 Reply


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.