meal allowance
Results 1 to 6 of 6

Thread: meal allowance
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular Manolocs's Avatar
    Join Date
    Mar 2008
    Location
    All around the world
    Posts
    339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy meal allowance

    Hi, Little bit workload but I need to figure out a calculation for this meal allowances with formulas:
    A truck company pays their drivers a meal allowance but only when they are not driving and out of the base, the allowances are:
    1- Breakfast 20USD from 7:30 to 9:30
    2- Lunch = 40 USD from 12:30 to 14:30
    3- Dinner = 50 USD from 19:30 to 21:30
    For example, the truck start the journey 5:00 on the 2nd August, arrived in the first layover at 19:30 on the same day the driver is entitled to Dinner only, on the 3rd AUG the driver stay all day in this city resting so the driver is entitled to breakfast, lunch, and dinner, on the 4th AUG the journey starts at 04:00. The journey last until 14:35 only Dinner will be paid because the driver arrived 14:35 and miss by 5 minutes the lunch allowance.
    The company only pays the meals if the drivers are out of the home base and not are driving at the time.

    Any help is more than welcome.

  2. #2
    Board Regular
    Join Date
    Nov 2013
    Location
    Denver, Colorado - XFD1048576 - MORE Stuff here near the end. And what if you add even more stuff a
    Posts
    615
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: meal allowance

    A1 B C D E F G H I J K L M N
    2 Date Away Driving at
    Breakfast
    Driving at
    Lunch
    Driving at
    Dinner
    Breakfast Lunch Dinner Total Driving
    Start
    Driving
    Stop
    3 8/1/17 x 20 40 50 110 None None
    4 8/2/17 x x x 20 20 5:00 7:00
    5 8/3/17 x x x x 0 5:00 20:00
    Happy Excelling ,

    goesr

    To enter code in your post use the format below. Click the link for more detail.
    [CODE] ... Your Code Here ... [/CODE]

  3. #3
    Board Regular
    Join Date
    Nov 2013
    Location
    Denver, Colorado - XFD1048576 - MORE Stuff here near the end. And what if you add even more stuff a
    Posts
    615
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: meal allowance

    Hello Manolocs - I hope this will help you get started.

    The equation I used in H3 is: =IF(AND($C3="x",D3<>"x"),20,"")
    Happy Excelling ,

    goesr

    To enter code in your post use the format below. Click the link for more detail.
    [CODE] ... Your Code Here ... [/CODE]

  4. #4
    Board Regular
    Join Date
    Nov 2013
    Location
    Denver, Colorado - XFD1048576 - MORE Stuff here near the end. And what if you add even more stuff a
    Posts
    615
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: meal allowance

    The equation in I3 is: =IF(AND($C3="x",E3<>"x"),40,"")
    The equation in J3 is: =IF(AND($C3="x",F3<>"x"),50,"")

    Let me know if you do not understand what I'm trying to do here.
    Happy Excelling ,

    goesr

    To enter code in your post use the format below. Click the link for more detail.
    [CODE] ... Your Code Here ... [/CODE]

  5. #5
    Board Regular
    Join Date
    Nov 2013
    Location
    Denver, Colorado - XFD1048576 - MORE Stuff here near the end. And what if you add even more stuff a
    Posts
    615
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: meal allowance

    The driver would then have to fill in an x in columns C, D, E, and F as appropriate. If they are away - put an x in column c, if driving at breakfast, put an x in column d and so forth.
    Happy Excelling ,

    goesr

    To enter code in your post use the format below. Click the link for more detail.
    [CODE] ... Your Code Here ... [/CODE]

  6. #6
    Board Regular Manolocs's Avatar
    Join Date
    Mar 2008
    Location
    All around the world
    Posts
    339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: meal allowance

    Hi goesr, Thanks for your time but the idea is to get this "x" from the times the driver is working and not to make it all manually. there is a Start time and End time and then the spreadsheet should calculate.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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