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
|