PDA

View Full Version : Solved: convert time



neditheg
09-02-2008, 02:11 AM
hy!!

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

thanks!!

Bob Phillips
09-02-2008, 02:18 AM
=N(M1*24*60*60)

neditheg
09-02-2008, 02:28 AM
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
09-02-2008, 02:35 AM
If you want to convert a constant, use

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

neditheg
09-02-2008, 02:48 AM
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
09-02-2008, 03:03 AM
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
09-02-2008, 03:17 AM
thanks!!! :)