Graph Activity by time of day

dhsilv2

Board Regular
Joined
Jul 8, 2014
Messages
54
Hi all,

I've managed to stump myself on what should be a fairly simple task. I have a data file with activity by time for employees. Each action has a time next to it. I'd like to create a chart that visualizes the breaks between actions so that one can see for example that someone took a lunch break for an hour or didn't start working until after their normal start time. For most users there may only be 50-100 actions per day which makes the visual a bit more tricky.

Thanks for your assistance.
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Watch MrExcel Video

Forum statistics

Threads
1,108,951
Messages
5,525,842
Members
409,666
Latest member
aquabit

This Week's Hot Topics

Top