+ Reply to Thread
Results 1 to 10 of 10

determine meal and break times by arrival times

  1. #1
    Registered User
    Join Date
    02-23-2021
    Location
    GA USA
    MS-Off Ver
    current
    Posts
    3

    Angry determine meal and break times by arrival times

    Hello everyone - I am attempting to build a worksheet in EXCEL of arrival times of individuals. And based on their daily arrival times determines if they get a Breakfast, and/or Lunch, and/or PM Snack. I know that their arrival times will have to be formatted as "time". But I cannot yet figure out what equation to enter to determine if that specific meal component is counted or not.

    Any help will be appreciated.
    Last edited by FlameRetired; 02-23-2021 at 12:46 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,056

    Re: time calculations

    From what you have written above, we have no idea what times would correspond to those meals - if someone arrived at 9:30am, would that qualify for breakfast?

    Please give further details, and it would help if you attach a sample Excel workbook which shows what data you have and what you would want to do with it. See the yellow banner at the top of the screen for details of how to do this.

    Pete
    Last edited by FlameRetired; 02-23-2021 at 12:45 PM.

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,937

    Re: determine meal and break times by arrival times

    Hello Bubbaface. Welcome to the forum.

    Please read our forum rules. Their aren't many of them. One eAdministrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. Since you are new to the forum I will change it for you this time.)

    Also:
    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Last edited by FlameRetired; 02-23-2021 at 11:42 AM. Reason: Title change by Mod
    Dave

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    6,548

    Re: time calculations

    Ignore - until thread title changed
    composed as moderator replied

    would you load up a sample spreadsheet, as yellow banner, then we can see the layout
    you would have some threshold times to decide on that

    so latest time for breakfast
    so latest time for lunch
    so latest time for PM Snack

    I'm assuming if arrived for breakfast , then all 3 apply
    I'm assuming if arrived for lunch , then only 2 apply
    I'm assuming if arrived for PM , then only 1 apply
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  5. #5
    Registered User
    Join Date
    02-23-2021
    Location
    GA USA
    MS-Off Ver
    current
    Posts
    3

    Re: time calculations

    thanks for the quick working on this to help me out - appreciate it!
    Below is the graph I am working with it shows the different classrooms dates and times of each meal in order to be counted. I hope I posted it correctly.
    Attached Files Attached Files

  6. #6
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,056

    Re: time calculations

    I presume you want a formula for the totals. Put this in cell W4:

    =SUMIFS($B4:$V4,$B$3:$V$3,W$3)

    then copy across and down as required.

    This does not tie in with what I thought you wanted from your first post, but there is nothing in your file about arrival times for each individual.

    Hope this helps.

    Pete

  7. #7
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    6,548

    Re: time calculations

    EDIT , already replied, while composing
    i have used a SUMIF() using the title headers
    =SUMIF($B$3:$V$3,W$3,$B4:$V4)
    see updated sheet attached
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    02-23-2021
    Location
    GA USA
    MS-Off Ver
    current
    Posts
    3

    Re: time calculations

    everyone - I do not understand the level of these equations at all - I am the student you all are the teachers and I am learning - thank you

  9. #9
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,056

    Re: time calculations

    Does that take care of your original question? If so, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

    Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

  10. #10
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    6,548

    Re: determine meal and break times by arrival times

    did they do the JOB

    SumIF - looks at a criteria and matches that value

    so
    =SUMIF(criteria Range,criteria, range to SUM)

    So in this example
    =SUMIF($B$3:$V$3,W$3,$B4:$V4)

    $B$3:$V$3
    is where you have Break, Lunch etc
    W$3
    has the word "Break"

    so now the SUMIF
    will look along the row for break

    This is the range is sums up
    $B4:$V4
    SO where there is the word break, the formula looks down to see if there is a value and adds them all up

    hope that helps

+ 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. Replies: 2
    Last Post: 11-05-2020, 04:12 AM
  2. [SOLVED] Time sheet calculations (hours, minutes, summary by payroll time type)
    By robinc1969 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-09-2018, 05:31 AM
  3. Replies: 4
    Last Post: 02-14-2018, 03:52 PM
  4. [SOLVED] Extract a time from a cell with date and time stamp and then perform calculations
    By Marcos Aristotelous in forum Excel General
    Replies: 3
    Last Post: 10-31-2012, 04:36 AM
  5. date time calculations - elapsed time
    By jo3llen in forum Excel General
    Replies: 3
    Last Post: 07-11-2011, 01:43 PM
  6. Time Calculations:On-Time Performance
    By rmcquar in forum Excel General
    Replies: 1
    Last Post: 10-07-2010, 06:42 PM
  7. [SOLVED] convert time imported as text to time format for calculations
    By batfish in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-27-2005, 07:05 PM

Tags for this Thread

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