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
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__You
Qrew Legend
Qrew LegendIf 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
------------------------------
------------------------------
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
------------------------------