You could try this:

First, use a "helper" column to extract the time.
With values starting in A1, enter this in B1:

=--LEFT(A1,LEN(A1)-3)

And copy down as needed.

Then, format a cell to "Time", and enter this formula:
=MODE(B1:B100)
Using the actual cell range that you used in ColumnB.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Bear" wrote in message
oups.com...
I have a worksheet in which the cells contain times followed by a 2
digit code. For example "2:30 AG". I was wondering if there is any way
to find the time that occures most, ignoring the 2 digit code.

The long term goal is to be able to determine at what times these
occurances happen and create a graph that represents those peak times.