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

 

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

Use the NOW function to show the current time using Microsoft Excel

The previous tip described how to get the current date. Now we want to determine the current time in microsoft excel. The NOW function in Microsoft Excel returns the serial number of the current date and time. Microsoft Excel stores dates as sequential numbers so they can be used in calculations. By default, January 1, 1900, is number 1, and January 1, 2006, is number 38718 because it is 38,717 days after January 1, 1900. Numbers to the right of the decimal point in the number represent the time; numbers to the left represent the date. For example, the serial number .5 represents the time 12:00 noon. The NOW() function is not updated continuously.

To show the current time:

1. In cell A1 type the formula =NOW() and press <-Enter->. 
2. Ensure that cell A1 is selected and choose Cells from the Format menu.
3. In the Number tab, select Date under Category.
4. Select the format 3/14/01 1:30 PM. 
5. Press <-Enter->

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