View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo
 
Posts: n/a
Default How to convert time into seconds.

hi,

try

=hour(a1)*3600+minute(a1)*60+second(a1)

hth
regards from Brazil
Marcelo

"mangesh" escreveu:


Hi,

Can someone please let me know how to convert timing into "seconds".
For example if timing is 6:11:17 it should be converted into "Seconds".


--
mangesh


------------------------------------------------------------------------
mangesh's Profile: http://www.excelforum.com/member.php...fo&userid=6746
View this thread: http://www.excelforum.com/showthread...hreadid=555706