how to convert the mutiple colum into single colum using colon :

the table given above is the three column represent hour minute second in separate column i want to combine into single column separated by colon(:) given below format

output:

0:0:0.0180

0:0:0.0380

0:0:0.0580

0:0:0.0780

0:0:0.0980

0:0:0.1180

0:0:0.1380

0:0:0.1580

0:0:0.1780

Answer 1

[Walter Roberson]

 duration(YourData(:,4), YourData(:,5), YourData(:,6), 'format', 'hh:mm:ss.SSSS')

[MONICA RAWAT]

your code is running but how to convert duration into double datatypes

because in the workspace it is showing duration as a datatype given below ..why it is showing timer icon in workspace

[Walter Roberson]

In order to have the colons show up as part of the output, you must use one of five datatypes:

1. datetime. Requires that the values be attached to some particular date
2. duration. Relative time that does not have to be attached to a particular date
3. 2d character array
4. cell array of character vectors
5. string() datatype

None of these are numeric. The numeric data types never have colon in them.

[MONICA RAWAT]

ohk thank you so much

[MONICA RAWAT]

if i wanted to convert into numeric matrix,then how to convert

[Walter Roberson]

If you have converted to duration, then seconds() will give you a result. However, with the data that you show, seconds() is just going to give you the same result as using column #6 .

[MONICA RAWAT]

duration(YourData(:,4), YourData(:,5), YourData(:,6), 'format', 'hh:mm:ss.SSSS')

my time is in UTC i wanted to converted to IST by adding +5:30 to my UTC time so with the output mention above in question how can i add +5:30 to my output data ,because the code you have provided is correct but unable to convert to IST because this is duration not a numeric matric

[Walter Roberson]

IST_Duration = UTC_Duration + hours(5) + minutes(30)

However, it makes no sense to do so. Durations are for elapsed time relative to some starting point. TimeZone corrections only make sense relative to a date. If you have a date as well as a time of day then you would put everything together using datetime() instead of duration(). At the time you use datetime() you would use the option 'TimeZone', 'UTC' . Then once you had the resulting datetime object, you would set the TimeZone property of it to 'Asia/Calcutta' .

[MONICA RAWAT]

got it walter thank you so much for clearing out my doubt

Answer 2

[Selva Karna]

clc
clear all;
close all;
data=your_data;
con_singl_col=data(:);