How to convert time into seconds.

M

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

Marcelo

hi,

try

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

hth
regards from Brazil
Marcelo

"mangesh" escreveu:
 
D

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

 
Top