Login / Signup

Data Export timestamp in 2 cells (truncate)

 
Data Export
Last Post by e.mahaut 10 years ago
3 Posts
2 Users
0 Likes
26 Views
RSS
e.mahaut
 e.mahaut
(@e-mahautarcinfo-com)
Posts: 270
Member Moderator
Topic starter
 

Hi,

Have you already got a request from a customer to have the export timestamp in 2 cells instead of 1?
I guess it is not possible and improvement has already been declared as SPR.

Maybe one solution would be starting the export at column 3 and dedicate the first one for date and the second one for time, using Excel functions (in a template worksheet)

For example (Be careful about the function syntax, French Excel version below)
For date: =GAUCHE(Cx,TROUVE(" ",Cx)-1)
For time: =STXT(Cx,TROUVE(" ",Cx)+1 , 8 )
or =STXT(Cx,TROUVE(" ",Cx)+1, NBCAR(Cx)-TROUVE(" ",Cx))

x to replace by the row number.

Do you have other solutions?

BR
Edouard

 
Posted : 13/10/2016 5:23 pm
n.kunzer
 n.kunzer
(@n-kunzerarcinfo-com)
Posts: 1236
Member Moderator
 

Hi,

The formulae given by Edouard are working but I think that's not the one we should use (sorry Edouard!).
Better using the TEXT function (in English). Example: TEXT(,"MM/dd/YYYY") to extract the date. This function is better as it doesn't depend on the date format of the original cell.

You can find help on this function here: https://support.office.com/en-us/article/TEXT-function-20d5ac4d-7b94-49fd-bb38-93d29371225c

Nico

 
Posted : 14/10/2016 7:32 am
e.mahaut
 e.mahaut
(@e-mahautarcinfo-com)
Posts: 270
Member Moderator
Topic starter
 

Thank U Nico. It is great.
That's why I asked for other solution 😆

 
Posted : 14/10/2016 12:39 pm
Forum Jump:
  Previous Topic
Next Topic