How to convert from decimal time to hh:mm:ss
18 views (last 30 days)
Show older comments
Caroline
on 29 Jul 2013
Commented: John Rodriguez
on 21 Feb 2019
I am using xlsread to read an excel spreadsheet. One of the values that it is reading is time. Inside the spreadsheet the time is in the correct format (hh:mm:ss), however the value that xlsread returns for the time is a decimal. Does anyone know how to convert this value to the hh:mm:ss format in either MATLAB or C++?
Thanks!
0 Comments
Accepted Answer
Azzi Abdelmalek
on 29 Jul 2013
datestr(yournumber,'HH:MM:SS')
3 Comments
Mohamed Nedal
on 22 Nov 2017
Hello Azzi, I've tried your answer on this time ( 2637 minutes) but I've got
00:00:00
Could you please tell me how to convert this time in this case?
John Rodriguez
on 21 Feb 2019
I'm getting the same result. My data is in the format HHMMSS and I want it to go to HH:MM:SS. I'm now just getting 00:00:00 for my full array.
More Answers (2)
Jan
on 29 Jul 2013
Edited: Jan
on 29 Jul 2013
Microsoft has bee so smart to invent two different serial date numbers: One for Windows and one for Macs.
if ismac
MatlabDate = datestr(ExcelDateNum + 695422, 13);
else
MatlabDate = datestr(ExcelDateNum + 693960, 13);
end
Unfortunately this is very wrong, because it does not matter, if the current computer is a Mac, but if the Excel file was stored on a Mac. But I do not know a method to find out this detail.
0 Comments
Peter Perkins
on 29 Nov 2017
Unless you are using an older version of MATLAB, you are likely better off using readtable (instead of xlsread) and datetime (instead of datestr and datenum). Even if you use xlsread to read Excel serial date numbers, you can use
dates = datetime(excelDates,'ConvertFrom','excel') % or 'excel1904'
2 Comments
Tunga Rangaswamy
on 5 Dec 2018
Edited: Tunga Rangaswamy
on 5 Dec 2018
This works great! It produces date in day-month-year format and time in hh:mm:ss format. How do I get time in hh:mm:ss.mmm (including milliseconds)?
Peter Perkins
on 11 Dec 2018
Assuming you mean "the time portion of a datetime", you'd need to set the Format property to include HH:mm:ss.SSS. Look at the documentation for datetime.Format.
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!