Taking colons from an excel spreadsheet

1 view (last 30 days)

Michael on 3 Oct 2013

I have an excel spreadsheet with timestamps that may be in mm:ss format as opposed to mm.ss

When import using xlsread, the colon timestamps are converted into the "general" format. (This conversion probably happens on the excel end.

Is there a way, without using ActiveX for matlab to determine whether there is a colon or a period in the timestamp?

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