Perhaps one way ..
Assuming the sample data:
> 5/7/04 16:03 Jon Smith
> 5/10/04 9:02 Raul
[quoted text clipped - 6 lines]
> 5/13/04 16:12 RVN
> 5/14/04 8:19 Roger
is in A1:A10
Let's split the data first
Select col A
Click Data > Text to columns
("Delimited" will be selected)
Click Next
In step2 of the wiz.:
Check the box for "space" > click Next
In step3 of wiz.:
In the data preview pane: click to select the first col (the dates col)
Select "MDY" from the drop menu under "Col data format"
Click Finish
The original data in col A will be split
into 4 cols, A to D: Date, Time, Name1 & Name2
Now to apply the cond format:
Select A1:D10
(i.e. the entire sample data range)
Click Format > Conditional Formatting
Under Condition 1, make the settings:
Formula Is | =$B1>TIMEVALUE("9:00 AM")
Click Format button > Patterns tab > Light blue? > OK
Click OK at the main dialog
The above should accomplish what you want:
Rows where the time in col B is > 9:00 am
will be coloured light blue

Signature
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----
> 5/7/04 16:03 Jon Smith
> 5/10/04 9:02 Raul
[quoted text clipped - 20 lines]
> ---
> Message posted from http://www.ExcelForum.com/
Max - 16 Sep 2004 12:38 GMT
Oops, sorry, missed this line in your post..
> > NOTE: Time and Date are in the same column, while names are in a
> > different column
but the suggested steps are similar ..
viz. split the Time and date into 2 separate cols first
via Data > Text to Columns
(Precaution: to prevent the above
overwriting the adjacent names col,
do insert an extra col first in-between)
Then just select the entire range
and apply the cond formatting

Signature
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----
introduce headings for each column
highlight the whole data includng headings
click <data(menu)-filter-autofilter>
click arrow right of <time> column
click <custom>
in custom auto filter window
choose<greater than> and flll in righ hand side 9:00(use colon) and clik
ok.
only those data (all 3 columns) where time is >9:00 will be visible copy
this visible data somewhere else for f;uther manipulation.
-------------------------------------
> 5/7/04 16:03 Jon Smith
> 5/10/04 9:02 Raul
[quoted text clipped - 20 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Signature
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/