Time.

  • Thread starter Thread starter Steinar Vissebråten
  • Start date Start date
S

Steinar Vissebråten

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.
 
Assuming your text data is in cell A1

=LEFT(A1,2)*60+MID(A1,4,2)&","&RIGHT(A1,2)
 
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)
Click to expand...

Steinar Vissebråten
http://home.online.no/~steinv
 
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.
 
Back
Top