– How to Change Date Format
– How to Change a Date to Long Date Format
– How to Change a Date to Short Date Format
The date can be formatted into many different ways, and sometimes you may need to include time in the date. To include the time for a date, please see the steps below:
Step 1. Select the cells with dates;
Step 2. Right-click and select "Format Cell" in the dialog box;
Step 3. In the "Format Cells" window, click "Custom", and select "yyyy-mm-dd h:mm" from the list;
Step 4. Click OK and all dates are now with time format.
Step 5: To include second, you can change the format into "yyyy-mm-dd h:mm:ss";
Step 6: Click "OK" and the dates will include seconds.