hi,

I have a whole column of time values --> 9:30, 11:00, 12:30.... etc.

I want to analysis this data, finding the max time( latest time), min time,
mode time, and
create a histogram out of it.

excel will tell me that time is a non-numeric data and refuses to create the
histogram.

any way around this?

thnks.