A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

You can use Excel's features to calculate your sales goals by the hour ... Setting up an Excel spreadsheet to make these calculations is not difficult and can be accomplished in just a few minutes.

Type the formula to calculate the number of double time hours worked that day in cell B5. For example, suppose state law requires you to pay workers double time if they work more than 10 hours per ...