TrixwithBrixnSticks
New Member
- Joined
- Apr 4, 2012
- Messages
- 1
Hello!
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
I'm no Excel expert, but I'm trying to create a Gantt chart based on an 8 hour day and measuring task duration in hours. Weekends and holidays are marked in grey and listed in a column elsewhere. In the image I've used =WORKDAY(startdate,taskduration/8,holidays)+MOD(taskduration/8,1)+MOD(startdate,1) - this works fine as long as a decimal day (hours) doesn't push the bar into a weekend or holiday. Ideally, I'd like to have a function that works exactly just like the WORKDAY function, but with hours or decimal days and skipping holidays and weekends. Individual tasks should then start back to end, on the hour, as the previous task ends. It's ok if the bar just shows that an item, or a part thereof, will be done on the date as indicated and doesn't have to bar-accurate as in other Gantt software. After many searches on the net, I couldn't find a solution that would work for exactly this situation. Hope this makes sense and any help with this will be much appreciated!
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>I'm no Excel expert, but I'm trying to create a Gantt chart based on an 8 hour day and measuring task duration in hours. Weekends and holidays are marked in grey and listed in a column elsewhere. In the image I've used =WORKDAY(startdate,taskduration/8,holidays)+MOD(taskduration/8,1)+MOD(startdate,1) - this works fine as long as a decimal day (hours) doesn't push the bar into a weekend or holiday. Ideally, I'd like to have a function that works exactly just like the WORKDAY function, but with hours or decimal days and skipping holidays and weekends. Individual tasks should then start back to end, on the hour, as the previous task ends. It's ok if the bar just shows that an item, or a part thereof, will be done on the date as indicated and doesn't have to bar-accurate as in other Gantt software. After many searches on the net, I couldn't find a solution that would work for exactly this situation. Hope this makes sense and any help with this will be much appreciated!
