Use the MIN function to find the employee with the lowest sales
How to Use the MAX function to find the largest value in a range
This example finds the largest value in the range A3:D11 by using the MAX function. The function’s return value is the largest value in a set. Here ...
How to Use the TIME function to combine single time parts
The worksheet below shows single time parts in each column. Column B contains hours, column C contains minutes, and column D contains seconds. All thr...
How to Use the HOUR function to calculate with 100-minute hours
Some companies record working time in 100-minute hours. For example, the time 6:45 is converted to 6:75, which sometimes makes further calculations ea...
How to Use a custom format to create a time format
When you enter time values in cells, you have to type the colon between the hours and minutes. However, this is unnecessary if you use a custom format...
How to Use the TIMEVALUE function to convert text to time
In this example, a text string has to be converted to a valid time. Columns A and C contain different start and end times as part of a standardized te...
How to calculate the weeks of Advent using Excel’s Weekday Function
As a practical task using previously learned functions, the start date of each week of Advent can be calculated easily. Consider that Advent begins on...
How to Use the DATEDIF function to calculate the ages of employees
To calculate the exact age of employees, use the undocumented DATEDIF function from the Analysis ToolPak add-in. This function calculates the exact nu...
How to Use the YEARFRAC function to calculate employees ages
To calculate the difference between two dates, use the YEARFRAC function from the Analysis ToolPak add-in. This function calculates the fraction of th...
Use the NETWORKDAYS function to determine number of workdays
In this example a project has to be scheduled. Each of the five steps has a fixed start and end date. To determine the number of complete workdays bet...
Formula and Function Examples
Use the MIN function to find the employee with the lowest sales
In a company, employee sales are monitored. Columns B to E contain the sales for the first four months of the year. To determine which employee has the lowest monthly sales, use the MIN function. The function’s return value is the smallest value in a set. MIN(number1, number2, …) number1, number2, …: From 1 to 30 numbers for [...]
How to Use the MAX function to find the largest value in a range
This example finds the largest value in the range A3:D11 by using the MAX function. The function’s return value is the largest value in a set. Here is the syntax for using the MAX Function MAX(number1, number2, …) number1, number2, …: From 1 to 30 numbers for which you want to find the largest value. It is [...]
