MATLAB Time difference function
up vote
-2
down vote
favorite
I read an excel sheet, with time format into matlab. Using the function datastr()
My code is as follows:
time = datestr(A(:,1), 'HH:MM:SS')
Where A is a matrix, with first column as time.
I am looking to get the difference between time(100) - time(1) in seconds and in minutes. I tried various conversions, but they are giving me the wrong answers than expected.
datestr(time(2)-time(1), 'HH:MM:SS').
This gave me 00:00:00
time(2) - time(1)
This gave me 0
time is a 1d array with time going from 00:00:01 to 00:30:00. Number of elements is 1800.
The matrix A is read from an excel sheet
matlab time
asked Nov 9 at 18:58
Jesh Kundem
309416
add a comment |
up vote
-2
down vote
favorite
I read an excel sheet, with time format into matlab. Using the function datastr()
My code is as follows:
time = datestr(A(:,1), 'HH:MM:SS')
Where A is a matrix, with first column as time.
I am looking to get the difference between time(100) - time(1) in seconds and in minutes. I tried various conversions, but they are giving me the wrong answers than expected.
datestr(time(2)-time(1), 'HH:MM:SS').
This gave me 00:00:00
time(2) - time(1)
This gave me 0
time is a 1d array with time going from 00:00:01 to 00:30:00. Number of elements is 1800.
The matrix A is read from an excel sheet
matlab time
asked Nov 9 at 18:58
Jesh Kundem
309416
Share what you've tried (and the answers they gave) for more detailed help.
– L. Scott Johnson
Nov 9 at 19:01
What is inA? It makes no sense to convert whatever it is to a string (usingdatestr) and then attempting subtraction... You should usedatetimeperhaps, then subtraction makes sense. Without a Minimal, Complete, and Verifiable example, it's impossible to tell what data type conversion you need to use.
– Wolfie
Nov 9 at 19:13
datetimefunction is not available in R2014 MATLAB. A is a matrix, where the first column is time, the second column is the measurement data - floating point numbers
– Jesh Kundem
Nov 9 at 19:23
My main point was that you're subtracting strings, which is never going to give you what you want... Please be more explicit with "the first column is time" - what data type? What representation? Show us examples! Edit your question to make it clearer...
– Wolfie
Nov 9 at 19:54
add a comment |
up vote
-2
down vote
favorite
up vote
-2
down vote
favorite
I read an excel sheet, with time format into matlab. Using the function datastr()
My code is as follows:
time = datestr(A(:,1), 'HH:MM:SS')
Where A is a matrix, with first column as time.
I am looking to get the difference between time(100) - time(1) in seconds and in minutes. I tried various conversions, but they are giving me the wrong answers than expected.
datestr(time(2)-time(1), 'HH:MM:SS').
This gave me 00:00:00
time(2) - time(1)
This gave me 0
time is a 1d array with time going from 00:00:01 to 00:30:00. Number of elements is 1800.
The matrix A is read from an excel sheet
matlab time
asked Nov 9 at 18:58
Jesh Kundem
309416
I read an excel sheet, with time format into matlab. Using the function datastr()
My code is as follows:
time = datestr(A(:,1), 'HH:MM:SS')
Where A is a matrix, with first column as time.
I am looking to get the difference between time(100) - time(1) in seconds and in minutes. I tried various conversions, but they are giving me the wrong answers than expected.
datestr(time(2)-time(1), 'HH:MM:SS').
This gave me 00:00:00
time(2) - time(1)
This gave me 0
time is a 1d array with time going from 00:00:01 to 00:30:00. Number of elements is 1800.
The matrix A is read from an excel sheet
matlab time
matlab time
asked Nov 9 at 18:58
Jesh Kundem
309416
asked Nov 9 at 18:58
Jesh Kundem
309416
edited Nov 9 at 19:24
asked Nov 9 at 18:58
Jesh Kundem
309416
asked Nov 9 at 18:58
Jesh Kundem
309416
asked Nov 9 at 18:58
Jesh Kundem
309416
309416
Share what you've tried (and the answers they gave) for more detailed help.
– L. Scott Johnson
Nov 9 at 19:01
What is inA? It makes no sense to convert whatever it is to a string (usingdatestr) and then attempting subtraction... You should usedatetimeperhaps, then subtraction makes sense. Without a Minimal, Complete, and Verifiable example, it's impossible to tell what data type conversion you need to use.
– Wolfie
Nov 9 at 19:13
datetimefunction is not available in R2014 MATLAB. A is a matrix, where the first column is time, the second column is the measurement data - floating point numbers
– Jesh Kundem
Nov 9 at 19:23
My main point was that you're subtracting strings, which is never going to give you what you want... Please be more explicit with "the first column is time" - what data type? What representation? Show us examples! Edit your question to make it clearer...
– Wolfie
Nov 9 at 19:54
add a comment |
Share what you've tried (and the answers they gave) for more detailed help.
– L. Scott Johnson
Nov 9 at 19:01
What is inA? It makes no sense to convert whatever it is to a string (usingdatestr) and then attempting subtraction... You should usedatetimeperhaps, then subtraction makes sense. Without a Minimal, Complete, and Verifiable example, it's impossible to tell what data type conversion you need to use.
– Wolfie
Nov 9 at 19:13
datetimefunction is not available in R2014 MATLAB. A is a matrix, where the first column is time, the second column is the measurement data - floating point numbers
– Jesh Kundem
Nov 9 at 19:23
My main point was that you're subtracting strings, which is never going to give you what you want... Please be more explicit with "the first column is time" - what data type? What representation? Show us examples! Edit your question to make it clearer...
– Wolfie
Nov 9 at 19:54
Share what you've tried (and the answers they gave) for more detailed help.
– L. Scott Johnson
Nov 9 at 19:01
Share what you've tried (and the answers they gave) for more detailed help.
– L. Scott Johnson
Nov 9 at 19:01
What is in
A? It makes no sense to convert whatever it is to a string (using datestr) and then attempting subtraction... You should use datetime perhaps, then subtraction makes sense. Without a Minimal, Complete, and Verifiable example, it's impossible to tell what data type conversion you need to use.– Wolfie
Nov 9 at 19:13
What is in
A? It makes no sense to convert whatever it is to a string (using datestr) and then attempting subtraction... You should use datetime perhaps, then subtraction makes sense. Without a Minimal, Complete, and Verifiable example, it's impossible to tell what data type conversion you need to use.– Wolfie
Nov 9 at 19:13
datetime function is not available in R2014 MATLAB. A is a matrix, where the first column is time, the second column is the measurement data - floating point numbers– Jesh Kundem
Nov 9 at 19:23
datetime function is not available in R2014 MATLAB. A is a matrix, where the first column is time, the second column is the measurement data - floating point numbers– Jesh Kundem
Nov 9 at 19:23
My main point was that you're subtracting strings, which is never going to give you what you want... Please be more explicit with "the first column is time" - what data type? What representation? Show us examples! Edit your question to make it clearer...
– Wolfie
Nov 9 at 19:54
My main point was that you're subtracting strings, which is never going to give you what you want... Please be more explicit with "the first column is time" - what data type? What representation? Show us examples! Edit your question to make it clearer...
– Wolfie
Nov 9 at 19:54
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53231799%2fmatlab-time-difference-function%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Share what you've tried (and the answers they gave) for more detailed help.
– L. Scott Johnson
Nov 9 at 19:01
What is in
A? It makes no sense to convert whatever it is to a string (usingdatestr) and then attempting subtraction... You should usedatetimeperhaps, then subtraction makes sense. Without a Minimal, Complete, and Verifiable example, it's impossible to tell what data type conversion you need to use.– Wolfie
Nov 9 at 19:13
datetimefunction is not available in R2014 MATLAB. A is a matrix, where the first column is time, the second column is the measurement data - floating point numbers– Jesh Kundem
Nov 9 at 19:23
My main point was that you're subtracting strings, which is never going to give you what you want... Please be more explicit with "the first column is time" - what data type? What representation? Show us examples! Edit your question to make it clearer...
– Wolfie
Nov 9 at 19:54