Spreadsheet: 692362d1598291811-converting-minutes-seconds-and-milliseconds-to-a-decimal-value-in-seconds-times_rick_2
Sheet: Freestyle

 |  |  |  |  |  |  |  | Desired answer (time in seconds) |  |  |  | 65 | 64.6
 |  |  |  |  |  |  |  | Multiplying by 86400 and re-formating
 | 100 [NAME]
 | 2020-02-01 00:00:00 | 2020-02-02 00:00:00 | 2020-02-03 00:00:00 | 2020-02-04 00:00:00 | 2020-02-05 00:00:00 | 2020-02-06 00:00:00 | 2020-02-07 00:00:00 | 2020-02-08 00:00:00 | 2020-02-09 00:00:00 | 2020-02-10 00:00:00 | 2020-02-11 00:00:00 | 2020-02-12 00:00:00 | 2020-02-13 00:00:00 | 2020-02-14 00:00:00 | 2020-02-15 00:00:00 | 2020-02-16 00:00:00 | 2020-02-17 00:00:00 | 2020-02-18 00:00:00 | 2020-02-19 00:00:00 | 2020-02-20 00:00:00 | 2020-02-21 00:00:00 | 2020-02-22 00:00:00 | 2020-02-23 00:00:00 | 2020-02-24 00:00:00 | 2020-02-25 00:00:00 | 2020-02-26 00:00:00 | 2020-02-27 00:00:00 | 2020-02-28 00:00:00 | 2020-02-29 00:00:00 | 01:03:20 | 2020-03-02 00:00:00 | 2020-03-03 00:00:00 | 2020-03-04 00:00:00 | 2020-03-05 00:00:00 | 2020-03-06 00:00:00 | 2020-03-07 00:00:00 | 2020-03-08 00:00:00 | 2020-03-09 00:00:00 | 2020-03-10 00:00:00 | 2020-03-11 00:00:00 | 2020-03-12 00:00:00 | 2020-03-13 00:00:00
Name 1 |  |  | 01:09:00 |  | 58.5 |  |  |  |  |  |  | 00:01:05 | 00:01:04.600000 |  |  |  | 01:14:00 | 55.4 |  |  |  |  | 01:09:00 |  |  |  | 1:05.1 | 01:03:00 |  |  | 1:16.5 |  |  | 1:00.1
Name 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:13:00 | 1:06.3 |  |  |  |  |  |  |  |  |  |  |  |  | 1:12.5
Name 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:10:00 | 59.6 | 01:07:00 |  |  |  |  |  |  |  |  |  |  |  | 01:04:00
Name 4 |  |  |  |  |  |  |  |  |  |  |  | 1:15.5 |  |  |  |  | 01:18:00 | 1:08.3 | 01:08:00 |  |  |  |  |  |  |  |  |  |  |  | 1:16.5 |  |  |  |  | 1:17.6
Name 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:22.5
Name 6
Name 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:08:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:09.5
Name 8 |  |  |  |  |  | 01:10:00 |  |  |  |  |  |  | 1:07.2 |  |  |  |  | 1:00.4 |  |  |  |  |  |  |  |  |  | 1:03.9 |  |  |  |  |  | 1:05.7 |  |  |  |  |  |  | 01:08:00
Name 9 |  |  | 01:09:00 |  |  | 1:08.5 |  |  |  |  |  | 1:05.2 | 1:04.6 |  |  |  |  |  | 1:07.5 |  |  |  |  |  |  |  |  | 59
Name 10 |  |  | 01:12:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:11:00
Name 11 |  |  | 01:12:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:11.5 | 01:12:00
Name 12 |  |  |  |  | 01:08:00 |  |  |  |  |  |  | 1:12.2 |  |  |  |  |  | 01:02:00 | 01:10:00 |  |  |  |  |  |  |  |  | 1:09.5 |  |  |  |  | 01:07:00 |  |  |  |  |  |  | 01:09:00 | 1:09.5
Name 13
Name 14 |  |  | 1:34.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:14:00 |  | 01:16:00
Name 15 |  |  | 1:28.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:23:00 |  | 01:16:00 |  |  |  |  |  |  |  |  |  |  |  | 1:15.5
Name 16 |  |  |  |  | 01:10:00 | 01:17:00 |  |  |  |  |  | 1:14.8 |  |  |  |  |  | 01:08:00 | 01:18:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:12:00 | 1:15.4 |  | 1:22* |  |  |  | 1:14.3
Name 17 |  |  | 1:11.5 |  |  | 01:10:00 |  |  |  |  |  | 01:09:00 | 1:08.4 |  |  |  |  | 1:03.2 | 01:10:00 |  |  |  | 1:13.5 |  |  |  | 1:10.2 | 1:05.2
Name 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:05.7
Name 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:12:00
Name 20 |  |  |  |  | 01:09:00 | 1:11.5 |  |  |  |  |  | 1:07.8 | 01:08:00 |  |  |  | 01:18:00 | 01:02:00 | 01:10:00