Convert time in decimal days into hh:mm:ss format

35 次查看（过去 30 天）

显示更早的评论

Zach Morag 2021-12-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1603440-convert-time-in-decimal-days-into-hh-mm-ss-format

编辑： TAMRABET 2023-1-27

Hi all,

Just encounter some issue regarding converting time logs from excel

when I used readtable functrion the time from excel was hh:mm:ss and ocnverted at MATLAB to decimal in days

for example: 12:06:30 in excel was converted to 0.504513888888889 in MATLAB.

so how can I conerted to hh:nn:ss?

回答（2 个）

Stephen23 2021-12-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1603440-convert-time-in-decimal-days-into-hh-mm-ss-format#answer_847945

编辑：Stephen23 2021-12-5

在 MATLAB Online 中打开

N = 0.504513888888889;
T = days(N);
T.Format = 'hh:mm:ss'
T = duration
   12:06:30

D = datetime(N,'ConvertFrom','excel');
T = timeofday(D)
T = duration
   12:06:30

11 个评论
显示 9更早的评论隐藏 9更早的评论

Stephen23 2021-12-6

在 MATLAB Online 中打开

Zach Morag's incorrectly posted "Answer" moved here:

if Im using days, as you wrote, the output is this:

and if Im using datetime:

scaleLog.('Time [hh:mm:ss]') = datetime(scaleLog{:,2},'ConvertFrom','excel');
scaleLog{:,2}.Format = "HH:mm:ss";

the output is that:

How can I remove the date and remain only with the time?

Stephen23 2021-12-6

编辑：Stephen23 2021-12-6

在 MATLAB Online 中打开

@Zach Morag: Yes, can I remember meeting this exact issue a few years ago. Apparently it is not possible to use curly-brace indexing to change the format of an already existing datetime variable in a table:

D = datetime(2021,12,[1;31]);
N = [2;3];
T = table(D,N)
T = 2×2 table
         D         N
    ___________    _

    01-Dec-2021    2
    31-Dec-2021    3
T{:,1}.Format = 'yyyy-MM-dd' % Using indexing does not work...
T = 2×2 table
         D         N
    ___________    _

    01-Dec-2021    2
    31-Dec-2021    3
T.D.Format = 'yyyy-MM-dd' % but using variable names works!
T = 2×2 table
        D         N
    __________    _

    2021-12-01    2
    2021-12-31    3