+ Reply to Thread
Results 1 to 8 of 8

Total hours worked per day and market - formula

  1. #1
    Registered User
    Join Date
    12-12-2010
    Location
    barcelona
    MS-Off Ver
    Excel 2007
    Posts
    8

    Total hours worked per day and market - formula

    Hi there, anyone can help me with the attached formula? What should I use? VLOOKUP? MATCH? INDEX?

    Complete the Daily Calls by Market table (G41:M43) using the appropriate formula.


    Thanks!
    Attached Images Attached Images

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Total hours worked per day and market - formula

    Try a Pivot Table (Tabla Dinámica)- Fastest way

  3. #3
    Registered User
    Join Date
    12-12-2010
    Location
    barcelona
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Total hours worked per day and market - formula

    Quote Originally Posted by Pepe Le Mokko View Post
    Try a Pivot Table (Tabla Dinámica)- Fastest way
    Thanks, actually the pivot table is a good solution, but for this exercise they're asking me not to use a pivot table, but a formula.

    Do you know which formula should I use?

    Thanks!

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Total hours worked per day and market - formula

    Rule 03: Cross-posting Without Telling Us

    Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

    Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    If you have less than 10 posts, do not try to copy and paste the link. Instead, type the link out in your thread.

    No further help to be offered, please, until the OP has complied with this request.

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Total hours worked per day and market - formula

    Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

    We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

    If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.

  6. #6
    Registered User
    Join Date
    12-12-2010
    Location
    barcelona
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Total hours worked per day and market - formula

    Could you explain to me how to modify the title of the original post?

    I can't find the way to do it.

    By the way, it looks like I didn't formulate well my question: I don't want anyone to make my homework, I'm trying to solve this problem with the VLOOKUP but it doesn't work.
    If you could at least help me saying which function I should use, then I'll do my best to solve it.

    Thanks and regards.

  7. #7
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Total hours worked per day and market - formula

    Please add links to ALL cross posts as requested. Then you might get the guidance you need

  8. #8
    Forum Moderator AliGW's Avatar
    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. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,720

    Re: Total hours worked per day and market - formula

    As Pepe has said, tell us where else you have asked this same question. Do not ignore this moderation request, please.

    Here is one: https://www.excelguru.ca/forums/show...market-formula

    Are there any more?
    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula to calculate hours worked w/lunch or w/o + OT column only total after 40 hours
    By blinhart in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-31-2023, 11:14 AM
  2. [SOLVED] Total hours worked each day
    By ~TaC~ in forum Excel General
    Replies: 15
    Last Post: 02-26-2018, 01:02 PM
  3. [SOLVED] Formula to get ClockOut time if ClockIn and Total hours worked is entered
    By rizmomin in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-04-2017, 11:50 AM
  4. [SOLVED] Looking for formula help finding total hours worked in military time
    By Mic4220 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-08-2015, 02:42 PM
  5. Formula to add total hours employee worked for each day.
    By rizmomin in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 12-23-2013, 06:10 PM
  6. Replies: 1
    Last Post: 06-14-2013, 02:09 AM
  7. Replies: 6
    Last Post: 05-03-2010, 12:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1