Thread: Converting text format of time/date into Excel time/date for subtr
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
YY san.[_2_] YY san.[_2_] is offline
external usenet poster
  
Posts: 27
Default Converting text format of time/date into Excel time/date for subtr
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