hy!!
I want to transfom 00:02:17 in seconds -- can u guys help me pls!?
thanks!!
hy!!
I want to transfom 00:02:17 in seconds -- can u guys help me pls!?
thanks!!
=N(M1*24*60*60)
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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)
If you want to convert a constant, use
="00:02:17"*24*60*60
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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 !
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)
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
thanks!!!