Equation to fill in "On time" or "Late"
Hello,
I am trying to create an equation that will generate on time or late depending what the quoted delivery time is and the real delivery time is. I have been able to get thus far but I want to include a parameter so if it is 5 minutes or less late then it will say on time.
For example if a quoted time is 9:00 and the real delivery time is 9:05 or earlier it will say on time, and if the real delivery time is 9:06 or later it will say late.
Here is the current equation I have which simply generates on time or late with no additional parameters:
=IF(TIME([Scheduled Delivery Time]@row) >= TIME([Actual Delivery Time]@row), "On Time", "Late")
Best Answer
-
Hi @mccaffhm
You can use this formula
=IF(OR(TIME([Scheduled Delivery Time]@row) >= TIME([Actual Delivery Time]@row), TIME([Scheduled Delivery Time]@row) + 5 >= TIME([Actual Delivery Time]@row)), "On Time", "Late")
Or Simply
=IF(TIME([Scheduled Delivery Time]@row) + 5 >= TIME([Actual Delivery Time]@row), "On Time", "Late")
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Answers
-
Hi @mccaffhm
You can use this formula
=IF(OR(TIME([Scheduled Delivery Time]@row) >= TIME([Actual Delivery Time]@row), TIME([Scheduled Delivery Time]@row) + 5 >= TIME([Actual Delivery Time]@row)), "On Time", "Late")
Or Simply
=IF(TIME([Scheduled Delivery Time]@row) + 5 >= TIME([Actual Delivery Time]@row), "On Time", "Late")
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
That worked, thanks for the help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!