Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

Thread Subject:
How do you read time data from xls files?

Subject: How do you read time data from xls files?

From: Marcio Barbalho

Date: 6 Mar, 2010 01:20:22

Message: 1 of 3


Example:

I created an xls file 'times.xls' which contains only:

10:30:40
01:56:04
12:26:44

xlsread gave me this:

0.4380
0.0806
0.5186

What does that mean? I know there's a linear equation (y = ax + b) that can representate them.... but... how does it work?

Subject: How do you read time data from xls files?

From: Marcio Barbalho

Date: 6 Mar, 2010 01:29:05

Message: 2 of 3

>
> What does that mean? I know there's a linear equation (y = ax + b) that can representate them.... but... how does it work?

I meant 'represent', not 'representate' as above. Sorry for that.

Subject: How do you read time data from xls files?

From: TideMan

Date: 6 Mar, 2010 03:07:42

Message: 3 of 3

On Mar 6, 2:20 pm, "Marcio Barbalho" <marciobarba...@yahoo.com> wrote:
> Example:
>
> I created an xls file 'times.xls' which contains only:
>
> 10:30:40
> 01:56:04
> 12:26:44
>
> xlsread gave me this:
>
> 0.4380
> 0.0806
> 0.5186
>
> What does that mean? I know there's a linear equation (y = ax + b) that can representate them.... but... how does it work?

Proportions of a day.
Multiply by 24 to get hours, 1440 to get minutes, 86400 to get seconds
from midnight.

Tags for this Thread

No tags are associated with this thread.

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

Contact us