creating values for the time in between

[#1]

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?

[marcus_sommer]

You could fill your data gaps with intervalmatch or a while-loop, see for example:

Creating Reference Dates for Intervals

IntervalMatch

- Marcus