Discussions

Expand all | Collapse all

Calendar duration display

  • 1.  Calendar duration display

    Posted 10 days ago
    Hey Everyone,

    Just wanted to see if anyone knows of a workaround to get accurate display of days? I know you can't remove days from the duration, I've set my duration to be accurate for specific departments based on 8 hour work days, so thats fine. But how can I go about doing the same thing for only 4 work days a week? (4 - 10s). My process for both 5 - 8's and 4 - 10's are to run previous formulas to get overall duration in hours, then I divide that number by 8 or 10 to get # of days estimated for that duration. I've figured out how to get days to display correctly for 8 hour days, but my 10 hour day durations are including Fridays, so I can't seem to figure out a workaround so It at least ends on the accurate day. Maybe an if statement to add a day if over 4 days? But then i'd have to ad something to include for each friday the duration goes over right?

    Thanks,​

    ------------------------------
    Alex Bennett
    ------------------------------


  • 2.  RE: Calendar duration display

    Posted 10 days ago
    Any Formula advice on this?

    ------------------------------
    Alex Bennett
    ------------------------------