MATLAB Answers

Converting hourly data to per shift data

60 views (last 30 days)
Viktor Mirchev
Viktor Mirchev on 28 Sep 2020 at 7:03
Commented: Viktor Mirchev on 28 Sep 2020 at 9:26
Hello,
I would highly appreciate help with the following example.
I have houtly data and I need to convert it to per shift data, where I have 4 shifts that start and end at specific hour:
Shift Start End
A 00:00 07:00
B 07:00 14:00
C 14:00 17:00
D 17:00 00:00
I would like to create a new table where I will see: Date / Shift / Value for the shift*
* the value for each shift is a sum of the respective hours which are included in each shift.
Attached you can find xlsx with sample data.
Thank you for your time!

  2 Comments

Sudhakar Shinde
Sudhakar Shinde on 28 Sep 2020 at 9:00
%You could try:
data = readtable('Hourly2Shift.xlsx');
infmt = 'yyyy-MM - dd''T''HH:mm:ss.S'
%Shift A
starttime = datetime('2020-08 - 1T00:00:00.00', 'InputFormat', infmt);
endtime = datetime('2020-08 - 1T07:00:00.00', 'InputFormat', infmt)
selected = data(isbetween(data.Date, starttime, endtime), :)
Viktor Mirchev
Viktor Mirchev on 28 Sep 2020 at 9:26
Hello, Sudhakar,
Thank you very much for the answer.
I tryed what you suggested, unfortunately I get the following error message:
Error using datetime/isbetween (line 43)
Unable to convert text array to a datetime array because the format was not recognized.
Any suggestion how to resolve it?
Thank you!

Sign in to comment.

Answers (0)

Products


Release

R2019b

Community Treasure Hunt

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

Start Hunting!