Microsoft Office Tutorials and References
In Depth Information
Finding the Time NOW
Isolating the second
Isolating the second from a date value is useful in situations where highly
accurate time calculations are needed. In practice, this isn’t a common
requirement in Excel applications.
Follow these steps to use the SECOND function:
1. Position the pointer in the cell where you want the results displayed.
2. Enter =SECOND( to begin the function entry.
3. Click the cell that has the time value, or enter a time value.
4. Enter a closing parenthesis to end the function and press Enter.
Finding the Time NOW
Sometimes when working in Excel you may need to access the current time.
For example, you may be working on a client project and need to know how
much time you’ve spent on it. Use the NOW function when you first open the
workbook, and use it again when finished. Subtracting one value from the
other provides the elapsed time.
Here’s how to use the NOW function:
1. Select the cell where you want the result.
2. Type in =NOW() .
3. Press Enter to end the function.
You must take one additional step to make the preceding NOW time
calculation work. When you get the current time at the start, copy the value and then
use Paste Special to paste it back as a value. This strategy prevents it from
updating constantly to the current time. You can also do this by selecting the
cell, clicking in the Formula Bar, and then pressing F9.
NOW provides not just the current time but also the current date. This is
similar to the TODAY function. TODAY returns the current date — without
the current time. NOW returns the full current date and time. See Chapter 12
for more information on the TODAY function.
Search JabSto ::




Custom Search