On a worksheet, select the cell into which you want to insert the current date or time. Do one of the following: To insert the date, type the date, for example 2/2, and then select Home > Number Format dropdown >Short Date or Long Date. To insert the time, type the time, and then select Home > Number Format dropdown (in the Number tab) >Time.

Let's say that you need to add two different time values together to get a total, or you need to subtract one time value from another to get the total time spent working on a project. As you'll see in the sections below, Excel makes it easy to add or subtract time.

The best way to add time is to use the AutoSum button on the HOME tab. You can also add a unit of time, such as 1½ hours, to a time of day, such as 10:00 a.m., by using the TIME function. Add time. Suppose that you want to know how many hours and minutes it …

To insert a single column: Right-click the whole column to the right of where you want to add the new column, and then select Insert Columns. To insert multiple columns: Select the same number of columns to the right of where you want to add new ones. Right-click the selection, and then select Insert Columns. Delete cells, rows, or columns

Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.

The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.

To add the current date at the time of printing to the bottom of every printed page, simply insert the date in the worksheet footer. Similarly, you can also add the date to the top of every printed page.

From the Header & Footer Ribbon menu, click Insert Date or Insert Time. You can also insert the Page Number , Number of Pages , File Path , File Name and Sheet Name . If you want, do one or more of the following:

Apply the Time format with the hour and minute, and AM or PM. Ctrl+Shift+At sign (@) Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

Add or change headers and footers in Excel. Add the date, time, page numbers, filename or any other text.