EXCEL Time cell Format Change

[triballeoo]

Hello guys,

I need some help for changing the format of a cell.

Eg:

29.11(05:47) to 29.11.2016 05:47

<tbody>
</tbody>

Thank you!

 

[triballeoo]

29.11(05:47) ---to--- 29.11.2016 05:47

 

[FormR]

Hi, welcome to the forum!

Here is one option you can try:

Excel 2013
	A	B
1	29.11(05:47)	29/11/2016 05:47
Sheet1

Cell Formulas
Range	Formula
B1	=SUBSTITUTE(SUBSTITUTE(LEFT(A1,LEN(A1)-1),".","/"),"("," ")+0

 

[triballeoo]

Thank you!

Something does not work with this formula...but I can't figure it out why...

Hi, welcome to the forum!

Here is one option you can try:

Excel 2013

	A	B
1	29.11(05:47)	29/11/2016 05:47

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B1 =SUBSTITUTE(SUBSTITUTE(LEFT(A1,LEN(A1)-1),".","/"),"("," ")+0 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[FormR]

..Something does not work with this formula...

Hi, that doesn't really give us much to go on.

Do you get a wrong result? - if so what result did you get versus the result you expected?
Do you get an error message? - if so what is the error message?
Or something else? - if so, what are the details?