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

1 次查看（过去 30 天）

MONICA RAWAT 2020-1-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/502344-how-to-convert-the-mutiple-colum-into-single-colum-using-colon

评论： MONICA RAWAT 2020-2-23

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

采纳的回答

Walter Roberson 2020-1-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/502344-how-to-convert-the-mutiple-colum-into-single-colum-using-colon#answer_412411

在 MATLAB Online 中打开

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

8 个评论
显示 6更早的评论隐藏 6更早的评论

Walter Roberson 2020-2-22

在 MATLAB Online 中打开

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 2020-2-23

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

请先登录，再进行评论。

类别

MATLAB Language Fundamentals Data Types Dates and Time

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by