LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?
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 date to serial number callbr549 Excel Programming 12 March 30th 09 10:35 PM
Convert serial numbers to dates lrl0870 Excel Worksheet Functions 1 March 6th 06 10:02 PM
Mode Between Two Serial Dates/Times ChrisM[_3_] Excel Programming 1 November 18th 05 03:11 AM
Mode between two serial dates/times ChrisM Excel Worksheet Functions 1 November 17th 05 10:41 PM
Convert date to serial number in VBA Michael J. Malinsky Excel Programming 1 September 10th 03 08:43 PM

All times are GMT +1. The time now is 08:54 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"