Timeline Help

[Jake_1]

Sorry if this is in the wrong category.

Attached is raw data about what an agent has done throughout their day. And I want to be able to present it in a visually digestible way i.e a timeline of Agent1's day and their code usage. If not a timeline, then some way of formatting the data to still show it visually.

Any help would be appreciated as I'm struggling with this.

[MarvinP]

Hi Jake,

How about trying to use a Pivot Table and group the times by hours? See the attached:
AGENT STATUS REPORT Pivot.xlsx

[Jake_1]

Not a bad idea thank you. However it's more beneficial if exact times can be displayed for accurate tracking of behaviours/patterns.