Hi,

Am Mon, 10 Oct 2016 22:24:05 -0700 (PDT) schrieb GARYWC:

A1 and B1 have a text format.

A1 contains 2016:08:11 23:50:55
B1 contains 2016:08:07 14:47:31

What formula will determine which cell contains the earliest date/time?

MIN date: =MIN(DATEVALUE(SUBSTITUTE(LEFT(A1:B1,10),":","/")))
MIN time: =MIN(1*RIGHT(A1:B1,8))
MIN timestamp: =MIN(DATEVALUE(SUBSTITUTE(LEFT(A1:B1,10),":","/"))+1*RIGHT(A1:B1,8))

All formulas are array formulas to enter with CTRL+Shift+Enter


Regards
Claus B.
--
Windows10
Office 2016