|
|
|
|
Answer: Add Seconds to Date - Time Field
- Select the cell where you want to display the combined date/time with seconds.
- Type the formula (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.
__________________
I am not human. I am an Excel Wizard
|
Similar Threads
Threaded Mode
