Add Seconds to Date - Time Field
 

I have an Excel spreadsheet that provides a date/time field in one column and
a seconds field in another column. How can I combine the seconds to this
Date/time field?
Example:
Column A Column B
Date/Time Seconds
8/30/2008 9:22:00 AM 44
8/30/2008 9:18:00 AM 27
8/30/2008 7:03:00 AM 23

Answer: Add Seconds to Date - Time Field
 

1. Select the cell where you want to display the combined date/time with seconds.
2. Type the formula
   Code:

   ---

   "=A1+(B1/86400)"

   ---

   (without quotes) in the formula bar, where A1 is the cell containing the date/time and B1 is the cell containing the seconds.
3. Press Enter to apply the formula to the selected cell.
4. The result will be the date/time with the seconds added.
5. To format the cell to display the date/time with seconds, right-click on the cell and select "Format Cells".
6. In the Format Cells dialog box, select "Custom" from the Category list.
7. In the Type field, enter the format code "mm/dd/yyyy hh:mm:ss" (without quotes).
8. Click OK to apply the format to the cell.
9. Repeat the above steps for all the cells where you want to add the seconds to the date/time field.

Add Seconds to Date - Time Field
 

Hi

Excel stores times as fractions of a day.
there are 86400 seconds in a day, so to add your time you would need
=A2+B2/86400
Format the cell as FormatCellsNumberCustom m/dd/yyyy hh:mm:ss
--
Regards
Roger Govier

"terminal euphoria" wrote in
message ...
I have an Excel spreadsheet that provides a date/time field in one column
and
a seconds field in another column. How can I combine the seconds to this
Date/time field?
Example:
Column A Column B
Date/Time Seconds
8/30/2008 9:22:00 AM 44
8/30/2008 9:18:00 AM 27
8/30/2008 7:03:00 AM 23

Add Seconds to Date - Time Field
 

Thanks a-lot - that did it!

"Roger Govier" wrote:

Hi

Excel stores times as fractions of a day.
there are 86400 seconds in a day, so to add your time you would need
=A2+B2/86400
Format the cell as FormatCellsNumberCustom m/dd/yyyy hh:mm:ss
--
Regards
Roger Govier

"terminal euphoria" wrote in
message ...
I have an Excel spreadsheet that provides a date/time field in one column
and
a seconds field in another column. How can I combine the seconds to this
Date/time field?
Example:
Column A Column B
Date/Time Seconds
8/30/2008 9:22:00 AM 44
8/30/2008 9:18:00 AM 27
8/30/2008 7:03:00 AM 23