USE THE NOW FUNCTION TO CALCULATE THE 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->.

USE THE NOW FUNCTION TO CALCULATE THE TIME USING MICROSOFT EXCEL