Convert seconds to HH:MM:SS.FF

57 views (last 30 days)
Yu
Yu on 27 Aug 2021
Commented: Yu on 27 Aug 2021
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);

Accepted Answer

Walter Roberson
Walter Roberson on 27 Aug 2021
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';
  3 Comments
Walter Roberson
Walter Roberson on 27 Aug 2021
sample.SECONDS = sample.TIME + seconds(sample.NANOSECONDS*10^(-9));
sample.SECONDS.Format = 'HH:mm:ss.SS';
Yu
Yu on 27 Aug 2021
This worked well!
Thank you so much! I really appreciate your help.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!