LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 31st 12, 05:07 PM
Junior Member
First recorded activity by ExcelBanter: Oct 2012
Posts: 1
Default Graph usage for times of day

Hello all!

I've done some fairly advanced Excel development, but this one has me stumped...

I have a data set with "Time Start" and "Time Stop" columns for a work time tracking spreadsheet. I also have a "Duration" column if needed (timestop -timestart).

The times are all rounded to 15 minute increments, and the data set 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 see 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:30 would have 2, 13:00 would have 4)

This should show kind of a bell curve, with the earlier and later hours 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 minute increment in the day to determine where a start-stop time falls, but before I do that I wonder if there's an easier way.

Thank you!


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Help please to get times of date into a graph sandra r Excel Discussion (Misc queries) 2 July 30th 09 10:58 PM
plot schedule-type data in graph, date and times as x & y axes weblun Charts and Charting in Excel 1 May 6th 09 09:30 AM
How can I graph the #of times a certain word is found in Excel? STP Charts and Charting in Excel 1 May 28th 08 09:32 AM
Create a graph that compares start and finish times between employ Graham Moore Charts and Charting in Excel 1 October 23rd 07 08:41 AM
Overlap times formula/graph PauloG Excel Discussion (Misc queries) 1 May 18th 07 06:46 PM

All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017