Hi,
I work at a call center and we have changed our phone service provider. Unfortunately, the new call reporting system is missing some of the reports we are used too.
We have all the calls data and with pivot tables I managed to get most of the reports such as average talk time etct.
What brought me here is that I was looking for a way to have the data displayed in 30 min intervals and I found it here : Grouping by time in pivot table
However, before I can try this method, the current reports give us the Call start time of each call in a single cell like this : 05/27/2020, 10:55:47 AM
How do I extract just the time, in this case it would be 10:55:47?
Thanks
I work at a call center and we have changed our phone service provider. Unfortunately, the new call reporting system is missing some of the reports we are used too.
We have all the calls data and with pivot tables I managed to get most of the reports such as average talk time etct.
What brought me here is that I was looking for a way to have the data displayed in 30 min intervals and I found it here : Grouping by time in pivot table
However, before I can try this method, the current reports give us the Call start time of each call in a single cell like this : 05/27/2020, 10:55:47 AM
How do I extract just the time, in this case it would be 10:55:47?
Thanks