Conversion from Excel time to labview time

[Ranjeet_Singh]

Hello crossrulz,

                                             I am attaching the VI. Please let me know where i am commiting the mistake.

I thinks this 1460 is the number of days from 1904(365*4)

Thanks,

[crossrulz]

What values are you getting as a result?  It comes out right for me.  Again, what time zone are you in?

[Ranjeet_Singh]

How to find the current time zone ?

& i think becasue of this experiment my current time zone(Whatever this was) spoiled. for time stmap 05-11-12 14:20:00 my number of second was 3419571000 & it was working perfectly from last 1.5 years. But now if i am converting this number of seconds to time than result is 11-05-12 14:20:00(date & month is interchanged).

Please help me to overcome this.

Thanks 

[Ranjeet_Singh]

My current time zone is "(UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi".

Ranjeet

[PhillipBrooks]

The TZ offset can be determined by comparing UTC time to local time.

In some timezones, Daylight Savings is practiced. The reasons are historical, but the important thing to understand is that the offset depends on the actual date. If it falls in the standard period of the year there is no offset. If the timestamp occurs in the 'savings time' period, you must adjust the offset.

I've attached a VI that will calculate the TZ seconds offset for a specified date. (LabVIEW 8.6)

[crossrulz]

---

@PhillipBrooks wrote:

The TZ offset can be determined by comparing UTC time to local time.

In some timezones, Daylight Savings is practiced. The reasons are historical, but the important thing to understand is that the offset depends on the actual date. If it falls in the standard period of the year there is no offset. If the timestamp occurs in the 'savings time' period, you must adjust the offset.

I've attached a VI that will calculate the TZ seconds offset for a specified date. (LabVIEW 8.6)

---

That's a handy little VI.  I'll have to keep that one around.

Ranjeet - As I said, I'm in Eastern Time, which is UTC-5 hours.  Which means the calculation is 10.5 hours off for you.  Use philip's VI to find your offset and put that in for the time zone constant.

[Ranjeet_Singh]

HI PhillipBrooks & crossrulz,

                                                  In my PC for the current time stamp the output of your VI is -19800. That is number of seconds for time 05:30:00. As this is perfect becasue i am working on UTC+5:30. Thanks for answer. 

But please let me know why my number of second for specific time stamp is changed which was working before. I never changed anything in my OS time setting. and now in the output time for the same input only minute & hour is interchaged. This is something logical. Please help me to understand this.

Thanks.

[Ranjeet_Singh]

Just take a look at my VI & run it. 

[Ranjeet_Singh]

Hey sorry friends,

                     Acutually this problem is coming when i am exporing excel from .net application. Can you please tell me why this problem is arised ?

In the labview platform its perfectly working(Thank to labview )

[RavensFan]

LabVIEW is working perfectly.  I don't see anything wrong with your VI besides the mini-race condition where the initial value of zero in the control to be read and used before the VI has a chance to set the control by way of the local variable.