View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default Weekday + Time Calculation in Cell

Format as [s].
If you want to use the number 91 in a subsequent calculation, then use the
formula =A1*24*3600 (and format as general or number, not time).
--
David Biddulph

"Mikkel" wrote in message
...
Hallo

I have a quistion about time formats in exel too.

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