Help needed calculating Finish Time (and date) based on Start Time and Duration

JodiT

In the sheet shown below, there is a column formula in the Planned Start Time of =RIGHT([Start Date] @row, 8) which cascades the Planned Start Time and dates based on the duration of the task. What I would like to be able to do is to add something that would also automatically calculate the Planned Finish Time (and date) based on the Planned Start Time and Duration. We currently use 12 hour increments with AM and PM. This is over a weekend, so no business hours or breaks. Duration is listed in minutes (m) or hours (h). I can convert that to a decimal of hours if needed. The Actual Start Time and Actual Finish Time are manually entered and shouldn't affect the Planned columns.

While I am not adverse to helper columns, if absolutely needed, I also don't want to make this more complicated than need be. Thanks in advance!

Paul Newcome

Note on helper columns: When used properly, they actually make things less complicated because you are able to break out certain data points that would otherwise require much more complex formulas for calculations.

Here is a thread that has a lot of time based solutions. You should be able to find what you need here:

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

JodiT

I've actually been through that thread, but I'm having trouble extracting what I need from it. There is a LOT of info there, and I have tried several of the formulas to no avail. That said, I'll be at Engage. Would it make more sense to look at this with you there?

Paul Newcome

I just noticed that you are using the dependencies. Does the RIGHT function not work to pull an end time from the End Date column?

JodiT

I tried the RIGHT function, but I must not have written it correctly. It kept saying UNPARSEABLE.

Paul Newcome

If you are using what you have in your original post, try removing the space between [Start Date] and @row.

You have

[Start Date] @row

You should have

[Start Date]@row