import time into matrix and display as minutes after midnight

1 view (last 30 days)
AA
AA on 26 Oct 2017
Answered: Star Strider on 26 Oct 2017
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,

Sign in to answer this question.

Accepted Answer

Star Strider
Star Strider on 26 Oct 2017
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

More Answers (0)

Categories

Find more on Data Type Conversion in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!