Discussions

Expand all | Collapse all

Duration Formula/Logic

  • 1.  Duration Formula/Logic

    Posted 21 days ago
    Hey Everyone!

    I am trying to get some formulas working to display accurate duration based on a couple fields: Job Labor Budget cost (Currency), Average Hourly Rate(Currency), # of employees​ (Numeric). I'm using these to calculate how many estimated days it would take to complete a job, either by an 8 hour work day, or 10 hr work day. (I'll do these separately since only one department works 10's) I've written out the formulas and seems to be working. But when I change Number of employees it might display 23.9 Hours, when I'm attempting to divide that total by 10. so instead of 23.9 hours, it should display 2.4 Days, or roughly 3 days for 8 hour shifts. But if it is under an 8 or 10 hour day, it then changes to 9.3 hours, or 5.2 hours etc.

    Here is my Logic:
    Hourly Rate * Number of Employees = FID 1
    FID 1 / Job Labor Budget cost = FID 2

    Days([FID 2])​​/10

    Any help would be appreciated! Never worked with durations before so this is all new! I'm Ultimately trying to get these durations to show up on a calendar to display a job duration based on a start date an number for duration.

    Thanks,

    ------------------------------
    Alex Bennett
    ------------------------------


  • 2.  RE: Duration Formula/Logic

    Posted 21 days ago
    My suggestion is to do the calculation so it results in a numeric value of the Number of hours.  I think that for your purposes, using a duration field will just be confusing.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Duration Formula/Logic

    Posted 21 days ago
    So you're saying using only numeric so that it displays like XX.X hours even if it's multiple days? Is that my best option for getting this to accurately display on a calendar based on 8/10 hour work days?

    ------------------------------
    Alex Bennett
    ------------------------------



  • 4.  RE: Duration Formula/Logic

    Posted 21 days ago
    If you want to display on a calendar, the you will need to have a formula which calculates the end date / time.  The difficulty will be in making that formula, regardless of the field type.  The issue will come up that you want to calculate "business hours per day and then probably avoid weekends.  The formulas get pretty involved.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Duration Formula/Logic

    Posted 21 days ago
    how would I go about this if I just want it to display either hours or days based on 8 hour / 10 hour work days?

    ------------------------------
    Alex Bennett
    ------------------------------



  • 6.  RE: Duration Formula/Logic

    Posted 21 days ago
    That's kind of where I'm struggling as well to display based on those workday hours.

    ------------------------------
    Alex Bennett
    ------------------------------