SECOND function - Microsoft Support
This article describes the formula syntax and usage of the SECOND function in Microsoft Excel. Description. Returns the seconds of a time value. The second is given as an integer in the …
Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.
IF function – nested formulas and avoiding pitfalls
Let’s look at how to properly create a complex nested IF statement using multiple IFs, and when to recognize that it’s time to use another tool in your Excel arsenal. Following is an example of …
Use AND and OR to test a combination of conditions
The first is a logical test, the second is the value you want to see if the test returns True, and the third is the value you want to see if the test returns False. In this example, the OR function and …
Calculate the difference between two times - Microsoft Support
There are several ways to calculate the difference between two times. There are two approaches that you can take to present the results in the standard time format (hours : minutes : …
Date and time functions (reference) - Microsoft Support
Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000. The second argument is the range of …
Using functions and nested functions in Excel formulas
When one function (we'll call this Function B) is used as an argument in another function (we'll call this Function A), Function B acts as a second-level function. For example, the AVERAGE …
Count how often a value occurs - Microsoft Support
Use the COUNTIF function to count how many times a particular value appears in a range of cells. The COUNTIFS function is similar to the function with one important exception: …
Add or subtract time - Microsoft Support
Let's say that you need to add two different time values together to get a total. Or, you need to subtract one time value from another to get the total time spent working on a project. As you'll …
LOOKUP function - Microsoft Support
How to use the LOOKUP function in Excel to search in a single row or column and find a value from the same position in a second row or column.