Thread: Convert dates and times into serial number and compare serial numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GARYWC GARYWC is offline
external usenet poster
  
Posts: 80
Default 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?
Reply With QuoteReply With Quote