How to Add Time to Date in Excel (4 Useful Methods)

If you are looking for how to add time to date in Excel, then you are in the right place. In Excel, while working with time and date we often need to get an integrated output where time and date will be shown simultaneously in one cell. This actually gives an exact timing of certain works or projects or anything that is time-based. In this article, we’ll try to discuss how to add time to date in Excel.

Add Time to Date in Excel: 4 Handy Ways

Excel offers different easy ways to show time and date combined. Suppose, we have the following dataset named Adding Time to Date. It has column headers as Date and Time.

We’ll now see different ways to add time to date.

1. Using Arithmetic Formula to Add Time to Date

The easiest way to show time and date combined in one cell is using an Arithmetic Formula. Suppose, we have the following dataset and we need to add time and date in the D Column having a column header as Date & Time.

Steps:

Firstly, write the following formula in the D5 cell like this.

=B5+C5

Here, B5 and C5 refer to the first Date and Time respectively which are 2/5/2021 and 9:40:00 AM.

Secondly, press ENTER to get the output.
Thirdly, use the Fill Handle by dragging down the cursor while holding the right-bottom corner of the D5 cell like this.

Eventually, we’ll get all the outputs like this.

2. Utilizing CONCAT and TEXT Functions

We can use the combination of TEXT and CONCAT functions to add time and date combinedly. We need to add the time and date in D Column in the following dataset.

Firstly, write the following formula in the D5

=CONCAT(TEXT(B5;"dd-mm-yyy");" ";TEXT(C5;"hh:mm:ss"))

Here, dd, mm, yy, and ss refer to days, months, years, and seconds.

Secondly, press ENTER and use the Fill Handle to get all the outputs like this.

3. Using NOW Function to Add Time to Date

We can use the NOW function to show the current time and date. The time and date will change automatically according to the flow of time.

We need to add the current time and date in the C4 cell.

Just write the following formula in the C5 cell like this.

=NOW()

Eventually, press ENTER to get the current date and time in one cell as output.

4. Applying Keyboard Shortcut

We can get the date and time by using two different keyboard shortcuts. Suppose we need to add time and date in the C5 by using Keyboard Shortcut.

Firstly, press CTRL + ; and we’ll get the date.

Secondly, after getting the date press Spacebar and then press CTRL + SHIFT + ;
Eventually, after this, we’ll get the time too.

How to Insert Today’s Date in Excel

In Excel, we can easily find today’s date. We need to use the TODAY function to do this.
Here, we want to get today’s date in the C4 cell.

Firstly, write the formula in the C5

=TODAY()

Similarly, as before, press ENTER to get today’s date.

Add or Subtract Days to/from Today’s Date

We can also add or subtract days to/from today’s date by simply using the TODAY function with the number of days we need to add or subtract.
Suppose, in the C5 and D5 cell we want to get 7 Days Later from Today’s Date and 7 Days Earlier from Today’s Date respectively.

Steps:

Firstly, we have found today’s date in the B5 cell by using the TODAY
Secondly, write the following formula in the C5 cell to find 7 Days Later from Today’s Date like this.

=TODAY()+7

Secondly, press ENTER to get the output.

Now, write the following formula in the D5 cell to get 7 Days Earlier from Today’s Date.

=TODAY()-7

Lastly, press ENTER and get the output.

Things to Remember

The NOW function and TODAY function give outputs that change according to the change of time.
While finding Add/Subtract Days to/from Today’s Date, we can add or subtract any number to/from the TODAY function according to our requirements.

Download Practice Workbook

Adding Time to Date.xlsx

Conclusion

That’s all about today’s session. And these are the ways to add time to date in Excel. We strongly believe this article would be highly beneficial for you. Don’t forget to share your thoughts and queries in the comments section.

<< Go Back to Add Time in Excel | Calculate Time | Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!