Thread: Convert date/time to serial number and compare serial numbers
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
isabelle isabelle is offline
external usenet poster
  
Posts: 99
Default Convert date/time to serial number and compare serial numbers
Hi,

to transform a (text)date_time in real date_time
=DATE(LEFT(A1,4),MID(A1,6,2),MID(A1,9,2))+RIGHT(A1 ,8)
and change the format of the cell to the general format

isabelle

Le 2016-11-04 Ã* 10:59, GARYWC a écrit :
The cells have a text format.

Reply With QuoteReply With Quote