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

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


"mangesh" <mangesh.2a0v3z_1151346602.1541@excelforum-nospam.com> wrote
in message news:mangesh.2a0v3z_1151346602.1541@excelforum-nospam.com:

> 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

Jim's formula would give you 22277 in another cell (using your example). Alternatively you could just format your original cell(s) with a custom format of

[s]