time series? how to map time data?

Hi Guys!!

So I have two excel files that have (HR) data on them from two different devices; one of the devices I use records data every 5 seconds and the other device, sort of randomly records data, so I get multiple entries every minute. I wanted to average the data per minute and then see how the two devices compare. The devices also start recording at different times so I somehow need to match the time..

I originally wanted to do this in excel because it's easy to average it out if I get data every 5 seconds but with the device that gives me random number of entries per minute it is more difficult to do so. So, one of my supervisors suggested using matlab.

Now, there are my two questions:

1) Is this possible to do in matlab?

2) how complicated is this?

3) I am a complete newbie at this so any sort of advice, how to approach this problem and how to go about it will be very useful! -- I also have multiple of these files so ideally I'd like to make a code that will work with minor adjustments.

Thanks a bunch in advance!

[KSSV]

Read about interp1. Read both the datas and do interpolation.