Steve

You could use a pivot table for this and under field settings (ie for
your Data field - which would be the time column) select Max.

Richard


Steve wrote:
I have identifiers in the E column(101, 102, etc), and corresponding time
values in the J column.
I need a formula in another cell that would give me the maximum time value
of all the 101's, resuling in (0:17)
And also in another cell the maximum value (0:43) of all the 102's.

E col J col
101 0:00
101
101 0:17
101
102 0:11
102 0:00
102 0:01
102
102 0:43
102 0:00
102 0:01
102 0:03
102 0:00

Thanks,
Steve