Thread: Excel Formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Miguel Zapico
 
Posts: n/a
Default Excel Formula
Try this one:
=INT(A1)+TIME(23,59,0)

"CP" wrote:

Hi Is there a formula to change a date in a cell such a as 01/12/2009 to read
"2009-01-12-23.59.00" ? The -23.59.00 being fixed. Thanks.

Reply With QuoteReply With Quote