Write to Spreadsheet Time In Decimal Seconds

[Jim_Browne]

Hello,

Hopefully simple question here, although my attempts to find a solution have been fruitless.

I am writing several signals to a spreadsheet (triggered by a button), but the time column(s) are showing up as date and time.  Is there a way to get them to display as decimal seconds (relative or absolute, either one is better than "4/9/2013  6:10:49 PM".  I don't want to use an LVM file as the "Write to Measurement" VI doesn't allow me to control recording with a button and prompt the user for a new file location when record is pressed.

Thanks for the help!

[crossrulz]

Can you provide some code to show your issue?  A sample output files of what you want and another for what you currently have would also be helpful.

[DFGray]

Look at %<>T formatting options in the LabVIEW help.  This can be used with timestamps being formatted to strings or directly into files.  Alternately, you can use Seconds to Date/Time to convert a timestamp to a cluster and build up your time string with traditional string formatting from the elements of the cluster.