How to calculate hours based on individual daily rates

< Back to Search results

 Category: [Excel]  Demo Available 

How to calculate hours based on individual daily rates




The user is trying to get a formula to look at a range of names, look up a name in another range and then calculate the hours used based on the number of days x a their daily rate.


The following is a sample:




In E3 of Sheet1 put

=IF(ISNA(MATCH(A3,Names,0)),"No Match",PRODUCT(D3,INDEX(Sheet2!D:D,MATCH(Sheet1!A3,Names,0)+4)))



The following will also work:

In E3


and copy down.


Obtained from the OzGrid Help Forum.

Solution provided by crushdrinker06 and sktneer.


See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets


See also:

How to calculate overtime on Timesheet after 10 hours per day AND/OR 44 hours per week
How to drag every Nth column, with varying starting column by date
How to use a VBA code to change cells colours based on date in other cells
How to count non blanks 5 years from the last non blank date
How to use SUMPRODUCT with dates


Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.



stars (0 Reviews)