A
Anonymous
I am trying to automate the work to put a graph
together. Basically I have some issues reported in one
column and the time (in HH:MM format -- 9:00 AM) each
issue was reported in another column.
The problem is that I want a chart that displays how many
issues were reported in half hour increments (e.g., from
9:00 AM to 9:30 AM, etc.). Right now I am doing this
manually my creating another column with the half-hour
increments and basing my chart on this manually created
column. Basically if I had two values in this range in
my source column (9:15 AM and 9:22 AM) I then put the
value 2 in my manual column to represent the amount of
issues reported between 9:00 and 9:30. My chart uses the
column with "2" in it.
Ideally, I would just be able to use a formula to count
all values from the column that are in a particular half-
hour increment. Since COUNTIF and SUMIF only appear to
allow for one condition, I don't see how I can do this.
Does anyone have any suggestions for how to automatically
count how many values from a column fall within a half-
hour range?
Thanks.
together. Basically I have some issues reported in one
column and the time (in HH:MM format -- 9:00 AM) each
issue was reported in another column.
The problem is that I want a chart that displays how many
issues were reported in half hour increments (e.g., from
9:00 AM to 9:30 AM, etc.). Right now I am doing this
manually my creating another column with the half-hour
increments and basing my chart on this manually created
column. Basically if I had two values in this range in
my source column (9:15 AM and 9:22 AM) I then put the
value 2 in my manual column to represent the amount of
issues reported between 9:00 and 9:30. My chart uses the
column with "2" in it.
Ideally, I would just be able to use a formula to count
all values from the column that are in a particular half-
hour increment. Since COUNTIF and SUMIF only appear to
allow for one condition, I don't see how I can do this.
Does anyone have any suggestions for how to automatically
count how many values from a column fall within a half-
hour range?
Thanks.