How to convert DIAdem time from a number to a time

[jjandascog]

Have a DIAdem question, when creating a time channel using a script the time created displays as 15:21:28.4200 which is what I need to data evaluation in DIAdem.  Now when I give the TDMS files to another group using Matlab the same time reads in their matlab code as the follwoing number: 6.342690008842E+10.  This is the same number that DIAdem will dispaly if I change the type in the viewer.  How do I convert the 6.342690008842E+10 to a time so that the other group using the data can convert it to  a time also?

[Twigeater]

Hello!

I can't explain it better than Otmar did in this thread.

Matthias

[Otmar]

For some reason the link in Matthias' post doesn't work for me, so I added the post and the link again:

The starting point for DIAdem's date/time calculations is 01.01.0000 at 00:00:00. This time/date is the value '0'. The DIAdem time channels will be accurate until at least 12/31/2078, starting at 10/15/1582. This is due to changes made to the Gregorian calendar back in 1582 concerning leap years.

For instance, the date 04/18/2002 (April 18, 2002) at 1:00:00 PM (13:00:00 military time) would be the value 6.31862676E+10. This number represents the number of seconds that have passed since 01.01.0000 at 00:00:00.

DIAdem provides two functions to convert numbers into time data and time data into numerical data. They are TTR (time to real) and RTT (real to time). The DIAdem help system contains additional information and exmples on how to use these functions.

Let me know if there is any additional information I can help you with.

Click here for the link to my old post

Message Edited by Otmar on 12-14-2009 06:08 PM