S
Shevus
Hello all!
I've done some fairly advanced Excel development, but this one has m
stumped...
I have a data set with "Time Start" and "Time Stop" columns for a wor
time tracking spreadsheet. I also have a "Duration" column if neede
(timestop -timestart).
The times are all rounded to 15 minute increments, and the data se
looks like this:
Time In Time Out Duration (hrs)
10:00 10:30 .5
10:30 13:15 2.75
13:15 16:30 3.25
10:00 10:45 .75
10:45 14:15 3.5
14:15 16:15 2
10:15 10:30 .25
10:30 13:15 2.75
13:15 16:30 3.25
10:00 10:45 .75
10:45 14:15 3.5
14:15 16:15 2
I want to graph the times being worked for a 24 hour day in order to se
when a person is typically working or not.
X Axis: 24 hour day in 15 minute increments
Y Axis: # of instances (In the above data 10:00 would have 3, 16:3
would have 2, 13:00 would have 4)
This should show kind of a bell curve, with the earlier and later hour
having few instances, curving up around 10:00, a dip around lunch time
and curving back down around 16:00.
I can create hundreds of columns and create formulas for each 15 minut
increment in the day to determine where a start-stop time falls, bu
before I do that I wonder if there's an easier way.
Thank you!
~Bria
I've done some fairly advanced Excel development, but this one has m
stumped...
I have a data set with "Time Start" and "Time Stop" columns for a wor
time tracking spreadsheet. I also have a "Duration" column if neede
(timestop -timestart).
The times are all rounded to 15 minute increments, and the data se
looks like this:
Time In Time Out Duration (hrs)
10:00 10:30 .5
10:30 13:15 2.75
13:15 16:30 3.25
10:00 10:45 .75
10:45 14:15 3.5
14:15 16:15 2
10:15 10:30 .25
10:30 13:15 2.75
13:15 16:30 3.25
10:00 10:45 .75
10:45 14:15 3.5
14:15 16:15 2
I want to graph the times being worked for a 24 hour day in order to se
when a person is typically working or not.
X Axis: 24 hour day in 15 minute increments
Y Axis: # of instances (In the above data 10:00 would have 3, 16:3
would have 2, 13:00 would have 4)
This should show kind of a bell curve, with the earlier and later hour
having few instances, curving up around 10:00, a dip around lunch time
and curving back down around 16:00.
I can create hundreds of columns and create formulas for each 15 minut
increment in the day to determine where a start-stop time falls, bu
before I do that I wonder if there's an easier way.
Thank you!
~Bria