| Home |
| Search |
| Today's Posts |
|
#1
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert date/time to seconds | Excel Worksheet Functions | |||
| Converting Julian Seconds with a macro to replace old seconds data | Excel Discussion (Misc queries) | |||
| Need help: convert seconds to date and time | Excel Discussion (Misc queries) | |||
| Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
| How do i convert a number of seconds to a date/time? | Excel Worksheet Functions | |||
Threaded Mode
