suppose the following cell array being imported from the excel file
'Date' 'Time''Date' 'Time''Mon, Apr-25-16' 0.0763888888888889 NaN NaN'Mon, Apr-25-16' 0.0763888888888889'Fri, Mar-25-16' 0.0347222222222222'Wed, Feb-24-16' 0.0347222222222222'Tue, Jan-26-16' 0.0347222222222222'Fri, Dec-25-15' 0.0347222222222222'Wed, Nov-25-15' 0.0347222222222222
Column two represents time. in the originally excel file it looks like this.
Date TimeDate TimeMon, Apr-25-16 01:50 Thu, May-26-16 01:50Mon, Apr-25-16 01:50Fri, Mar-25-16 00:50Wed, Feb-24-16 00:50Tue, Jan-26-16 00:50Fri, Dec-25-15 00:50Wed, Nov-25-15 00:50
How can I convert the column 2 into the original time format. Once I have the original time format I want to convert the time into minutes the following way:
Y(:,2)= hour(numFormat)*60 + minute(numFormat);
Best Answer