ExcelBanter - Excel Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel Formula (https://www.excelbanter.com/excel-worksheet-functions/85972-excel-formula.html)

Excel Formula

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

Excel Formula

Custom format as:
yyyy-dd-mm" -23.59.00"
Regards,
Alan
"CP" wrote in message
...
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.

Miguel Zapico

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.

All times are GMT +1. The time now is 07:59 PM.