You are absolutely correct. I am very sorry. When I did the conversion to
check my work I only had it set to days as I didn't think it went into months
but you are absolutely correct. Thank you so much for all your assistance.


"Peo Sjoblom" wrote:

That is correct, 17545037 is 17 million 545 thousand and 37 seconds, that is
the equivalent of
4873 hours, 37 minutes and 17 seconds 4873 hours is the equivalent of 203
days and 203 days added to March 11th 2004 is 9/30/2004. Don't know what you
expected


--


Regards,


Peo Sjoblom


"FrankM" wrote in message
...
Unfortunately that didn't seem to work. when B2 is 3/11/2004 1:20:06 PM
and
C2 is 17545037 then the response is 9/30/2004 2:57:23 PM.



"Gary''s Student" wrote:

=B2+C2/(24*60*60)

Just adding 58 adds 58 DAYS
--
Gary''s Student - gsnu200755


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