ExcelBanter - Convert to serial numbers and compare serial numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Convert to serial numbers and compare serial numbers (https://www.excelbanter.com/excel-programming/452507-convert-serial-numbers-compare-serial-numbers.html)

GARYWC

Convert to serial numbers and compare serial numbers

How can I convert "2015:12:25 14:01:38" and "2015:12:25 14:43:31" (format: ccyy:mm:dd hh:mm:sec) to a serial number?

How do I compare the resulting serial numbers to find the lowest serial number?

All times are GMT +1. The time now is 08:55 AM.