From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Calculate pay based on hours and location

Calculate pay based on hours and location - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Calculate pay based on hours and location

“

- [Instructor] You and I have a business where we have to send people out to different locations. And they've complained about parking fees, and tolls, and everything else. And we've agreed to pay a stipend based on the location and help defray some of these costs when they go out to these locations. We need to figure out how much to pay each person. First of all, EE-012 worked six hours at South Glen, 33.45 per hour. So we need to multiply the hours time the rate and then add on the $55.00 for South Glen. So in column F, create the formula for that entire column to calculate each row's pay and then use a pivot table to calculate how much each person should get. Pause the video. Make the calculations. Come back and I'll show you a solution. Let's dive in and get these people paid. I'm gonna insert a column to make some room. First of all, let's just do Pay. And we're gonna multiply the rate times the hours. And I'm…

Contents