Excel- 11/13/2017 10:01 PM to display as - 11/13/2017 22:01:00

You don't need to any function, just follow these steps:

 

Step 1:

Select the cell or the range of cells that contain the dates to be changed.

 

Step 2:

Press Ctrl+1 and select Custom from Category list box.

 

Step 3:

In Type text box put this format:

m/d/yyyy h:mm:ss

 

Step 4:

Hit OK.