creating values for the time in between

Mon, 03 Aug 2015 15:12:44 GMT

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?

Re: creating values for the time in between

marcus_sommer — Mon, 03 Aug 2015 15:19:07 GMT

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

- Marcus