Determining which Quarter a Specified Date Corresponds To in Excel 2010

In this article, we will learn how to determine in which quarter a specified date corresponds. While working on reports, you have some dates & ...

Avoiding Negative Values when Calculating the Number of Days between Two Dates in Microsoft Excel 2010

In this article you’ll learn, how to avoid negative values while calculating the number of days between two dates. We’ll use MIN, MAX and DATE fun...

Converting Text Representing Minutes and Seconds into Numerical Values in Microsoft Excel 2010

To convert the text representing minutes and seconds into numerical values, we use “LEFT”, “FIND”, “LEN” and “MID” functions in Micros...

Calculating a Required Date According to Two Criteria in Microsoft Excel

To calculate required date according to two criteria, we will use MIN function along with IF function in Microsoft Excel. MIN function search fo...

Entering Times Quickly in Microsoft Excel 2010

To enter the times quickly, we use the Timevalue, If, Left, and Right functions in Microsoft Excel 2010. IF: - Check whether a condition is met and...

Adding Text Values Representing Time in Microsoft Excel 2010

To add text values representing time, we use the Sum function along with Time value function in Microsoft Excel 2010. SUM:- Sum function is used fo...

Multiplying Matrices in Microsoft Excel

To calculate the payment based on the worked hours & rate, we have to multiply each time value by its matching numerical rate. Let us take an exa...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.