Time Format Data Conversion

1 view (last 30 days)
T
T on 19 Oct 2012
Here is one set of time data in seconds that is imported 3401.82409375 3443.09343269231 3450.68662723214 3456.25735677083 3458.4955078125 3468.43663570804 3479.25066346154 3481.85364375 4591.54526201923
and after importing this data, the output is:
1.0e+003 *
3.4018
3.4431
3.4507
3.4585
3.4684
3.4793
3.4819
my concern is with another set of data that I am trying to syncronize with the other set of data: 42:46.0 42:46.0 42:46.0 42:46.0 42:46.0 42:46.0 42:46.0 42:46.0 42:46.0
Using the following script:
[Y, M, D, H, MN, S] = datevec(data{2}); out = H*3600+MN*60+S; subplot(2,1,2), plot(out, data_to_plot)
gives me the following output:
3.8629
3.8630
3.8630
3.8630
3.8630
3.8630
3.8630
3.8630
3.8630
3.8630
Should I expected a similar magnitude of e+003? If not, how can I shift the second set of data to match the one on the left? I tried adding 3000 but it remained constant.
  4 Comments
T
T on 19 Oct 2012
Why would the following:
[Y, M, D, H, MN, S] = datevec(data{2}); out = H*3600+MN*60+S;
Give me values of the order 0e+003 * 3.4018 3.4431 and so on as opposed to
3401.8 and 3443.1 and so on?
Walter Roberson
Walter Roberson on 19 Oct 2012
Give the command
format long
and display the output again.

Sign in to comment.

Accepted Answer

Walter Roberson
Walter Roberson on 19 Oct 2012
datevec(data{2}, 'MM:SS.FFF')
would be my guess. The output would be in the same magnitude as the 3.4801E3... but about 1000 smaller. Your 3400-ish values are on the order of 50 minutes rather than 42.
  2 Comments
T
T on 19 Oct 2012
I generate a weird signal when I plot the data using that command. I also obtain an arbitrary vertical line 2000 s after the main signal.
T
T on 22 Oct 2012
Sorry, what did you mean of the order of 50 minutes rather than 42? Of what significance is this? I just leave the data as it is.

Sign in to comment.

More Answers (0)

Categories

Find more on MATLAB in Help Center and File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!