MATLAB: How to Select Specific Time Intervals Over a series of time steps

Question

Hi, I have a data collected every 3 minutes for several months but now I am only interested in what happen during the day. How can I select the output between certain hours 4:00 am to 7:00 pm for every day of the data? Below is an example of the dat I am working on.

Thank you for the anticipated help.

Timestamp Transpiration (g/min)

6/17/2020 13:39 26.24927

6/17/2020 13:42 24.15281

6/17/2020 13:45 22.17615

6/17/2020 13:48 20.31593

6/17/2020 13:51 18.56879

6/17/2020 13:54 16.93137

6/17/2020 13:57 15.4003

6/17/2020 14:00 13.97224

6/17/2020 14:03 12.64381

6/17/2020 14:06 11.41165

6/17/2020 14:09 10.27241

6/17/2020 14:12 9.222727

6/17/2020 14:15 8.259237

6/17/2020 14:18 7.378579

6/17/2020 14:21 6.577395

6/17/2020 14:24 5.852324

6/17/2020 14:27 5.200004

6/17/2020 14:30 4.617075

6/17/2020 14:33 4.100178

6/17/2020 14:36 3.64595

6/17/2020 14:39 3.251032

6/17/2020 14:42 2.912063

6/17/2020 14:45 2.625682

6/17/2020 14:48 2.388529

6/17/2020 14:51 2.197244

6/17/2020 14:54 2.048465

6/17/2020 14:57 1.938832

6/17/2020 15:00 1.864985

6/17/2020 15:03 1.823563

6/17/2020 15:06 1.811205

6/17/2020 15:09 1.824551

6/17/2020 15:12 1.94337

6/17/2020 15:15 2.022293

6/17/2020 15:18 2.062494

6/17/2020 15:21 2.086983

6/17/2020 15:24 2.084625

6/17/2020 15:27 2.078434

6/17/2020 15:30 2.060608

6/17/2020 15:33 2.043705

6/17/2020 15:36 2.026905

6/17/2020 15:39 2.000002

6/17/2020 15:42 1.979461

6/17/2020 15:45 1.964843

6/17/2020 15:48 1.94387

6/17/2020 15:51 1.91552

6/17/2020 15:54 1.886226

6/17/2020 15:57 1.856811

6/17/2020 16:00 1.830155

6/17/2020 16:03 1.799805

6/17/2020 16:06 1.780969

6/17/2020 16:09 1.743456

6/17/2020 16:12 1.710722

6/17/2020 16:15 1.692139

6/17/2020 16:18 1.680361

6/17/2020 16:21 1.665964

6/17/2020 16:24 1.63588

6/17/2020 16:27 1.605836

6/17/2020 16:30 1.578283

6/17/2020 16:33 1.551441

6/17/2020 16:36 1.528223

6/17/2020 16:39 1.495416

6/17/2020 16:42 1.466437

6/17/2020 16:45 1.434497

6/17/2020 16:48 1.409172

6/17/2020 16:51 1.386879

6/17/2020 16:54 1.368951

6/17/2020 16:57 1.347665

6/17/2020 17:00 1.326514

6/17/2020 17:03 1.310051

6/17/2020 17:06 1.286909

6/17/2020 17:09 1.266743

6/17/2020 17:12 1.259417

6/17/2020 17:15 1.243402

6/17/2020 17:18 1.229384

6/17/2020 17:21 1.209849

6/17/2020 17:24 1.194165

6/17/2020 17:27 1.176138

6/17/2020 17:30 1.159203

6/17/2020 17:33 1.149734

6/17/2020 17:36 1.141284

6/17/2020 17:39 1.137412

6/17/2020 17:42 1.120721

6/17/2020 17:45 1.106099

6/17/2020 17:48 1.098758

6/17/2020 17:51 1.083296

6/17/2020 17:54 1.077556

6/17/2020 17:57 1.057597

6/17/2020 18:00 1.04544

6/17/2020 18:03 1.02466

6/17/2020 18:06 1.006053

6/17/2020 18:09 0.98947

6/17/2020 18:12 0.954011

6/17/2020 18:15 0.917343

6/17/2020 18:18 0.883744

6/17/2020 18:21 0.845521

6/17/2020 18:24 0.815539

6/17/2020 18:27 0.772695

6/17/2020 18:30 0.739135

6/17/2020 18:33 0.692992

6/17/2020 18:36 0.652402

6/17/2020 18:39 0.627838

6/17/2020 18:42 0.595618

6/17/2020 18:45 0.561514

6/17/2020 18:48 0.53706

6/17/2020 18:51 0.513898

6/17/2020 18:54 0.480608

6/17/2020 18:57 0.434962

6/17/2020 19:00 0.397519

6/17/2020 19:03 0.365103

6/17/2020 19:06 0.329765

6/17/2020 19:09 0.306645

6/17/2020 19:12 0.268028

6/17/2020 19:15 0.229591

6/17/2020 19:18 0.207665

6/17/2020 19:21 0.202729

6/17/2020 19:24 0.197444

6/17/2020 19:27 0.181848

6/17/2020 19:30 0.166456

6/17/2020 19:33 1.044285

6/17/2020 19:36 2.34683

6/17/2020 19:39 3.591161

6/17/2020 19:42 4.089999

6/17/2020 19:45 4.022981

6/17/2020 19:48 3.555089

6/17/2020 19:51 2.799086

6/17/2020 19:54 1.834875

6/17/2020 19:57 0.727851

6/17/2020 20:00 -0.47314

6/17/2020 20:03 -1.72457

6/17/2020 20:06 -2.71089

6/17/2020 20:09 -3.13875

6/17/2020 20:12 -3.47471

6/17/2020 20:15 -3.84727

6/17/2020 20:18 -4.98164

6/17/2020 20:21 -6.39534

6/17/2020 20:24 -7.94914

6/17/2020 20:27 -9.55318

6/17/2020 20:30 -11.1314

6/17/2020 20:33 -12.6307

6/17/2020 20:36 -14.0072

6/17/2020 20:39 -15.2337

6/17/2020 20:42 -15.7641

6/17/2020 20:45 -15.7752

6/17/2020 20:48 -15.642

6/17/2020 20:51 -15.7061

6/17/2020 20:54 -16.1807

6/17/2020 20:57 -16.7458

6/17/2020 21:00 -17.3123

6/17/2020 21:03 -17.7935

6/17/2020 21:06 -18.1545

6/17/2020 21:09 -18.3486

6/17/2020 21:12 -18.3574

6/17/2020 21:15 -18.1915

6/17/2020 21:18 -17.0992

6/17/2020 21:21 -15.8845

6/17/2020 21:24 -14.9162

6/17/2020 21:27 -14.0407

6/17/2020 21:30 -13.191

6/17/2020 21:33 -12.3026

6/17/2020 21:36 -11.3613

6/17/2020 21:39 -10.337

6/17/2020 21:42 -9.23082

6/17/2020 21:45 -8.05817

6/17/2020 21:48 -6.81575

6/17/2020 21:51 -5.23192

6/17/2020 21:54 -3.06491

6/17/2020 21:57 -1.23498

6/17/2020 22:00 0.200748

6/17/2020 22:03 1.35843

6/17/2020 22:06 2.281873

6/17/2020 22:09 3.01339

6/17/2020 22:12 3.546348

6/17/2020 22:15 3.884602

6/17/2020 22:18 4.026345

6/17/2020 22:21 3.948517

6/17/2020 22:24 3.640955

6/17/2020 22:27 3.614196

6/17/2020 22:30 3.643719

6/17/2020 22:33 2.765177

6/17/2020 22:36 2.342445

6/17/2020 22:39 2.462059

6/17/2020 22:42 2.979221

6/17/2020 22:45 3.246842

6/17/2020 22:48 3.290206

6/17/2020 22:51 3.160956

6/17/2020 22:54 2.884259

6/17/2020 22:57 2.441904

6/17/2020 23:00 1.845557

6/17/2020 23:03 1.087973

6/17/2020 23:06 0.156654

6/17/2020 23:09 -0.58646

6/17/2020 23:12 -0.6383

6/17/2020 23:15 -0.2217

6/17/2020 23:18 0.639323

6/17/2020 23:21 1.108387

6/17/2020 23:24 1.437823

6/17/2020 23:27 1.644455

6/17/2020 23:30 1.701494

6/17/2020 23:33 1.61865

6/17/2020 23:36 1.400407

6/17/2020 23:39 1.007351

6/17/2020 23:42 0.42882

6/17/2020 23:45 0.343745

6/17/2020 23:48 0.850172

6/17/2020 23:51 1.761171

6/17/2020 23:54 2.745089

6/17/2020 23:57 3.450748

6/18/2020 00:00 4.006784

6/18/2020 00:03 4.431616

6/18/2020 00:06 4.718489

6/18/2020 00:09 4.867503

6/18/2020 00:12 4.876232

6/18/2020 00:15 4.728373

6/18/2020 00:18 4.394422

6/18/2020 00:21 4.83862

6/18/2020 00:24 5.491755

6/18/2020 00:27 5.961135

6/18/2020 00:30 6.29349

6/18/2020 00:33 7.284185

6/18/2020 00:36 8.156679

6/18/2020 00:39 8.417994

6/18/2020 00:42 8.215418

6/18/2020 00:45 7.631271

6/18/2020 00:48 6.719334

6/18/2020 00:51 5.52954

6/18/2020 00:54 4.459374

6/18/2020 00:57 4.073378

6/18/2020 01:00 3.62132

6/18/2020 01:03 3.009204

6/18/2020 01:06 2.291696

6/18/2020 01:09 1.482075

6/18/2020 01:12 0.618816

6/18/2020 01:15 -0.32206

6/18/2020 01:18 -1.33559

6/18/2020 01:21 -2.40148

6/18/2020 01:24 -3.53134

6/18/2020 01:27 -4.72169

6/18/2020 01:30 -5.27023

6/18/2020 01:33 -4.2677

6/18/2020 01:36 -3.15388

6/18/2020 01:39 -2.12284

6/18/2020 01:42 -1.75653

6/18/2020 01:45 -1.83115

6/18/2020 01:48 -2.18182

6/18/2020 01:51 -2.67613

6/18/2020 01:54 -3.25216

6/18/2020 01:57 -3.83944

6/18/2020 02:00 -4.42343

6/18/2020 02:03 -4.97014

6/18/2020 02:06 -5.44231

6/18/2020 02:09 -5.84236

6/18/2020 02:12 -6.13719

6/18/2020 02:15 -6.33132

6/18/2020 02:18 -6.42971

6/18/2020 02:21 -6.43405

6/18/2020 02:24 -6.33669

6/18/2020 02:27 -6.15189

6/18/2020 02:30 -5.87392

6/18/2020 02:33 -5.52024

6/18/2020 02:36 -5.09497

6/18/2020 02:39 -4.58085

6/18/2020 02:42 -4.00915

6/18/2020 02:45 -3.38801

6/18/2020 02:48 -2.73247

6/18/2020 02:51 -2.04571

6/18/2020 02:54 -1.33828

6/18/2020 02:57 -0.63013

6/18/2020 03:00 0.073803

6/18/2020 03:03 0.753273

6/18/2020 03:06 1.398587

6/18/2020 03:09 1.99532

6/18/2020 03:12 2.536196

6/18/2020 03:15 2.990178

6/18/2020 03:18 3.358747

6/18/2020 03:21 3.599109

6/18/2020 03:24 3.716866

6/18/2020 03:27 3.688318

6/18/2020 03:30 3.505254

6/18/2020 03:33 3.15523

6/18/2020 03:36 3.656629

6/18/2020 03:39 4.529403

6/18/2020 03:42 5.280225

6/18/2020 03:45 5.923858

6/18/2020 03:48 6.477154

6/18/2020 03:51 6.942701

6/18/2020 03:54 7.314103

6/18/2020 03:57 7.586743

6/18/2020 04:00 7.768521

6/18/2020 04:03 7.833456

6/18/2020 04:06 7.772651

6/18/2020 04:09 7.584391

6/18/2020 04:12 7.25814

6/18/2020 04:15 6.800161

6/18/2020 04:18 6.189406

6/18/2020 04:21 5.410289

6/18/2020 04:24 4.461224

6/18/2020 04:27 3.325152

6/18/2020 04:30 2.00382

6/18/2020 04:33 0.477097

6/18/2020 04:36 -0.24241

6/18/2020 04:39 -0.35457

6/18/2020 04:42 0.041193

6/18/2020 04:45 0.308102

6/18/2020 04:48 0.469548

6/18/2020 04:51 0.556968

6/18/2020 04:54 0.620655

6/18/2020 04:57 0.657636

6/18/2020 05:00 0.678156

6/18/2020 05:03 0.692729

6/18/2020 05:06 0.697472

6/18/2020 05:09 0.70634

6/18/2020 05:12 0.703003

6/18/2020 05:15 0.69049

6/18/2020 05:18 0.683043

6/18/2020 05:21 0.672112

6/18/2020 05:24 0.662134

6/18/2020 05:27 0.660625

6/18/2020 05:30 0.652712

6/18/2020 05:33 0.65076

6/18/2020 05:36 0.638201

6/18/2020 05:39 0.622194

6/18/2020 05:42 0.606493

6/18/2020 05:45 0.591793

6/18/2020 05:48 0.580046

6/18/2020 05:51 0.572105

6/18/2020 05:54 0.560508

6/18/2020 05:57 0.548282

6/18/2020 06:00 0.53475

6/18/2020 06:03 0.518283

6/18/2020 06:06 0.50421

6/18/2020 06:09 0.48863

6/18/2020 06:12 0.481914

6/18/2020 06:15 0.479289

6/18/2020 06:18 0.464928

6/18/2020 06:21 0.455616

6/18/2020 06:24 0.447814

6/18/2020 06:27 0.435374

6/18/2020 06:30 0.428075

6/18/2020 06:33 0.42219

6/18/2020 06:36 0.416461

6/18/2020 06:39 0.410534

6/18/2020 06:42 0.407779

6/18/2020 06:45 0.418838

6/18/2020 06:48 0.419501

6/18/2020 06:51 0.425086

6/18/2020 06:54 0.429979

6/18/2020 06:57 0.438441

6/18/2020 07:00 0.438404

6/18/2020 07:03 0.452007

6/18/2020 07:06 0.458128

6/18/2020 07:09 0.462345

6/18/2020 07:12 0.46757

6/18/2020 07:15 0.473313

6/18/2020 07:18 0.483109

6/18/2020 07:21 0.486636

6/18/2020 07:24 0.494235

6/18/2020 07:27 0.504566

6/18/2020 07:30 0.52274

6/18/2020 07:33 0.541773

6/18/2020 07:36 0.562891

6/18/2020 07:39 0.578601

6/18/2020 07:42 0.59423

6/18/2020 07:45 0.601239

6/18/2020 07:48 0.613334

6/18/2020 07:51 0.625786

6/18/2020 07:54 0.632135

6/18/2020 07:57 0.642566

6/18/2020 08:00 0.651175

6/18/2020 08:03 0.663019

6/18/2020 08:06 0.675872

6/18/2020 08:09 0.696704

6/18/2020 08:12 0.730387

6/18/2020 08:15 0.758341

6/18/2020 08:18 0.774394

6/18/2020 08:21 0.787607

6/18/2020 08:24 0.798443

6/18/2020 08:27 0.826832

6/18/2020 08:30 0.857142

6/18/2020 08:33 0.875847

6/18/2020 08:36 0.898378

6/18/2020 08:39 0.910103

6/18/2020 08:42 0.914655

6/18/2020 08:45 0.913636

6/18/2020 08:48 0.911163

6/18/2020 08:51 0.910816

6/18/2020 08:54 0.919243

6/18/2020 08:57 0.914578

6/18/2020 09:00 0.908251

6/18/2020 09:03 0.904348

6/18/2020 09:06 0.884208

6/18/2020 09:09 0.877857

6/18/2020 09:12 0.873555

6/18/2020 09:15 0.872162

6/18/2020 09:18 0.873047

6/18/2020 09:21 0.875936

6/18/2020 09:24 0.875969

6/18/2020 09:27 0.889946

6/18/2020 09:30 0.89583

6/18/2020 09:33 0.908026

6/18/2020 09:36 0.920075

6/18/2020 09:39 0.932557

6/18/2020 09:42 0.9443

6/18/2020 09:45 0.962532

6/18/2020 09:48 0.9862

6/18/2020 09:51 1.005718

6/18/2020 09:54 1.036823

6/18/2020 09:57 1.069963

6/18/2020 10:00 1.108882

6/18/2020 10:03 1.14522

6/18/2020 10:06 1.190327

6/18/2020 10:09 1.229018

6/18/2020 10:12 1.265254

6/18/2020 10:15 1.299888

6/18/2020 10:18 1.331513

6/18/2020 10:21 1.367302

6/18/2020 10:24 1.393941

6/18/2020 10:27 1.422919

6/18/2020 10:30 1.446511

6/18/2020 10:33 1.477839

6/18/2020 10:36 1.506781

6/18/2020 10:39 1.540628

6/18/2020 10:42 1.578518

6/18/2020 10:45 1.616707

6/18/2020 10:48 1.646568

6/18/2020 10:51 1.67255

6/18/2020 10:54 1.680161

6/18/2020 10:57 1.687723

6/18/2020 11:00 1.688608

6/18/2020 11:03 1.682559

6/18/2020 11:06 1.684657

6/18/2020 11:09 1.683691

6/18/2020 11:12 1.670607

6/18/2020 11:15 1.674938

6/18/2020 11:18 1.673635

6/18/2020 11:21 1.657132

6/18/2020 11:24 1.632367

6/18/2020 11:27 1.604702

6/18/2020 11:30 1.594143

6/18/2020 11:33 1.595869

6/18/2020 11:36 1.591332

6/18/2020 11:39 1.599467

6/18/2020 11:42 1.600985

6/18/2020 11:45 1.596597

6/18/2020 11:48 1.594802

6/18/2020 11:51 1.601423

6/18/2020 11:54 1.615931

6/18/2020 11:57 1.643929

6/18/2020 12:00 1.667038

6/18/2020 12:03 1.69193

Best Answer

Is the data loaded in MATLAB? If yes, you can do something like this

dts; % datetime vector;
Transp_val; % Transpiration values
hrs = hour(dts)
mask = (hrs > 4) & (hrs < 19);
filtered_dts = dts(mask);
filtered_Transp_val = Transp_val(mask);

Related Solutions

MATLAB: Remove all NaN values from an array.

Use these lines

idx = any(isnan(D), 2);
E = D(~idx, :);

MATLAB: Reshape an array into another

a = [1    2    3    4  5   6    7  8;...
    9   10  11 12 13 14 15 16;...
    17 18 19 20 21 22  23 24;...
    25 26 27 28 29 30 31  32];
a = [a(:,1:end/2);a(:,end/2+1:end)]

Related Question

• How to create a column for occupied and unoccupied in which each value in the column is a linspace timeline? I understand the timeline length for each value will be different.
• Delete dates from a matrix
• Finding the dominant frequency via fourier transform

Answer 1

Is the data loaded in MATLAB? If yes, you can do something like this

dts; % datetime vector;
Transp_val; % Transpiration values
hrs = hour(dts)
mask = (hrs > 4) & (hrs < 19);
filtered_dts = dts(mask);
filtered_Transp_val = Transp_val(mask);