Minutes to seconds
 

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=487030

Minutes to seconds
 

=C10*24*60*60

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Partysquad" wrote
in message ...

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=487030