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