how to take mean of every second data in a minute and an hourly?

I have data every second like

A = 16:22:54

16:22:55

16:22:56

16:22:57

.........

.........

B = 91.964

92.384

81.198

NAN

82.222

.........

.........

I want to make a new matrix which has every minute mean data.

please find the attached files. (Note: Time is in numeric formate)

Thank you

Answer 1

[Walter Roberson]

We recommend creating timetable() and using the retime() function.

[Vishnu Dhakad]

Thank you Roberson

[Vishnu Dhakad]

Hi

I want to calculate std also.

using retime function I did not get.

can you help me?

Answer 2

[Walter Roberson]

 TT2 = retime(TT1, 'minute', @std);

[Vishnu Dhakad]

Thanks for quick responce,

Function is working without ERROR but all value are NaN.

Please find the attachment of TT1 and TT2.

[Steven Lord]

What's the standard deviation of an array with no elements?

>> std([])
ans =
   NaN

If any of the minute bins are empty, the standard deviation of the data in that bin should be NaN.

[Vishnu Dhakad]

Thanks

I got it.