MATLAB: Import time into matrix and display as minutes after midnight

time convert

hi guys, I have imported an excel file into matlab. 10:00 is displayed as 0.416666666666667. I want to display this as minutes after midnight. ANy ideas?

thanks,

Best Answer

It appears to be in fractions of a day, so multiply it by minutes in a day:

t = 0.416666666666667;
min_after_mn = t * 24*60;
min_after_mn =
   600.0000

Related Solutions

MATLAB: Hi, i have two dates like 2013_12_28 and 2014_01_06, and i want to calculate the mean date (2014_01_01) which would be in the form of 2014.0014

md = mean(datenum({'2013_12_28', '2014_01_06'}, 'YYYY_mm_dd'));
dv = datevec(md);
days_into_year = md - datenum([dv(1),1,1]);

But once you have days_into_year you have to convert that into a year fraction, which requires careful definition of how long a "year" is. Is a "year" 365 days, always? Is a "year" 365.2421875 days? Is a "year" 365 days for non-leap years but 366 days for leap-years? If so then should it be 365 days for dates in the year before the leap day but 366 for dates on or after the leap day?

Converting to a specific date is much easier, and getting the result in terms of days is easy, but fraction of a year needs clarification.

MATLAB: Changing minutes after midnight into a datetime array

"but I only need the MI" I don't think you can avoid the date and time.

X = 60*[1,2,3,4,5,6,7];
T = datetime( X, 'ConvertFrom','epochtime', 'Epoch','2000-01-01' )
T = 
Columns 1 through 4
   2000-01-01 00:01:00   2000-01-01 00:02:00   2000-01-01 00:03:00   2000-01-01 00:04:00
Columns 5 through 7
   2000-01-01 00:05:00   2000-01-01 00:06:00   2000-01-01 00:07:00

and

>> T.Minute
ans =
     1     2     3     4     5     6     7

Remark: the year 2000 is a leap year.

Best Answer

Related Solutions

MATLAB: Hi, i have two dates like 2013_12_28 and 2014_01_06, and i want to calculate the mean date (2014_01_01) which would be in the form of 2014.0014

MATLAB: Changing minutes after midnight into a datetime array

Related Question