Problem: The following Array formula was designed to calculate the average difference between each pair of values in columns A & B (providing b...
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...
Problem: Listed in column A are dates when an employee was absent. Column B contains a letter, indicating the type of each absence (V for vacation...
Problem: Each row in columns A & B represents a shift worked during the first week of the year. Column A identifies an employee, and column B ...
Problem: Columns B & C contain the times signed in and out of work for each date in column A. Column D contains the following formula, which c...
Problem: Listed in columns A & B are the times an employee signed in and out of work each day. Column C contains the rate per hour for that pa...
Problem: Column B contains a list of letters which are codes for the hours worked on each of the days listed in column A. "N" indicates a 9 hour d...
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.
