Find which cell in each row has the earliest date/time

How can I find which cell in each row has the earliest date/time?

(My spreadsheet has about 5,000 rows)


2015:03:06 16:21:25 2017:02:27 21:31:14 2017:02:27 21:31:14 2017:02:27 21:31:13 2015:03:06 16:21:25 2015:03:06 16:21:25
2015:03:06 16:23:30 2017:02:27 21:31:56 2017:02:27 21:31:56 2017:02:27 21:31:56 2015:03:06 16:23:30 2015:03:06 16:23:30
2015:03:06 16:24:33 2017:02:27 21:32:22 2017:02:27 21:32:22 2017:02:27 21:32:22 2015:03:06 16:24:33 2015:03:06 16:24:33
2015:03:28 21:26:24 2017:02:27 21:34:49 2017:02:27 21:34:49 2017:02:27 21:34:49 2015:03:28 21:26:24 2015:03:28 21:26:24
2015:03:28 21:26:30 2017:02:27 21:35:11 2017:02:27 21:35:11 2017:02:27 21:35:11 2015:03:28 21:26:30 2015:03:28 21:26:30
2015:03:28 21:26:53 2017:02:27 21:36:02 2017:02:27 21:36:02 2017:02:27 21:36:02 2015:03:28 21:26:53 2015:03:28 21:26:53
-------------------- 2017:02:28 11:49:42 2017:02:28 11:49:35 2017:02:28 11:49:35 -------------------- --------------------
-------------------- -------------------- 2017:03:02 21:09:02 2017:03:02 21:09:01 2017:03:02 21:09:01 --------------------
2015:10:19 16:32:01 2017:03:10 08:04:10 2017:03:10 08:04:10 2017:03:10 08:04:10 2015:10:19 16:32:01 2015:10:19 16:32:01
2017:03:12 15:49:33 2017:03:17 17:54:38 2017:03:17 17:53:50 2017:03:17 17:53:50 2017:03:12 15:49:33
2017:03:20 10:07:43 2017:03:20 03:07:43 2017:03:20 03:07:43 2017:03:20 03:07:43 2017:03:20 10:07:43 2017:03:20 10:07:43
2017:03:20 10:08:14 2017:03:20 03:08:14 2017:03:20 03:08:14 2017:03:20 03:08:14 2017:03:20 10:08:14 2017:03:20 10:08:14
-------------------- 2017:04:07 10:39:14 2017:04:07 10:39:14 2017:04:07 10:39:14 2016:06:10 04:32:12
-------------------- 2017:04:19 08:45:22 2017:04:19 08:45:22 2017:04:19 08:45:22 -------------------- --------------------
-------------------- 2017:05:14 06:47:48 2017:05:14 06:47:48 2017:05:14 06:47:48 -------------------- --------------------
2017:05:17 15:31:07 2017:05:17 08:31:07 2017:05:17 08:31:07 2017:05:17 08:31:07 2017:05:17 15:31:07 2017:05:17 15:31:07
-------------------- -------------------- -------------------- 2017:06:24 14:01:56 2017:06:24 14:01:56 2017:06:24 14:01:56

Where do I find "GO ADVANCED"?

Where is the posting tab of thread >>?

sample attached

Convert your data into a normal time format (2009.12.24 23:12:37) and then apply the formula.

Formula:

Please Login or Register  to view this content.

Another option without massive input.

Formula:

Please Login or Register  to view this content.

Czeslaw's formula -- =AGGREGATE(15,6,--SUBSTITUTE(SUBSTITUTE(B2:G2,":","-",1),":","-",1)/(B2:G2<>""),1) -- seems to provide the info I need. (I needed to know which cell(s) in each row contains the earliest date/time. I can then sort the rows so the photos are in the order they were taken)

Apply this formula

Formula:

Please Login or Register  to view this content.