+ Reply to Thread
Results 1 to 4 of 4

Timesheet formula - Per Diem calculation based on data in other cells

  1. #1
    Registered User
    Join Date
    04-29-2022
    Location
    WV, USA
    MS-Off Ver
    365
    Posts
    2

    Timesheet formula - Per Diem calculation based on data in other cells

    Good afternoon, is it possible to create a formula that will automatically fill in in the following scenario:
    My timesheet is Monday thru Sunday. I input their hours (formula calculates hours). I have to manually enter their days (total) of Per Diem, (any day worked that is more than 0 hours they get 1 full day of per diem (up to 7days)), is there a way to have that column automatically fill in according to the data in the Monday thru Friday cells for that individual? According to what cells have anything over 0 in them to calculate 1-7 in the per diem cell? I want to do this to eliminate the possibility human error of my eyes missing a day on the sheet. Thank you in advance for any assistance :-)
    Attached Images Attached Images

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: Timesheet formula - Per Diem calculation based on data in other cells

    Welcome to the Forum MDoyle7227!

    In the future please attach a file. Screenshots are of limited value. See yellow banner at the top of the page.

    Assuming you are showing data starting column A then your formula for per diem days for row 4 would look like this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    04-29-2022
    Location
    WV, USA
    MS-Off Ver
    365
    Posts
    2

    Talking Re: Timesheet formula - Per Diem calculation based on data in other cells

    Thank you 6StringJazzer. I will make sure to attach a file next time. I'm new so wasn't sure the best way. Thank you for the formula.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: Timesheet formula - Per Diem calculation based on data in other cells

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

    If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.

+ 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] Calculation in nested formula based on data entry from table
    By sakhtar100 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-07-2022, 11:23 AM
  2. timesheet - reference formula based on cell used
    By newtimesheethelp in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-17-2021, 11:25 PM
  3. Formula to Count Hours In Different Bracket - Timesheet Calculation
    By peteholland2 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-05-2020, 11:37 AM
  4. Need Help - Travelling Per Diem Calculation
    By asice in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-02-2018, 05:52 AM
  5. Per Diem Calculation
    By Neilesh Kumar in forum Excel General
    Replies: 1
    Last Post: 09-30-2016, 03:30 PM
  6. Replies: 9
    Last Post: 11-05-2014, 08:17 AM

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