ExcelBanter - Convert dates and times into serial number and compare serial numbers

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

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

- - Convert dates and times into serial number and compare serial numbers (https://www.excelbanter.com/excel-programming/452506-convert-dates-times-into-serial-number-compare-serial-numbers.html)

GARYWC

Convert dates and times into serial number and compare serial numbers

Columns B thru G each contain a combination of a date and a time (format: ccyy:mm:dd hh:mm:sec)

How do I convert the contents of each cell to a serial number?

How do I then compare the serial numbers in each cell in each row to find the lowest serial number?

All times are GMT +1. The time now is 09:39 AM.