PLC Date and time stamp in excel

[turbohamad]

Dear Members;

I make a date and time stamp by using GSV and SSV instructions.
The DINT array with 7 elements stores those values.

Now I want to read it and set the following format in excel in one cell-like
yyyy/mm/dd hh:mm:ss

How can i perform this tsk any help?

Regards

 

[janner_10]

Last time I did this I just converted the Date Time into a string and read this in Excel, the PLC did the work.

Or you can do the work in excel with CONCAT

 

[turbohamad]

@janner_10

Can you provide the piece of code here?

Thanks

 

[Operaghost]

Here is an example. The data is all on row 6 and the formula displayed is from C8. You could also do this with the "&" instead of CONCATENATE.

=CONCATENATE(B6,"/",C6,"/",D6," ",E6,":",F6,":",G6)
or
=B6 & "/" & C6 & "/" & D6 & " " & E6 & ":" & F6 & ":" & G6

OG

 

[cwal61]

http://www.plctalk.net/qanda/showthread.php?t=132130

see post #9 there is an exported subroutine to build timestamp.

 

[drbitboy]

Also, if you actually want a date: