Create Intervals of every 15 minutes

[rustyfishbones]

Hi All,

I need to get this in a hurry.

I have a Calculated Dimension TIME(class(aggr(Time,Time),.25/24)) which gives me intervals of every 15 minutes

I want to create this in the Script, how can I do it

Regards

Alan

[hic · Accepted solution]

So, whats the rule? The four first digits denote hhmm ?

If so, you could use

Time(Floor(Time#(Left([Time-added],4),'hhmm'),1/24/4),'hh:mm')

I.e. first unpack the first four digits, then interpret them as hhmm, then round downwards to nearest quarter, then format as time again.

HIC

[rustyfishbones]

Hi Henric,

Yes, the 4 digits denotes hhmm

And it works! thanks so much

Regards

Alan

[rustyfishbones]

I actually ran into another problem where some of the time values contained spaces,

But I used TRIM and it worked!!