How to calculate time elapsed for AM and PM

5 visualizzazioni (ultimi 30 giorni)
Mekala balaji
Mekala balaji il 19 Mar 2018
Commentato: Mekala balaji il 19 Mar 2018
Hi,
I have below time array:
Start time End time
23:12:17 PM 23:12:19 PM
3:12:11 AM 3:12:29 AM
23:59:17 PM 01:10:13 AM
11:59:17 AM 13:10:13 PM
I want to calculate time elapsed between Start time to End time of each row.

Risposte (2)

Image Analyst
Image Analyst il 19 Mar 2018
See the help for etime().
  3 Commenti
Image Analyst
Image Analyst il 19 Mar 2018
If the time is negative, add 24 hours to it.
Mekala balaji
Mekala balaji il 19 Mar 2018
Sir,
I tried as below, but it seems some problem,
t1={'23:59:00 PM'}
t1 =
cell
'23:59:00 PM'
>> t2={'00:1:00 AM'}
t2 =
cell
'00:1:00 AM'
>> t2={'12:1:00 AM'}
t2 =
cell
'12:1:00 AM'
>> t1=datevec(t1)
t1 =
2018 1 2 11 59 0
>> t2=datevec(t2)
t2 =
2018 1 1 0 1 0
>> etime(t2,t1)
ans =
-129480

Accedi per commentare.


Star Strider
Star Strider il 19 Mar 2018
You should add dates to each time, and delete the ‘AM’ and ‘PM’ since you are also using 24-hour times.
Try this:
SA = {'23:12:17' '23:12:19'
'3:12:11' '3:12:29'
'23:59:17' '01:10:13'
'11:59:17' '13:10:13'};
DA = datetime(SA, 'InputFormat','HH:mm:ss');
BT = between(DA(:,1), DA(:,2));
It will give a negative value for Row 3, because the between function does not ‘know’ they are consecutive days, since you did not tell it.

Categorie

Scopri di più su Introduction to Installation and Licensing in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by