View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Auric__ Auric__ is offline
external usenet poster
 
Posts: 538
Default Convert date/time to serial number and compare serial numbers

GARYWC wrote:

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 numbers?

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


First explain what you want when you say "serial number".

As for finding the lowest, you could possibly use the MIN or MINA functions,
depending on your needs.

--
That's the problem with nature, something's always stinging you or
oozing mucous all over you. Let's go and watch TV.
-- Calvin