Excel Forum

Excel Magic Trick 722: Calculate Gross Pay For Week From Time Values In Range & Hourly Wage

Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn how to calculate gross pay for week from time values in range and the hourly wage using SUMPRODUCT function. Also see what to do if you get a #VALUE! error from blanks in cell using the IF function and an array logical test.
=SUMPRODUCT(Payroll Time Values For Week * Wage * 24) Trick

Got a Question? Ask it Here in the Forum.