Always having Current Date / Current Time in worksheet

If you want to always show Current Date / Current Time in you Excel worksheet, you can use below mentioned functions:- For current date & time ...

Multiplying time values and numbers.

In this article, you’ll learn how to multiply the time values and numbers in Microsoft Excel. To calculate the payment based on the worked hours &a...

Calculating the Week Number

To calculate a week number: Use the WEEKNUM function. The second argument in the WEEKNUM function, Return_type, determines on which day the week...

Problem: When using a standard SUM formula to add the time values in column B (=SUM(B2:B5)), a false result of 4:23 is returned, rather than the ac...

Combining Data from Separate Columns into a Single Date and Time Value

While working in Microsoft Excel, it is very common that we have to work on combining data from multiple columns in a worksheet in Microsoft Excel 201...

Avoiding Errors when Using the And Function to Combine Multiple Conditions in Array Formulas

Problem: The following Array formula was designed to calculate the average difference between each pair of values in columns A & B (providing b...

Calculating Hourly Productivity

Problem: Column B contains time values representing the hours worked by each salesperson in column A. Column C shows the number of items each sale...

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.