|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
November 14th, 2007, 07:07 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Add Seconds To Date
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! 
|
|
#2
November 14th, 2007, 07:15 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add Seconds To Date
=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!
|
|
#3
November 14th, 2007, 07:16 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add Seconds To Date
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!
|
|
#4
November 14th, 2007, 07:16 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add Seconds To Date
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!
|
|
#5
November 14th, 2007, 08:26 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add Seconds To Date
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!
|
|
#6
November 14th, 2007, 08:33 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add Seconds To Date
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!
|
|
#7
November 14th, 2007, 08:35 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add Seconds To Date
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!
|
|
#8
November 14th, 2007, 08:38 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add Seconds To Date
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!
|
|
#9
November 14th, 2007, 08:40 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add Seconds To Date
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!
|
|
#10
November 14th, 2007, 08:42 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add Seconds To Date
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!
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
