Excel Forum
Similar Content
Get the Day of Week 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...
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...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.