With a1 containing your 6:11:17
In b1 enter =A1*(60*60*24)


"mangesh" wrote
in message :

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