Duration Formula/Logic
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​ (Numer...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendMy 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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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
------------------------------
------------------------------
Alex Bennett
------------------------------
- MarkShnier__YouIf 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
------------------------------- 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
------------------------------- That's kind of where I'm struggling as well to display based on those workday hours.
------------------------------
Alex Bennett
------------------------------