Use the NOW function to calculate time - Date and Time Functions - Microsoft Excel Tutorials

Use the NOW function to calculate time using Microsoft Excel

To calculate with time using Now() Function in Microsoft Excel, it is helpful to know that Excel stores the time as a decimal value. For example, 0.5 is 12:00 noon, 0.75 is 18:00, and so on. 

To calculate with time:

1. In cell B1 type the formula =NOW().
2. In cell B2 type the formula =B1+0.25 to add six hours to the current time in cell B1.
3. Type the following formula in cell C1: ="The meeting starts at " & TEXT(B1,"hh:mm") & " and ends at " & TEXT(B2,"hh:mm").
4. Press <-Enter->.

Watch the Video Tutorial - https://www.youtube.com/watch?v=1OFW_tY7rCs