Thread Subject:

About Time Reading from exel file in matlab..

Dear Sir/Madam ,I am reading time information i.e (Hour:Minitue:Second) format from Exel file by using command xlsread.here my problem its taking in numeric(i.e I have one time coloum data starting from 17:03:28 to 18:03:30 with one second interval ,it is giving output in the format of 0.7170 so on ).I need help to retrive this 0.7117 to time format.please help me in this issue...I need very urgently.

"Shaik Ghouse Basha" <mdbasha@gmail.com> wrote in message <h159r1$fc$1@fred.mathworks.com>...
> Dear Sir/Madam ,I am reading time information i.e (Hour:Minitue:Second) format from Exel file by using command xlsread.here my problem its taking in numeric(i.e I have one time coloum data starting from 17:03:28 to 18:03:30 with one second interval ,it is giving output in the format of 0.7170 so on ).I need help to retrive this 0.7117 to time format.please help me in this issue...I need very urgently.

the 2nd post by nztideman in this thread might be helpful

http://www.mathworks.fr/matlabcentral/newsreader/view_thread/167463

us

On 15 Jun, 13:04, "Shaik Ghouse Basha" <mdba...@gmail.com> wrote:
> Dear Sir/Madam ,I am reading time information i.e (Hour:Minitue:Second) format from Exel file by using command xlsread.here my problem its taking in numeric(i.e I have one time coloum data starting from  17:03:28 to 18:03:30 with one second interval ,it is giving output in the format of 0.7170 so on ).I need help to retrive this 0.7117 to time format.please help me in this issue...I need very urgently.

The numebrs are almost certainly normalized in unit
hh:mm:ss.ssss over 24 hrs. It's a trivial (if tedious)
excercise to denormalize the numbers.

Rune