Sorting 'Time' formatted fields

[Curtis_Loew]

Hello,

I am working with some drivetime data and the data is the time format (eg 13:30). One hour and 6 mins is represented by 1:06:00 AM, 20 mins is represented by 12:20:00 AM, etc. I want to sort the list so I can look at things like how many commutes are greater than 1 hour but sort does not seem to work with time formatted data.

Does anyone have any tips or links on how to sort and work with time formatted data?

Thanks.

 

[Firefly2012]

Hi

Should work without a problem (times are just numeric values so nothing intrinsically difficult). Are you sure you have only times in the cells (ie you don't have a date component to the the value which might cause your values to sort differently to what you would like)?