AlexBennett3
5 years agoQrew Trainee
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 (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
------------------------------
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
------------------------------