Forum

Notifications
Clear all

Time of Day

5 Posts
4 Users
0 Reactions
113 Views
(@paul-sanft)
Posts: 35
Trusted Member
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
Riny van Eekelen
(@riny)
Posts: 1195
Member Moderator
 

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
(@keebellah)
Posts: 373
Reputable Member
 

Looks real good Cool

 
Posted : 20/01/2024 2:57 am
Alan Sidman
(@alansidman)
Posts: 223
Member Moderator
 

@Riny

Very slick.  I like how you did this!!

 
Posted : 20/01/2024 4:51 pm
(@paul-sanft)
Posts: 35
Trusted Member
Topic starter
 

Riny,

As always totally in awe of your ability, thanks so much.

 

Regards

Paul

 
Posted : 23/01/2024 2:31 am
Share: