Project Plan with hour:min level predecessor

Bryan Moss

I have searched through several other posts and I have not been able to find anything related.

I have a use case for an hour-by-hour plan that will happen all within a single weekend. (Project cutover). I want to be able to update a start time and end time column based on a duration of 15m, or 1h, etc. I can use the minute or hour duration but I cannot find a way to have it update dependencies at an hour:minute level.

Example: I have task#1 that starts at 8PM and is 1hr duration to end at 9PM. I have a dependency task#2 that starts at 9PM and ends at 11PM. If I change task#1 to 9PM I would like have task#2 update to 10PM start automatically.

I suspect I could create a time formula to add time but it would be pretty tedious.

Does anyone have thoughts/ideas if you want an hour-by-hour project plan to update the time of the dependency tasks?

Paul Newcome

You are going to have to either do it manually or use a series of formulas. Below is a thread that has a lot of time based solutions. From there we would need to figure out formulas for working with predecessors/dependencies. I have a few ideas on that but have never actually put it into practice. It would require a column for each predecessor, so if you have 5 predecessors on a single row, you will need 5 additional columns to parse them out.

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time