Excel Forum
Similar Content
Extract the First Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
Macro: This free Excel UDF (user defined function) returns the first word from a cell in Exce...
Calculate Hours Worked - Day or Night Shift & Breaks in Excel
Tutorial: Single simple formula to calculate the hours worked for a day shift or night shift and inc...
Get Day Name from a Date in Excel
Tutorial: How to get the name of a day from a date in Excel. This returns, for example, "Tuesday" fo...

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.