Start time, end time in the project plan

Omkar

Hi,

There are many situations where start date, end date and duration is not enough and one needs start time, end time as well. Does anybody know way to have

Start Time - 12/24 hrs

End time - 12/24 hrs

Duration - Days/Hours/Mins

The requirement is that end time should automatically populate the correct values by referring to the duration and predecessors.

Thanks in advance!

Ward.Hively

Hello Omkar,

I have done this in the past. The formulas can be dense but I think Mr. Paul has a lot of interesting insight in this issue.

Please see the link attached.

Good Luck!

Ward Hively,

Skyway Consulting Co.

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