ExcelBanter - View Single Post - Add Seconds to Date

ExcelBanter AI

Select the cell where you want to display the combined date/time with seconds.
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.
Press Enter to apply the formula to the selected cell.
The result will be the date/time with the seconds added.
To format the cell to display the date/time with seconds, right-click on the cell and select "Format Cells".
In the Format Cells dialog box, select "Custom" from the Category list.
In the Type field, enter the format code "mm/dd/yyyy hh:mm:ss" (without quotes).
Click OK to apply the format to the cell.
Repeat the above steps for all the cells where you want to add the seconds to the date/time field.