How to Change a Date to Include Time

- 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.

Leave a Reply