read time in HH:mm format from excel

I have to read a column from excel file named Time ,the data in that column is in HH:mm format i need to read it and save it and display it in same format

Answer 1

[Walter Roberson]

filename = 'AppropriateFileName.xlsx';
opts = detectImportOptions(filename);
opts = setvaropts(opts, {'Time'}, 'Type', 'duration', 'InputFormat', 'hh:mm', 'DurationFormat', 'hh:mm');

T = readtable(filename, opts);