Convert seconds to HH:MM:SS.FF

I have time stamps that have hh:mm:ss and nanoseconds in different columns and want to convert them to hh:mm:ss.ff.

I did as following but have no idea what to do next.

Any ideas on how can I do this?

Thanks.

clear 
load sample.mat

sample.SECONDS = datenum(sample.TIME)+sample.NANOSECONDS*10^(-9);

Answer 1

[Walter Roberson]

sample.SECONDS = datenum(sample.TIME) + seconds(sample.NANOSECONDS*10^(-9));

sample.SECONDS.Format = 'hh:mm:ss.ff';

The second step will be rejected because datetime() objects have no 'ff' format specification. (And be careful, since for datetime() object, 'hh' is hour in 12 hour notation)

Perhaps you want to use datenum objects. However, datenum objects do not have a 'ff' specification either: they have a 'FF' specification.

I recommend

sample.SECONDS.Format = 'HH:mm:ss.SS';

[Yu]

Thanks for the detailed explanation!

I tried your code but it gave me an error as below.

But when I changed 'HH' into 'hh', it worked successfully. (as Star said earlier)

I'd like to use 'HH'. What should I do?

Thanks.

sample.SECONDS = datenum(sample.TIME) + seconds(sample.NANOSECONDS*10^(-9));
sample.SECONDS.Format = 'hh:mm:ss.SS'

Error using load
Unable to read file 'sample.mat'. No such file or directory.

[Walter Roberson]

sample.SECONDS = sample.TIME + seconds(sample.NANOSECONDS*10^(-9));
sample.SECONDS.Format = 'HH:mm:ss.SS';

[Yu]

This worked well!

Thank you so much! I really appreciate your help.