- Forum
- Microsoft Office Application Help - Excel Help forum
- [SOLVED] Labour Hour Calculation
+ Reply to Thread
Results 1 to 7 of 7
Tricks420
![Labour Hour Calculation [SOLVED] (4)](data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw== "Labour Hour Calculation [SOLVED] (4)")
View Profile- View Forum Posts
Registered User
- Join Date
- 12-06-2023
- Location
- Ontario
- MS-Off Ver
- 365
- Posts
- 80
Labour Hour Calculation
Hey all,
Thanks again for all your help, you have been a great assistance.
I think this is my last question and the form is done... hopefully.
I am trying to do the following:
1) First I would input the Cultivar in H2, the plug date in N1, and then finally the number of tables in P1.
2) Then I would select an event in Column K.
3) Next I would be entering the amount of people in Column Q.
4)I would like it to then calculate the amount of "Target Hours" in Column S. To do this you would need to take the amount tables in Column R multiplied by the appropriate hours in Column C.Here is the file: --NEW-- Crop Logs - Template.xlsx
Thanks in advance!
Register To Reply
AliGW
- View Profile
- View Forum Posts
Forum Moderator
- Join Date
- 08-10-2013
- Location
- Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
- MS-Off Ver
- MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
- Posts
- 82,027
Re: Labour Hour Calculation
I'll have a look. In the meantime, please see your other thread for my solution to the SPILL error issue and acknowledge it. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.AliGW
- View Profile
- View Forum Posts
Forum Moderator
- Join Date
- 08-10-2013
- Location
- Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
- MS-Off Ver
- MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
- Posts
- 82,027
Re: Labour Hour Calculation
OK - in the sample workbook, you need to fill in some examples for 1, 2 and 3. Then, for 4, please mock up manually the results you'd expect to see.
Thanks.
Register To Reply
Tricks420
- View Profile
- View Forum Posts
Registered User
- Join Date
- 12-06-2023
- Location
- Ontario
- MS-Off Ver
- 365
- Posts
- 80
Re: Labour Hour Calculation
Hi Ali,
I finally found some time today to work on this. Ok I added a bunch of examples into the sheet. The yellow cells are where I need the formulas to calculate.
1) "Target Hours" should be in Column S.
2) Basically it is the "# of Tables" in Column Q, multiplied by the appropriate "Hours" in Column C.
3) If 1st Touch is selected in Column J, it should look to C4 to calculate. The same for 2nd, 3rd, 4th, and Final Defol.Here is a copy of the file: --NEW-- Crop Logs - Template.xlsx
Thank you
Register To Reply
AliGW
- View Profile
- View Forum Posts
Forum Moderator
- Join Date
- 08-10-2013
- Location
- Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
- MS-Off Ver
- MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
- Posts
- 82,027
Re: Labour Hour Calculation
Do you mean this:
=R15*XLOOKUP(J15,$B$3:$B$9,$C$3:$C$9,0)
Register To Reply
Tricks420
- View Profile
- View Forum Posts
Registered User
- Join Date
- 12-06-2023
- Location
- Ontario
- MS-Off Ver
- 365
- Posts
- 80
Re: Labour Hour Calculation
Perfect, works great. Thank you
Register To Reply
AliGW
- View Profile
- View Forum Posts
Forum Moderator
- Join Date
- 08-10-2013
- Location
- Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
- MS-Off Ver
- MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
- Posts
- 82,027
Re: Labour Hour Calculation
Glad to have helped.
If if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
Register To Reply
![Labour Hour Calculation [SOLVED] (4)](https://i0.wp.com/www.excelforum.com/images/site_icons/profile.png "Labour Hour Calculation [SOLVED] (4)"){kind=icon}
![Labour Hour Calculation [SOLVED] (5)](https://i0.wp.com/www.excelforum.com/images/site_icons/forum.png "Labour Hour Calculation [SOLVED] (5)"){kind=icon}
![Labour Hour Calculation [SOLVED] (6)](https://i0.wp.com/www.excelforum.com/images/statusicon/user-offline.png "Labour Hour Calculation [SOLVED] (6)")
![Labour Hour Calculation [SOLVED] (7)](https://i0.wp.com/www.excelforum.com/images/reputation/reputation_pos.png "Labour Hour Calculation [SOLVED] (7)")
![Labour Hour Calculation [SOLVED] (11)](https://i0.wp.com/www.excelforum.com/images/statusicon/user-online.png "Labour Hour Calculation [SOLVED] (11)")
![Labour Hour Calculation [SOLVED] (17)](https://i0.wp.com/www.excelforum.com/images/reputation/reputation_highpos.png "Labour Hour Calculation [SOLVED] (17)")
![Labour Hour Calculation [SOLVED] (24)](https://i0.wp.com/www.excelforum.com/images/smilies/smile.gif "Labour Hour Calculation [SOLVED] (24)")
+ Reply to Thread
«Previous Thread|Next Thread»
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
[SOLVED]Help with calculation of per hour
By nr6281 in forum Excel General
Replies: 3
Last Post: 05-10-2023, 07:04 PM
[SOLVED]Time + hour calculation
By dineshsachidananda in forum Excel Programming / VBA / Macros
Replies: 2
Last Post: 10-03-2015, 04:14 AM
[SOLVED]Time + hour calculation
By dineshsachidananda in forum Excel Formulas & Functions
Replies: 6
Last Post: 09-13-2015, 08:14 AM
Hour Calculation Help!!!!!!
By MinieMe209 in forum Excel Formulas & Functions
Replies: 8
Last Post: 04-25-2014, 08:23 PM
[SOLVED]Rate Calculation - per hour
By ganeshinscribe in forum Excel Formulas & Functions
Replies: 3
Last Post: 11-14-2013, 06:20 AM
Calculation of average and the max CPU for the hour
By zahedreza.k in forum Excel Charting & Pivots
Replies: 0
Last Post: 02-01-2013, 01:12 PM
[SOLVED]calculation of pounds per hour
By george in forum Excel - New Users/Basics
Replies: 2
Last Post: 08-02-2005, 02:05 PM
Bookmarks
Bookmarks
- Digg
- del.icio.us
- StumbleUpon
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
- BB code is On
- Smilies are On
- [IMG] code is Off
- HTML code is Off
- Trackbacks are Off
- Pingbacks are Off
- Refbacks are Off
Forum Rules
- Contact Us
- ExcelForum.com
- Archive
- Top
All times are GMT -4. The time now is 06:08 AM.
![Labour Hour Calculation [SOLVED] (2024)](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAQAAAC1HAwCAAAAC0lEQVR42mP8/h8AAvMB+NzmkbcAAAAASUVORK5CYII=)