Forum Discussion

youzz's avatar
youzz
Copper Contributor
Oct 13, 2023

Sorting data

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

 

 

BI & Data Analysis
Excel
Excel on Mac
Formulas and Functions
  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Oct 13, 2023

    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.

Resources