split an interval in 15 min sub-intervals

[#1]

Hello,

I tried to solve a Qlik mystery without success, that's why i am trying to find an answer here. Thank you in advance for helping.

I have some production data from a machine, split into intervals of work.

Let's  say from 9:00 to 10:25 the machine produced 10 products.

How can I split the production in 15 min intervals of equal value of output?

Start     Stop     Production

9:00     9:15     1

9:15     9:30     1

9:30     9:45     1

...

you got the idea...

thank you so much,

Alex

[MarcoWedel]

So

15+15+5=45

?

[#3]

ah oh... 🙂

my mistake; in my rush to conceal the real data i did this mistake 🙂

[#4]

Now i have a new problem with the same data - Time zone plotted on a continuous chart