View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
GARYWC GARYWC is offline
external usenet poster
 
Posts: 80
Default Compare cell contents

The cells containing the text-formatted strings are C1 and D1.

C1 contains: 2016:08:23 18:43:05
D1 contains: 2016:08:21 17:39:36

so I changed your formulas to:

=MIN(DATEVALUE(SUBSTITUTE(LEFT(C1:D1,10),":","/")))
=MIN(1*RIGHT(C1:D1,8))
=MIN(DATEVALUE(SUBSTITUTE(LEFT(C1:D1,10),":","/"))+1*RIGHT(C1:D1,8))

When I paste those new formulas into my spreadsheet, the three results are #VALUE!

Why don't I get usable results?