Hi,

Are the double quotes in the cell or something you added when posting?

Mike

"Rita Brasher" wrote:

Ok the problem is my cells are formatted as text, so the MIN and MAX
funstions will not work. Any ideas on how to get "2008-10-10 08:15:54"
to be recognized as a date/time field?



Rita Brasher wrote:
Office XP Professional



I have a range of cells, some may be empty - others will not. I need to
find the minimum value for the populated cells. How do I exclude the
empty cells in my formula?

Thanks in advance for any help!

Rita Brasher
Project Engineer / IPEG Int'l MIS and Training
FedEx Express