Calendar duration display
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
------------------------------
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
------------------------------
