OzGrid

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

 

Requirement:

 

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:

 

 

Solution:


In E3 of Sheet1 put

Code:
=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

Code:
=IFERROR(VLOOKUP(A3,Sheet2!$B$4:$D$8,3,0)*D3,"")

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.

 


Gallery



stars (0 Reviews)