1 Reply Latest reply: Aug 3, 2015 11:19 AM by Marcus Sommer RSS

    creating values for the time in between

    Gabe M

      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?