Hi,
Thank you all for your help in advance.
I have a table that looks like:
Name Start_Time End_Time
-------- ----------------- -------------
Bob 1PM 5PM
I am making a chart that should count all the time from start to end and represent each hour by +1 on a bar graph.
Per my example above, I am trying to make it so that the hours 1, 2, 3, 4, and 5 all have +1 in a bar graph.
Is this possible?
I thought about doing a loop, putting each hour into a new column then concatenating each new hour into my new column.
Any better ideas?
