You got 2 other answers that work with thousands of seconds, TIME can only
copy with 59 seconds


--


Regards,


Peo Sjoblom


"FrankM" wrote in message
...
Actually I was wrong. That worked great when the number of seconds is
smaller
but when the number of seconds are something like 3622150 then I get an
error, #NUM! ... not sure what to do with that. It looked very promising
and
I liked the fact that I could enter a cell for the seconds and then Fill
Down
and it was looking good.



"FrankM" wrote:

That was perfect!



"Mike H" wrote:

with the date and time in A1 try this to add 30 seconds:-

=A1+TIME(0,0,30)

Mike

"FrankM" wrote:

I have two columns, one has Date and the other has seconds (they
aren't
necessarily related).

Example B2 has the value 7/12/2003 6:43:47 PM and cell C2 has the
value 58.
I had hoped that I could use the formula =B2+C2 and get the response
7/12/2003 6:44:45 PM. Unfortunately that did not work. To make
things more
complicated the column C will have values not only 58 but 3622176 and
780814
and so on (but they are always to denote seconds).

Anyone have any ideas? I think it should be fairly simple but I'm
missing
it. Any assistance would be great. Thanks!