convert labview date/time to excel date/time

[JTB]

How do I convert the "seconds since 1904" from the function "Get Date/Time in Seconds" to an MS Excel date/time format? The application runs in the Solaris environment.

[ian_fung]

hi, I am not sure about Solaris env.

Maybe this will help in one way or another.


Regards
ian.f
Sg/My

[Olivier Zimmermann]

JTB a écrit:

>How do I convert the "seconds since 1904" from the function "Get
>Date/Time in Seconds" to an MS Excel date/time format? The
>application runs in the Solaris environment.
>
>
If a string-wise solution fits your need, just use "seconds to
date/time" - it returns an explicit cluster from which you should easily
manage to build a date string that Excel recognizes - oz

[ian_fung]

Sorry if it doesn't help.
I was having this vi created at the time i read your question. Furthermore, I am not in it (Solaris) at all.

Good luck!

[JTB]

This sounds useful. What format is Excel expecting. All I've seen is a date since 1900 or 1904. Are there fields in the MS Excel value?

[ian_fung]

remember to give a file name with .xls extension.

You will have the time/ date saved to MS Excel File.

[asimpleman]

"ian.f" wrote in message
news:506500000005000000DDA60000-1031838699000@exchange.ni.com...
> remember to give a file name with .xls extension.
>
> You will have the time/ date saved to MS Excel File.

I can't see the message you are responding to but I suspect I have a similar
problem. When I write date strings to an excel file it initially formats it
as a string and not a date. If I double click the cell then exit the cell
then excel reformats the cell to date. But so far I have not found a way to
reformat a large section of cells all at once. I tried highlighting the
column and reformatting them but it didn't take. This is with the excel
toolkit.

[Bill Symonds]

In article <506500000008000000025F0000-1031838699000@exchange.ni.com>,
x@no.email (JTB) wrote:

> How do I convert the "seconds since 1904" from the function "Get
> Date/Time in Seconds" to an MS Excel date/time format? The
> application runs in the Solaris environment.
>

Hi

I would break the date time string up into separate date and time strings
using some form of delimiter (a hard return, space or tab for example).
When you write that to a file and open in Excel the date and time will go
into separate columns.

HTH

Regards

Bill

mailto:wsymonds@clara.co.uk

[Yamaeda]

Mis-post