Minuts and Seconds to only seconds???
 

Hallo

I have a question about time formats in exel.

If I f.ex have the time 1 minut and 31 seconds (tt:mm:ss) = 0:01:31 but i
want the time only in seconds (ss) = 91.

How do I do that?

I hope you can help me!

Greetings

Mikkel

Minuts and Seconds to only seconds???
 

=A1*86400

Format cell as General


"Mikkel" wrote:

Hallo

I have a question about time formats in exel.

If I f.ex have the time 1 minut and 31 seconds (tt:mm:ss) = 0:01:31 but i
want the time only in seconds (ss) = 91.

How do I do that?

I hope you can help me!

Greetings

Mikkel

Minuts and Seconds to only seconds???
 

to display only seconds use this custom number format
[ss]
the brackets allow for the overflow.

to calculate the number of seconds use the following formula (similar to one
already given by Teethless.
=A1*24*60*60
you will need to format the cell as a number (or general).

"Mikkel" wrote:

Hallo

I have a question about time formats in exel.

If I f.ex have the time 1 minut and 31 seconds (tt:mm:ss) = 0:01:31 but i
want the time only in seconds (ss) = 91.

How do I do that?

I hope you can help me!

Greetings

Mikkel