View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default 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