Time.
 

Hi.

I can't get a output of a value entered in min, second, and two digids at the
end into seconds.

The cell is set to text and the value is: 13,30,32

This time I want to have in another cell as 810,32 seconds

How to do this in excel?

Steinar.

Time.
 

Assuming your text data is in cell A1

=LEFT(A1,2)*60+MID(A1,4,2)&","&RIGHT(A1,2)

--
Michael Hopwood


"Steinar Vissebråten" wrote in message
...

Hi.

I can't get a output of a value entered in min, second, and two digids at
the
end into seconds.

The cell is set to text and the value is: 13,30,32

This time I want to have in another cell as 810,32 seconds

How to do this in excel?

Steinar.

Time.
 

On Fri, 5 Dec 2003 22:45:04 -0000, "Michael Hopwood"
wrote:

Using 13,32,32 in A1 and entering the string in B1 I get a mistake in this
line!

It does not work and the A is set to text just to make sure it is not anything
else making the problem.


Assuming your text data is in cell A1

=LEFT(A1,2)*60+MID(A1,4,2)&","&RIGHT(A1,2)

Steinar Vissebråten
http://home.online.no/~steinv

Time.
 

Hi,

This is not working!

I entered this into the cell I want to get output as seconds and two
decimals. It is a mistake in the line?

=left(a1,2)*60+mid(a1,4,2)&","&right(a1,2)

I do explain more.:

The time is in minutes, seconds, 2 decimals it can also be just seconds
as; 40,00

In another cell I want this two to be as an output of seconds, 2
decimals

The input cell could be any value - time entered coukd be:
12,12,12
40,00

and the output cell should say:
732,12
40,00

The line above does not work for me - sorry.

Steinar.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Time.
 

Try:

=if(len(A1)=5,A1,left(a1,2)*60+mid(a1,4,2)&","&rig ht(a1,2))

--
Michael Hopwood


"Steinar Vissebråten" wrote in message
...


Hi,

This is not working!

I entered this into the cell I want to get output as seconds and two
decimals. It is a mistake in the line?

=left(a1,2)*60+mid(a1,4,2)&","&right(a1,2)

I do explain more.:

The time is in minutes, seconds, 2 decimals it can also be just seconds
as; 40,00

In another cell I want this two to be as an output of seconds, 2
decimals

The input cell could be any value - time entered coukd be:
12,12,12
40,00

and the output cell should say:
732,12
40,00

The line above does not work for me - sorry.

Steinar.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!