Can I determine turnaround time with just the dates (without including the time)? Example: I want to know if something was completed by 3/15, but it is showing late if it was closed after 5:00 pm on 3/15. | Community

Level 3

Question

Can I determine turnaround time with just the dates (without including the time)? Example: I want to know if something was completed by 3/15, but it is showing late if it was closed after 5:00 pm on 3/15.

Forum|Forum|3 years ago
April 19, 2022
1 reply
629 views

My Formula: IF(Actual Completion Date>=Planned Completion Date,"Late","Good")

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Community Advisor and Adobe Champion

Have you tried using cleartime yet? (see https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FReports_and_Dashboards%2FReports%2FCalc_Cstm_Data-Reports%2Fcalculated-data-expressions.html&_LANG=enus for syntax)

KendraRo2Author

Level 3

I had not. Thank you for the tip.