Collecting data to make a excel graph
-
I have 2 date time entries that represent time in and time out. I want to graph this data representing how many people or on the clock per 15 minute intervals. Should I create a temp table that holds the qty of people that are clocked in for every 15 minute interval or what?
-
I have 2 date time entries that represent time in and time out. I want to graph this data representing how many people or on the clock per 15 minute intervals. Should I create a temp table that holds the qty of people that are clocked in for every 15 minute interval or what?
hello, absolutly you need to split your timeline with 15min step, you can do that by changing the attribute of the date cell in to a number , thus you get a number representing the cumulative of days or minutes or seconds since 01/01/1900 , the default setting is days. Leo.B Sources: "learning without thinking is useless" 9Apps Lucky Patcher VidMate
-
I have 2 date time entries that represent time in and time out. I want to graph this data representing how many people or on the clock per 15 minute intervals. Should I create a temp table that holds the qty of people that are clocked in for every 15 minute interval or what?
I usually use a view to service this type of requirement. Craft the view to supply only the required data eg date, starttime in 15 minute groupings and the number of people falling into the slots who are clocked on. End time only represents a person not clocked on and is irrelevant to the graph.
Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP