View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Add Seconds To Date

I already answered your mistaken conclusion in the post to Gary's Student,
you are wrong, it works the way it should so either you have a misconception
of time or you didn't implement them correctly


--


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.




"Peo Sjoblom" wrote:

Try

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


format it the same way as B2



--


Regards,


Peo Sjoblom


"FrankM" wrote in message
...
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!