# Discussions

View Only

## Formula for duration. Days and hours based on 8 or 10 hr work days.

• #### 1.  Formula for duration. Days and hours based on 8 or 10 hr work days.

Posted 20 days ago
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)
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
------------------------------