Calculate delta time in seconds
15 views (last 30 days)
Show older comments
Dion Theunissen
on 28 Oct 2021
Answered: Walter Roberson
on 28 Oct 2021
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"]
0 Comments
Accepted Answer
Walter Roberson
on 28 Oct 2021
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) );
0 Comments
More Answers (1)
Jan
on 28 Oct 2021
Starttime = "28-Jun-2021 05:05:38";
Stoptime = "28-Jun-2021 05:15:38";
Deltatime = compose("%d", seconds(datetime(Stoptime) - datetime(Starttime)))
0 Comments
See Also
Categories
Find more on Descriptive Statistics in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!