LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
Posts: 80
Default 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?
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert dates and times into serial number and compare serial numbers GARYWC Excel Programming 0 November 3rd 16 08:02 PM
serial numbers Naveed Excel Worksheet Functions 7 February 8th 09 10:28 AM
Convert serial numbers to dates lrl0870 Excel Worksheet Functions 1 March 6th 06 10:02 PM
to find missing serial numbers in randomly generated numbers B.H. Hadi Excel Worksheet Functions 2 December 1st 05 11:56 PM
Available serial numbers... Steff_DK[_6_] Excel Programming 6 April 28th 04 08:50 PM

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

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"