Is there a way to convert times in this format to double, so I can perform mathematical operations on them?

6 次查看(过去 30 天)
Hi folks,
I have an array of times that looks like this:
[1059, 1100, 1101...]
where 1059 = 59 minutes past 10am. I need to work out the elapsed number of minutes for each consequent element of the array. However, if I were to deduct 100-1059, I get 41 instead of 1.
Whilst there is a roundabout way of doing this, I was wondering if there's functionality in Matlab that will allow me to do this in a more elegant way?
Thank you in advance!

采纳的回答

Steven Lord
Steven Lord 2022-1-24
How do you know that 100 represents 1 PM instead of 1 AM? Would it make more sense to adjust x so it includes 1300 instead of 100?
x = [1059, 1100, 1101, 100];
m = mod(x, 100);
h = (x-m)/100;
% Adjust h here using your rules so that 100 represents 1 PM instead of 1 AM
d = hours(h) + minutes(m);
d.Format = 'hh:mm'
d = 1×4 duration array
10:59 11:00 11:01 01:00
difference = diff(d)
difference = 1×3 duration array
00:01 00:01 -10:01
differenceInMinutes = minutes(difference)
differenceInMinutes = 1×3
1 1 -601

更多回答(1 个)

Benjamin Thompson
Benjamin Thompson 2022-1-24
MATLAB has a lot of date and time functions, as described by the article "Dates and Time" in the help documentation. If you are able to convert your four digit time codes into strings where hours and minutes are separated by a colon:
t = datetime({'10:59', '11:00', '11:01'},'Format','HH:mm')
t =
1×3 datetime array
10:59 11:00 11:01
>> dt = diff(t)
dt =
1×2 duration array
00:01:00 00:01:00

类别

Help CenterFile Exchange 中查找有关 Dates and Time 的更多信息

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by