canculate efficiency

A

amna77

Active Member
Joined
May 9, 2002
Messages
251
hi can someone help me with query. actually what i am trying to do is, want to calculate efficiency. for example every day operator has to work 6 hours,but in actually he might work 3 or 4 hours per day. the thing where i am stuck is, what should i put in query. i can enter date range for a day, or for a week, or for a month. can u please help me. right now i am keeping track of opertar and hours he worked per day.
Thanks in advance.
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Sort by date Sort by votes
Hi,

I'm not sure if this is what you are after, but depending on the data in your underlying table, and depending on the variable names, create a new query and add the following items to your query : operator, date & hours. To calculate "efficiency" enter the following into the 4th field in the query :

efficiency : formatpercent([hours]/6,1)

Remember to use your variable name - I used the variable name "hours".

Save and run.

Whilst I have given you what I think you have asked for, hours/6 is not "efficiency" hence my reservations about whether this is correct or not.

Let us know how you get on.

HTH, Andrew. :)
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Having a problem in the expression builder, very new to Access. It thinks I'm trying to use Automation objects?
2
Replies
15
Views
821
Micron
M
TOPSie
  • Solved
Is this as good as.........?
Replies
3
Views
296
TOPSie
TOPSie
JenniferMurphy
  • Question
How to structure a variable product rating database
Replies
5
Views
833
mdmilner
M
tjdrake
  • Solved
Multi-User Access DB Table
Replies
3
Views
1K
Micron
M
P
  • Question
Access 2019 Table of Future Dates
Replies
3
Views
847
Micron
M

Forum statistics

Threads
1,221,825
Messages
6,162,190
Members
451,752
Latest member
majbizzaki

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top