Excel Formula

CP · Apr 28, 2006

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.

Alan · Apr 28, 2006

Custom format as:
yyyy-dd-mm" -23.59.00"
Regards,
Alan

Miguel Zapico · Apr 28, 2006

Try this one:
=INT(A1)+TIME(23,59,0)