mapping corresponding records between multiple timestamps

[rakhikk]

Hi,

I have below different time ranges and i have to map data to each of the time range. The time range would be for each order number , time range would be time between 2 & 1, 3&2, 4&3 and so on..I want to create time range buckets and map the same against different data set with time stamps (based on above time ranges) For example - A record with time stamp 12:00:30 should be mapped against time range 11:23:02 to  13:22:34.

Appreciate help..

Order number	Time	record number
12345	11:23:02	1
12345	13:22:34	2
12345	14:03:06	3
12345	15:03:06	4
45678	10:23:02	1
45678	12:23:02	2
45678	14:23:06	3

[alexnajm]

Use a Multi row Formula to create those ranges - something like [Row+1:Time] as a new column should do the trick. Make sure you group by Order Number though as well!

[Qiu · Accepted solution]

@rakhikk 
I am not quite sure your final result should look like.
Just out of my imagination, similar approach with @alexnajm 

[rakhikk]

Hi, Thank you for the solution. It worked!!!