Maximum and Minimum Values

[sasha 99]

Hi Guys ,


I have a table with three columns
First contain date .. it take a form like (1/31/2018)
Second contain time .. it take a form like (0:00:00)
Third contain a variable speed that recorded for a mobile body


Now , I kindly ask your help to find a way for extracting the maximum & minmum speed that have been recorded each 30 minute , from 0:01:00 to 0:30:00 and from 0:31:00 to 1:00:00 and so on


Note :: Each interval period is ONLY half-hour , however that does not mean each interval consist of 30 Row , i mean some minute may be missed and haven't been recorded , which mean some interval would end in earlier time like 0:29:00 or 1:59:00

Thanks

 

[PaddyD]

I would:

1) create a new column that does the bucketting
2) Use this new column to feed a pivot table with max & min of the speed variable

With dates in col a and times in col b:

=a2+(ceiling(b2,"00:30"))

...should give you the buckets

 

[sasha 99]

Although , I don't know what you mean by "bucketting"
But any way , I appreciate your help and I got a solution for that problem
Thanks

 

[PaddyD]

re 'bucketing' - putting the individual values into broader (usually numerical) categories or 'buckets' - like half-hour buckets for individual minutes.

Glad you've got it sorted...