Calculate delta time in seconds

16 ビュー (過去 30 日間)
Dion Theunissen
Dion Theunissen 2021 年 10 月 28 日
回答済み: Walter Roberson 2021 年 10 月 28 日
i have a table where column 1 is the starttime and column 2 the stoptime. Now i want to insert in column 3 the delta time.
DataBaseA.Starttime = ["28-Jun-2021 05:05:38"]
DataBaseA.Stoptime = ["28-Jun-2021 05:15:38"]
Where each row has different datetimes.
Need a result like
DataBaseA.Deltatime = ["600"]

採用された回答

Walter Roberson
Walter Roberson 2021 年 10 月 28 日
SaT = datetime(DataaBaseA.Starttime, 'InputFormat', 'dd-MMM-yyyy HH:mm:ss');
StT = datetime(DataaBaseA.Stoptime, 'InputFormat', 'dd-MMM-yyyy HH:mm:ss');
dt = StT - Sat;
DataBaseA.Deltatime = string( seconds(dt) );

その他の回答 (1 件)

Jan
Jan 2021 年 10 月 28 日
Starttime = "28-Jun-2021 05:05:38";
Stoptime = "28-Jun-2021 05:15:38";
Deltatime = compose("%d", seconds(datetime(Stoptime) - datetime(Starttime)))
Deltatime = "600"

カテゴリ

Help Center および File ExchangeDescriptive Statistics についてさらに検索

製品


リリース

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by