How to convert time into seconds.

[mangesh]

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

 

[Guest]

hi,

try

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

hth
regards from Brazil
Marcelo

"mangesh" escreveu:

 

[Jim May]

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

 

[daddylonglegs]

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