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 11-09-2020 10:41
    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
    ------------------------------