End Date Calculation

Hello,

I currently have a project that typically runs overnight (pm to am) and time calculations are based on an end date that is the install date + 1 day. I need to figure out a calculation for when the installation is not overnight (i.e. 8:00 pm to 11:30 pm) Below is the current formula.

=IF([Tech Name]@row > "", IF([Tech Arrival Time-Calculation]@row > 1, [Install Date]@row + 1, [Install Date]@row), "")

I have tried the following:

=IF(FIND("pm", [Tech Departure Time]@row), [Install Date]@row, [Install Date]@row + 1)

Getting an invalid Data Type

Both columns (install date and install end date) are date columns that are not restricted to dates only.

I am stumped.

Thank you in advance

Sharon Castiglia

Best Answer

Answers