The formula you want is =C10*24*60*60 formatted as general. Why?


Times are really numbers where 1.0 is actually a day. Multiply by 24 to get
hours, then by 60 to get minutes, then by 60 again to get seconds.
--
Gary's Student


"Partysquad" wrote:


Hi, I'm facing a little problem and I have no idea how to solve this, so
I hope some of you guys can help me out on this.

I'd like to see a time of for instance 6:08.74 (6 minutes, 8 seconds
and 74 hundreds) to be calculated as a value of 368.74 seconds.
So let's say C10 says 6:08.74 then I'd like to have a formula in C11
which tells me that it's the same as 368.74 seconds.

Hope you guys can help me out,
thanks is advance

Partysquad.


--
Partysquad
------------------------------------------------------------------------
Partysquad's Profile: http://www.excelforum.com/member.php...o&userid=28970
View this thread: http://www.excelforum.com/showthread...hreadid=487040