Thread: Converting text format of time/date into Excel time/date for subtr
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Converting text format of time/date into Excel time/date for subtr
=DATEVALUE(LEFT(A1,FIND(" ",A1)-1))+TIMEVALUE(MID(A1,FIND(" ",A1)+1,256))
--
Gary''s Student - gsnu201001


"YY san." wrote:

Hi,
I need some help on date. I have the date and time in text format.
13/01/2010 10:34 AM
13/01/2010 1:56 PM

I need a formula to convert them to excel date/time format so that I can do
subtraction between these dates.

Thank you very much,
YY

Reply With QuoteReply With Quote