Extract specific hour data from timetable

4 views (last 30 days)
Sanley Guerrier
Sanley Guerrier on 5 Mar 2024
Commented: Sanley Guerrier on 5 Mar 2024
Hi all,
I have a timetable and I want to select and extract only the data from 8:00 AM to 4:00 PM. Can someone help with that?
I attached here a sample of the data.
Your help will be greatly appriciated.

Sign in to answer this question.

Accepted Answer

Voss
Voss on 5 Mar 2024
Edited: Voss on 5 Mar 2024
Ran in:
I assume that's 8AM to 4PM inclusive. Here's one way:
T = readtimetable('T.xlsx');
disp(T) % original
time S1 S2 S3 ____________________ _____ _____ _____ 01-Dec-2023 00:00:00 22.82 25.88 30.74 01-Dec-2023 00:10:00 22.1 25.7 30.56 01-Dec-2023 00:20:00 21.56 25.52 30.56 01-Dec-2023 00:30:00 21.02 25.34 30.74 01-Dec-2023 00:40:00 20.48 24.98 30.56 01-Dec-2023 00:50:00 20.12 24.8 30.56 01-Dec-2023 01:00:00 19.76 24.44 30.56 01-Dec-2023 01:10:00 19.4 24.26 30.56 01-Dec-2023 01:20:00 19.04 24.08 30.56 01-Dec-2023 01:30:00 18.86 23.9 30.56 01-Dec-2023 01:40:00 18.5 23.72 30.56 01-Dec-2023 01:50:00 18.32 23.54 30.56 01-Dec-2023 02:00:00 18.14 23.36 30.56 01-Dec-2023 02:10:00 17.96 23.18 30.38 01-Dec-2023 02:20:00 17.78 23 30.38 01-Dec-2023 02:30:00 17.42 22.82 30.38 01-Dec-2023 02:40:00 17.24 22.64 30.38 01-Dec-2023 02:50:00 17.06 22.46 30.38 01-Dec-2023 03:00:00 16.88 22.28 30.2 01-Dec-2023 03:10:00 16.88 22.28 30.2 01-Dec-2023 03:20:00 16.88 22.1 30.2 01-Dec-2023 03:30:00 17.24 21.92 30.2 01-Dec-2023 03:40:00 17.42 21.92 30.2 01-Dec-2023 03:50:00 17.42 21.92 30.02 01-Dec-2023 04:00:00 17.24 21.74 30.2 01-Dec-2023 04:10:00 17.42 21.74 30.02 01-Dec-2023 04:20:00 17.6 21.74 30.02 01-Dec-2023 04:30:00 17.78 21.74 30.02 01-Dec-2023 04:40:00 17.78 21.74 30.02 01-Dec-2023 04:50:00 17.96 21.74 29.84 01-Dec-2023 05:00:00 18.32 21.74 29.84 01-Dec-2023 05:10:00 18.86 21.74 29.84 01-Dec-2023 05:20:00 19.22 21.92 29.84 01-Dec-2023 05:30:00 19.76 21.92 29.84 01-Dec-2023 05:40:00 19.94 22.1 29.84 01-Dec-2023 05:50:00 20.3 22.28 29.66 01-Dec-2023 06:00:00 20.66 22.28 29.66 01-Dec-2023 06:10:00 20.84 22.46 29.66 01-Dec-2023 06:20:00 21.02 22.64 29.66 01-Dec-2023 06:30:00 21.02 22.64 29.66 01-Dec-2023 06:40:00 20.84 22.82 29.48 01-Dec-2023 06:50:00 20.66 22.82 29.48 01-Dec-2023 07:00:00 20.48 22.82 29.48 01-Dec-2023 07:10:00 20.12 22.64 29.48 01-Dec-2023 07:20:00 19.76 22.64 29.48 01-Dec-2023 07:30:00 19.22 22.64 29.48 01-Dec-2023 07:40:00 18.86 22.46 29.48 01-Dec-2023 07:50:00 18.68 22.28 29.48 01-Dec-2023 08:00:00 18.5 22.1 29.3 01-Dec-2023 08:10:00 18.5 22.1 29.48 01-Dec-2023 08:20:00 18.86 21.92 29.3 01-Dec-2023 08:30:00 19.4 21.92 29.3 01-Dec-2023 08:40:00 20.48 22.1 29.3 01-Dec-2023 08:50:00 21.56 22.1 29.3 01-Dec-2023 09:00:00 22.82 22.46 29.3 01-Dec-2023 09:10:00 23.72 22.82 29.3 01-Dec-2023 09:20:00 24.44 23.18 29.3 01-Dec-2023 09:30:00 25.34 23.54 29.3 01-Dec-2023 09:40:00 26.06 24.08 29.3 01-Dec-2023 09:50:00 26.96 24.44 29.3 01-Dec-2023 10:00:00 28.04 24.8 29.3 01-Dec-2023 10:10:00 28.94 25.34 29.12 01-Dec-2023 10:20:00 30.02 25.7 29.3 01-Dec-2023 10:30:00 30.74 26.24 29.12 01-Dec-2023 10:40:00 31.64 26.78 29.3 01-Dec-2023 10:50:00 32.36 27.32 29.3 01-Dec-2023 11:00:00 33.44 27.68 29.3 01-Dec-2023 11:10:00 34.52 28.22 29.3 01-Dec-2023 11:20:00 35.42 28.76 29.3 01-Dec-2023 11:30:00 36.14 29.3 29.3 01-Dec-2023 11:40:00 37.22 29.84 29.3 01-Dec-2023 11:50:00 37.22 30.38 29.3 01-Dec-2023 12:00:00 37.76 30.74 29.48 01-Dec-2023 12:10:00 38.84 31.1 29.48 01-Dec-2023 12:20:00 39.74 31.64 29.48 01-Dec-2023 12:30:00 40.46 32.18 29.48 01-Dec-2023 12:40:00 40.64 32.54 29.66 01-Dec-2023 12:50:00 40.46 33.08 29.66 01-Dec-2023 13:00:00 39.92 33.44 29.66 01-Dec-2023 13:10:00 38.84 33.62 29.84 01-Dec-2023 13:20:00 38.48 33.8 29.84 01-Dec-2023 13:30:00 38.12 33.62 29.84 01-Dec-2023 13:40:00 37.94 33.62 30.02 01-Dec-2023 13:50:00 37.76 33.62 30.02 01-Dec-2023 14:00:00 38.12 33.8 30.02 01-Dec-2023 14:10:00 37.58 33.8 30.02 01-Dec-2023 14:20:00 37.58 33.8 30.2 01-Dec-2023 14:30:00 36.86 33.8 30.2 01-Dec-2023 14:40:00 36.5 33.62 30.2 01-Dec-2023 14:50:00 37.22 33.62 30.38 01-Dec-2023 15:00:00 37.22 33.62 30.38 01-Dec-2023 15:10:00 35.96 33.62 30.38 01-Dec-2023 15:20:00 35.24 33.44 30.38 01-Dec-2023 15:30:00 33.8 33.26 30.56 01-Dec-2023 15:40:00 32.9 32.9 30.56 01-Dec-2023 15:50:00 32.36 32.54 30.56 01-Dec-2023 16:00:00 31.64 32.36 30.56 01-Dec-2023 16:10:00 30.56 32 30.56 01-Dec-2023 16:20:00 29.48 31.64 30.56 01-Dec-2023 16:30:00 28.58 31.1 30.56 01-Dec-2023 16:40:00 27.68 30.74 30.74 01-Dec-2023 16:50:00 26.96 30.38 30.56 01-Dec-2023 17:00:00 26.24 30.2 30.74 01-Dec-2023 17:10:00 25.52 29.84 30.74 01-Dec-2023 17:20:00 24.98 29.48 30.74 01-Dec-2023 17:30:00 24.44 29.12 30.74 01-Dec-2023 17:40:00 23.9 28.58 30.74 01-Dec-2023 17:50:00 23.36 28.4 30.74 01-Dec-2023 18:00:00 23 28.04 30.92 01-Dec-2023 18:10:00 22.64 27.68 30.92 01-Dec-2023 18:20:00 22.28 27.5 30.92 01-Dec-2023 18:30:00 21.92 27.14 30.92 01-Dec-2023 18:40:00 21.56 26.96 30.92 01-Dec-2023 18:50:00 21.38 26.6 30.92 01-Dec-2023 19:00:00 21.02 26.42 30.92 01-Dec-2023 19:10:00 20.66 26.24 30.92 01-Dec-2023 19:20:00 20.48 26.06 30.92 01-Dec-2023 19:30:00 20.3 25.7 30.92 01-Dec-2023 19:40:00 19.94 25.52 30.92 01-Dec-2023 19:50:00 19.76 25.34 30.92 01-Dec-2023 20:00:00 19.58 25.16 30.92 01-Dec-2023 20:10:00 19.4 24.98 30.92 01-Dec-2023 20:20:00 19.22 24.8 30.92 01-Dec-2023 20:30:00 19.04 24.62 30.92 01-Dec-2023 20:40:00 18.86 24.44 30.92 01-Dec-2023 20:50:00 18.68 24.26 30.92 01-Dec-2023 21:00:00 18.5 24.08 30.92 01-Dec-2023 21:10:00 18.32 23.9 30.92 01-Dec-2023 21:20:00 18.14 23.72 30.74 01-Dec-2023 21:30:00 18.14 23.54 30.74 01-Dec-2023 21:40:00 18.32 23.36 30.74 01-Dec-2023 21:50:00 18.68 23.36 30.74 01-Dec-2023 22:00:00 19.04 23.36 30.74 01-Dec-2023 22:10:00 19.58 23.36 30.74 01-Dec-2023 22:20:00 19.94 23.36 30.56 01-Dec-2023 22:30:00 20.3 23.36 30.56 01-Dec-2023 22:40:00 20.66 23.54 30.56 01-Dec-2023 22:50:00 20.84 23.54 30.56 01-Dec-2023 23:00:00 21.02 23.72 30.56 01-Dec-2023 23:10:00 21.2 23.72 30.56 01-Dec-2023 23:20:00 21.38 23.72 30.56 01-Dec-2023 23:30:00 21.56 23.9 30.38 01-Dec-2023 23:40:00 21.56 23.9 30.38 01-Dec-2023 23:50:00 21.56 24.08 30.38 02-Dec-2023 00:00:00 21.38 24.08 30.38 02-Dec-2023 00:10:00 21.2 23.9 30.38 02-Dec-2023 00:20:00 20.84 24.08 30.2 02-Dec-2023 00:30:00 20.66 23.9 30.2 02-Dec-2023 00:40:00 20.3 23.72 30.2 02-Dec-2023 00:50:00 20.12 23.72 30.2 02-Dec-2023 01:00:00 19.76 23.54 30.2 02-Dec-2023 01:10:00 19.58 23.36 30.02 02-Dec-2023 01:20:00 19.4 23.36 30.2 02-Dec-2023 01:30:00 19.58 23.18 30.02 02-Dec-2023 01:40:00 19.76 23.18 30.02 02-Dec-2023 01:50:00 19.58 23.18 30.02 02-Dec-2023 02:00:00 19.58 23 30.02 02-Dec-2023 02:10:00 19.4 23 30.02 02-Dec-2023 02:20:00 19.58 22.82 30.02 02-Dec-2023 02:30:00 19.76 22.82 29.84 02-Dec-2023 02:40:00 19.76 22.82 29.84 02-Dec-2023 02:50:00 19.94 22.82 29.84 02-Dec-2023 03:00:00 19.58 22.82 29.84 02-Dec-2023 03:10:00 19.4 22.82 29.84 02-Dec-2023 03:20:00 19.04 22.64 29.66 02-Dec-2023 03:30:00 19.04 22.64 29.84 02-Dec-2023 03:40:00 19.4 22.64 29.66 02-Dec-2023 03:50:00 19.4 22.64 29.66 02-Dec-2023 04:00:00 19.58 22.64 29.66 02-Dec-2023 04:10:00 19.76 22.64 29.66 02-Dec-2023 04:20:00 19.76 22.64 29.66 02-Dec-2023 04:30:00 19.76 22.46 29.66 02-Dec-2023 04:40:00 19.76 22.64 29.48 02-Dec-2023 04:50:00 19.94 22.64 29.66 02-Dec-2023 05:00:00 20.12 22.64 29.48 02-Dec-2023 05:10:00 20.48 22.64 29.48 02-Dec-2023 05:20:00 20.48 22.64 29.48 02-Dec-2023 05:30:00 20.66 22.64 29.48 02-Dec-2023 05:40:00 20.48 22.64 29.48 02-Dec-2023 05:50:00 20.66 22.82 29.48 02-Dec-2023 06:00:00 20.66 22.82 29.48 02-Dec-2023 06:10:00 20.84 22.82 29.48 02-Dec-2023 06:20:00 21.02 22.82 29.48 02-Dec-2023 06:30:00 21.02 22.82 29.3 02-Dec-2023 06:40:00 21.2 22.82 29.3 02-Dec-2023 06:50:00 21.56 23 29.3 02-Dec-2023 07:00:00 21.38 23 29.3 02-Dec-2023 07:10:00 21.38 23 29.3 02-Dec-2023 07:20:00 21.56 23.18 29.3 02-Dec-2023 07:30:00 21.74 23.18 29.3 02-Dec-2023 07:40:00 22.1 23.18 29.3 02-Dec-2023 07:50:00 22.46 23.36 29.3 02-Dec-2023 08:00:00 22.64 23.36 29.3 02-Dec-2023 08:10:00 23 23.54 29.12 02-Dec-2023 08:20:00 23.36 23.54 29.3 02-Dec-2023 08:30:00 23.72 23.72 29.3 02-Dec-2023 08:40:00 24.08 23.9 29.3 02-Dec-2023 08:50:00 24.44 24.08 29.12 02-Dec-2023 09:00:00 24.8 24.26 29.12 02-Dec-2023 09:10:00 25.34 24.44 29.12 02-Dec-2023 09:20:00 25.88 24.62 29.12 02-Dec-2023 09:30:00 26.6 24.98 29.12 02-Dec-2023 09:40:00 27.5 25.16 29.12 02-Dec-2023 09:50:00 28.04 25.7 29.12 02-Dec-2023 10:00:00 28.76 25.88 29.12 02-Dec-2023 10:10:00 29.3 26.24 29.3 02-Dec-2023 10:20:00 30.2 26.6 29.3 02-Dec-2023 10:30:00 30.92 26.96 29.3 02-Dec-2023 10:40:00 32.36 27.5 29.3 02-Dec-2023 10:50:00 33.08 28.04 29.3 02-Dec-2023 11:00:00 33.44 28.4 29.3 02-Dec-2023 11:10:00 34.34 28.76 29.3 02-Dec-2023 11:20:00 34.16 29.3 29.3 02-Dec-2023 11:30:00 34.88 29.66 29.3 02-Dec-2023 11:40:00 36.14 30.02 29.3 02-Dec-2023 11:50:00 37.22 30.56 29.48 02-Dec-2023 12:00:00 37.22 30.92 29.48 02-Dec-2023 12:10:00 37.94 31.46 29.48 02-Dec-2023 12:20:00 39.38 31.82 29.48 02-Dec-2023 12:30:00 40.28 32.18 29.66 02-Dec-2023 12:40:00 41 32.72 29.66 02-Dec-2023 12:50:00 41.72 33.26 29.66 02-Dec-2023 13:00:00 40.1 33.8 29.84 02-Dec-2023 13:10:00 39.92 34.16 29.84 02-Dec-2023 13:20:00 39.56 34.34 29.84 02-Dec-2023 13:30:00 39.2 34.34 29.84 02-Dec-2023 13:40:00 38.12 34.34 30.02 02-Dec-2023 13:50:00 37.4 34.16 30.02 02-Dec-2023 14:00:00 37.22 34.16 30.02 02-Dec-2023 14:10:00 37.76 33.98 30.2 02-Dec-2023 14:20:00 38.12 33.98 30.2 02-Dec-2023 14:30:00 37.22 33.98 30.2 02-Dec-2023 14:40:00 37.76 33.98 30.38 02-Dec-2023 14:50:00 37.22 33.98 30.38 02-Dec-2023 15:00:00 36.68 33.8 30.38 02-Dec-2023 15:10:00 36.14 33.8 30.38 02-Dec-2023 15:20:00 35.6 33.8 30.38 02-Dec-2023 15:30:00 34.7 33.62 30.56 02-Dec-2023 15:40:00 33.44 33.26 30.56 02-Dec-2023 15:50:00 32.36 32.9 30.56
tod = timeofday(T.time);
keep = tod >= hours(8) & tod <= hours(16);
T = T(keep,:);
disp(T) % 8AM to 4PM only
time S1 S2 S3 ____________________ _____ _____ _____ 01-Dec-2023 08:00:00 18.5 22.1 29.3 01-Dec-2023 08:10:00 18.5 22.1 29.48 01-Dec-2023 08:20:00 18.86 21.92 29.3 01-Dec-2023 08:30:00 19.4 21.92 29.3 01-Dec-2023 08:40:00 20.48 22.1 29.3 01-Dec-2023 08:50:00 21.56 22.1 29.3 01-Dec-2023 09:00:00 22.82 22.46 29.3 01-Dec-2023 09:10:00 23.72 22.82 29.3 01-Dec-2023 09:20:00 24.44 23.18 29.3 01-Dec-2023 09:30:00 25.34 23.54 29.3 01-Dec-2023 09:40:00 26.06 24.08 29.3 01-Dec-2023 09:50:00 26.96 24.44 29.3 01-Dec-2023 10:00:00 28.04 24.8 29.3 01-Dec-2023 10:10:00 28.94 25.34 29.12 01-Dec-2023 10:20:00 30.02 25.7 29.3 01-Dec-2023 10:30:00 30.74 26.24 29.12 01-Dec-2023 10:40:00 31.64 26.78 29.3 01-Dec-2023 10:50:00 32.36 27.32 29.3 01-Dec-2023 11:00:00 33.44 27.68 29.3 01-Dec-2023 11:10:00 34.52 28.22 29.3 01-Dec-2023 11:20:00 35.42 28.76 29.3 01-Dec-2023 11:30:00 36.14 29.3 29.3 01-Dec-2023 11:40:00 37.22 29.84 29.3 01-Dec-2023 11:50:00 37.22 30.38 29.3 01-Dec-2023 12:00:00 37.76 30.74 29.48 01-Dec-2023 12:10:00 38.84 31.1 29.48 01-Dec-2023 12:20:00 39.74 31.64 29.48 01-Dec-2023 12:30:00 40.46 32.18 29.48 01-Dec-2023 12:40:00 40.64 32.54 29.66 01-Dec-2023 12:50:00 40.46 33.08 29.66 01-Dec-2023 13:00:00 39.92 33.44 29.66 01-Dec-2023 13:10:00 38.84 33.62 29.84 01-Dec-2023 13:20:00 38.48 33.8 29.84 01-Dec-2023 13:30:00 38.12 33.62 29.84 01-Dec-2023 13:40:00 37.94 33.62 30.02 01-Dec-2023 13:50:00 37.76 33.62 30.02 01-Dec-2023 14:00:00 38.12 33.8 30.02 01-Dec-2023 14:10:00 37.58 33.8 30.02 01-Dec-2023 14:20:00 37.58 33.8 30.2 01-Dec-2023 14:30:00 36.86 33.8 30.2 01-Dec-2023 14:40:00 36.5 33.62 30.2 01-Dec-2023 14:50:00 37.22 33.62 30.38 01-Dec-2023 15:00:00 37.22 33.62 30.38 01-Dec-2023 15:10:00 35.96 33.62 30.38 01-Dec-2023 15:20:00 35.24 33.44 30.38 01-Dec-2023 15:30:00 33.8 33.26 30.56 01-Dec-2023 15:40:00 32.9 32.9 30.56 01-Dec-2023 15:50:00 32.36 32.54 30.56 01-Dec-2023 16:00:00 31.64 32.36 30.56 02-Dec-2023 08:00:00 22.64 23.36 29.3 02-Dec-2023 08:10:00 23 23.54 29.12 02-Dec-2023 08:20:00 23.36 23.54 29.3 02-Dec-2023 08:30:00 23.72 23.72 29.3 02-Dec-2023 08:40:00 24.08 23.9 29.3 02-Dec-2023 08:50:00 24.44 24.08 29.12 02-Dec-2023 09:00:00 24.8 24.26 29.12 02-Dec-2023 09:10:00 25.34 24.44 29.12 02-Dec-2023 09:20:00 25.88 24.62 29.12 02-Dec-2023 09:30:00 26.6 24.98 29.12 02-Dec-2023 09:40:00 27.5 25.16 29.12 02-Dec-2023 09:50:00 28.04 25.7 29.12 02-Dec-2023 10:00:00 28.76 25.88 29.12 02-Dec-2023 10:10:00 29.3 26.24 29.3 02-Dec-2023 10:20:00 30.2 26.6 29.3 02-Dec-2023 10:30:00 30.92 26.96 29.3 02-Dec-2023 10:40:00 32.36 27.5 29.3 02-Dec-2023 10:50:00 33.08 28.04 29.3 02-Dec-2023 11:00:00 33.44 28.4 29.3 02-Dec-2023 11:10:00 34.34 28.76 29.3 02-Dec-2023 11:20:00 34.16 29.3 29.3 02-Dec-2023 11:30:00 34.88 29.66 29.3 02-Dec-2023 11:40:00 36.14 30.02 29.3 02-Dec-2023 11:50:00 37.22 30.56 29.48 02-Dec-2023 12:00:00 37.22 30.92 29.48 02-Dec-2023 12:10:00 37.94 31.46 29.48 02-Dec-2023 12:20:00 39.38 31.82 29.48 02-Dec-2023 12:30:00 40.28 32.18 29.66 02-Dec-2023 12:40:00 41 32.72 29.66 02-Dec-2023 12:50:00 41.72 33.26 29.66 02-Dec-2023 13:00:00 40.1 33.8 29.84 02-Dec-2023 13:10:00 39.92 34.16 29.84 02-Dec-2023 13:20:00 39.56 34.34 29.84 02-Dec-2023 13:30:00 39.2 34.34 29.84 02-Dec-2023 13:40:00 38.12 34.34 30.02 02-Dec-2023 13:50:00 37.4 34.16 30.02 02-Dec-2023 14:00:00 37.22 34.16 30.02 02-Dec-2023 14:10:00 37.76 33.98 30.2 02-Dec-2023 14:20:00 38.12 33.98 30.2 02-Dec-2023 14:30:00 37.22 33.98 30.2 02-Dec-2023 14:40:00 37.76 33.98 30.38 02-Dec-2023 14:50:00 37.22 33.98 30.38 02-Dec-2023 15:00:00 36.68 33.8 30.38 02-Dec-2023 15:10:00 36.14 33.8 30.38 02-Dec-2023 15:20:00 35.6 33.8 30.38 02-Dec-2023 15:30:00 34.7 33.62 30.56 02-Dec-2023 15:40:00 33.44 33.26 30.56 02-Dec-2023 15:50:00 32.36 32.9 30.56
  3 Comments
Show 1 older comment
Voss
Voss on 5 Mar 2024
You're welcome!
Make sure you see my updated answer. I changed the method from what I had originally; I think this way is more straightforward.

Sign in to comment.

More Answers (0)

Categories

Find more on Logical in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!