not quite sure here...
B2 is your date 7/12/2003 6:43:47 PM
C2 is your INPUT cell for tick of seconds like 3622176 and 780814
maybe you can format cell B1 into "ss"or more "7s"'s...
then try in D2 with formula A2+B2 to see if formula can recognize the format
on C2 that u may like for whatever input in few seconds...

dribler


"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!