Using MIN and MAX Function to find times

[endora75]

Hi everyone:

I am trying to find the minimum and maximum start and end times from a column of dates and times. I've attached a sample Excel document.

Originally, I tried to use the MIN function for the minimum start time.
Instead of using 3/8/10 11:55 AM as the minimum start time (Cell B4),
I want to use 1:25 AM instead (Cell B2).

The same goes for the MAX function for the maximum start time.
Instead of using 3/18/2010 1:25:26 AM as the maximum start time (Cell B2),
I want to use 4:15 PM instead (Cell B3)

Using tips from previous replies to my post, I thought I could extract the times (Columns E and F) and use the MIN & MAX functions. Instead, Excel is showing 12:00:00 AM in all of the summary fields (F7, F8, F9, and F10).

Thanks in advance for your help (again)!