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
|