Solved: convert time

[neditheg]

hy!!

I want to transfom 00:02:17 in seconds -- can u guys help me pls!?

thanks!!

[Bob Phillips]

=N(M1*24*60*60)

[neditheg]

If I do : 00:02:17*24*60*60= #VALUE!# :) and I don't know what is N

(I thimk M1=00:02:17 -cell)

[Bob Phillips]

If you want to convert a constant, use

="00:02:17"*24*60*60

[neditheg]

my english sucks :P

so I have in A1 cell this time expresion 00:02:17 and I want to convert it in seconds ...
I know to transform seconds in hh:mm:ss format .. and i knew that if I want to transform HH:mm:ss time format in seconds I must multiply with 24*60*60 ... but 00:02:10 * 24*60*60 = #value!#

so can u say me what means N in ur formula ... or use the attach :)

thanks ! :)

[Bob Phillips]

You have spaces in the A1 in front of the time value, that is what is causing the problem.

Try

=N(TRIM(A1)*24*60*60)

[neditheg]

thanks!!! :)