Shajratul Alam Towhid
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 which is time based. In this article, we’ll try to discuss how to add time to date in Excel.
Download Practice Workbook
4 Handy Ways to Add Time to Date in Excel
Excel offers different easy ways to show time and date combinedly. 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 combinedly in one cell is using 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+C5Here, 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.
Read More: How to Add Date and Time in Excel (4 Easy Methods)
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.
Read More: How to Add Hours, Minutes, and Seconds in Excel
Similar Readings
- How to Add Minutes and Seconds in Excel (3 Easy Methods)
- Adding Hours and Minutes in Excel (4 Suitable Methods)
- How to Add Hours to Time in Excel (8 Quick Ways)
- Add Milliseconds to Time in Excel (with Quick Steps)
- How to Add Minutes to Time in Excel (5 Easy Ways)
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.
Read More: How to Add Time in Excel Automatically (5 Easy Ways)
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.
Read More: How to Add Time in Excel Over 24 Hours (4 ways)
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 which 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.
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 and explore our website, a one-stop Excel solution provider.
