My project day is set to 16 hours. Dependencies are enabled. I have Planned Start Date and Planned Finish Date populated mostly by dependencies. I am attempting to have the Planned Start Time and Planned Finish Time populated. Using this formula for start time
=IFERROR(TIME([Planned Start Date]@row), "") the start and finish times are not calculating correctly, example, The start date and end date are 12/27/26. The duration is 3h. The start and end times calculated are 3:00pm to 2:00am.
Has anyone calculated this time of information?
SmartSheet support gave me these two formulas, but it comes back with a syntax error, and then SmartSheet supports says the formulas they gave me are not supported:
For Start Time (in "HH:MM" format):
=TEXT(HOUR([Planned Start Date]@row), "00") + ":" + TEXT(MINUTE([Planned Start Date]@row), "00")
For Finish Time (in "HH:MM" format):
=TEXT(HOUR([Planned Finish Date]@row), "00") + ":" + TEXT(MINUTE([Planned Finish Date]@row), "00")