Notifications
Clear all
General Excel Questions & Answers
5
Posts
4
Users
0
Reactions
1,311
Views
Topic starter
Hi All, welcome to another year.
Okay here's my issue; my data download has a Date Time Group (example: 18/01/24 10:50)
I have stripped the data into a graph by day of week, but can I do something similar to get time of day.
What I'm trying to establish is when the majority of calls are received: I want to block it into 6 hour periods.
TIA
Posted : 19/01/2024 7:25 pm
Hi Paul,
I've attached a file containing an example of how you could calculate the hourly groupings you describe. I left the intermediate steps in there so that it becomes easier to follow. Perhaps you can use any of this in your real data. If not, please come back here with a file of your own.
Riny
Posted : 20/01/2024 2:48 am
Looks real good 
Posted : 20/01/2024 2:57 am
Topic starter
Riny,
As always totally in awe of your ability, thanks so much.
Regards
Paul
Posted : 23/01/2024 2:31 am