AlexBennett3
5 years agoQrew Trainee
Formula for duration. Days and hours based on 8 or 10 hr work days.
Hey Everyone,
I'm working in a scheduling app that takes average hourly rate by the number of employees assigned to a job, divided by estimated labor cost. I've been able to get the durations working in Days and Hours. However, I can't seem to figure out how to get the hours and days to format for an 8 hr day / 10 hr day. For example, one duration is coming out to be 21 hours, which I'd like it to say 2 Days 5 Hours since it would take 2 full 8 hour days plus 5 hours to complete that job. I'm also concerned that because of this, my durations are based on 24 hours. So 1 day duration now, in reality is 3 Days (8 hr workday) or 2 Days 4 Hours (10 hr workday). Thought I'd attempt getting some help again from this forum as I'm struggling!
What I have so far:
(10hr Workday)
(8hr Workday)
**
Any help would be appreciated!
Thanks,
------------------------------
Alex Bennett
------------------------------
I'm working in a scheduling app that takes average hourly rate by the number of employees assigned to a job, divided by estimated labor cost. I've been able to get the durations working in Days and Hours. However, I can't seem to figure out how to get the hours and days to format for an 8 hr day / 10 hr day. For example, one duration is coming out to be 21 hours, which I'd like it to say 2 Days 5 Hours since it would take 2 full 8 hour days plus 5 hours to complete that job. I'm also concerned that because of this, my durations are based on 24 hours. So 1 day duration now, in reality is 3 Days (8 hr workday) or 2 Days 4 Hours (10 hr workday). Thought I'd attempt getting some help again from this forum as I'm struggling!
What I have so far:
(10hr Workday)
Days([1. Rough Duration])/10
(8hr Workday)
Days([3. Sub Duration])/8
**
[#. Phase Duration]
is a field that takes the final calculation, I'm pulling it here to convert to Formula-Duration from Formula-Numeric **Any help would be appreciated!
Thanks,
------------------------------
Alex Bennett
------------------------------