TheBigCountry
New Member
I have an excel file with a column that has order date and time in the same cell.
Example:
ORDER_DATE_TIME
8/3/2015 9:27
8/3/2015 11:03
8/3/2015 11:09
8/3/2015 12:23
8/3/2015 15:45
8/3/2015 10:06
8/3/2015 10:08
8/3/2015 10:09
8/3/2015 10:11
8/3/2015 10:12
8/3/2015 13:13
8/3/2015 15:04
8/3/2015 15:14
8/4/2015 9:11
8/4/2015 9:24
8/4/2015 10:17
8/4/2015 12:57
8/4/2015 13:08
8/4/2015 13:14
8/4/2015 13:18
8/4/2015 14:24
8/4/2015 14:28
8/4/2015 14:27
I have this data for the past six months.
I want to create a graph that shows the amount of orders based on the day of the week and then based the hour (ie 8:00-9:00, 9:00-10:00, 10:00-11:00, etc)
Is there a way to make excel figure out that 8/3/2015 was a Monday and then categorize the times as well?
Thanks in advance!
Example:
ORDER_DATE_TIME
8/3/2015 9:27
8/3/2015 11:03
8/3/2015 11:09
8/3/2015 12:23
8/3/2015 15:45
8/3/2015 10:06
8/3/2015 10:08
8/3/2015 10:09
8/3/2015 10:11
8/3/2015 10:12
8/3/2015 13:13
8/3/2015 15:04
8/3/2015 15:14
8/4/2015 9:11
8/4/2015 9:24
8/4/2015 10:17
8/4/2015 12:57
8/4/2015 13:08
8/4/2015 13:14
8/4/2015 13:18
8/4/2015 14:24
8/4/2015 14:28
8/4/2015 14:27
I have this data for the past six months.
I want to create a graph that shows the amount of orders based on the day of the week and then based the hour (ie 8:00-9:00, 9:00-10:00, 10:00-11:00, etc)
Is there a way to make excel figure out that 8/3/2015 was a Monday and then categorize the times as well?
Thanks in advance!