LinkBack URL
About LinkBacks
Dear All,
Please help me out with the formula.
Condition employee should accept order before 45 min of Schedule date & time then it should reflect as "With in SLA" or else it should be "Beyond SLA"
Attached sheet is for your reference
Regards
Rushi
Dear All,
Please help me out with the formula.
Condition employee should accept order before 45 min of Schedule date & time then it should reflect as "With in SLA" or else it should be "Beyond SLA"
Attached sheet is for your reference
Regards
Rushi
Khalid
Hi Rush,
=IF((B3-C3)*1440<45,"With in SLA","Beyond SLA")
What if the values are in minus ?
Please help me out
Withdrawn by FR.
Last edited by FlameRetired; 12-15-2016 at 02:18 PM.
Dave
Condition employee should accept order before 45 min of Schedule date & time then it should reflect as "With in SLA" or else it should be "Beyond SLA"How can they be in minus?What if the values are in minus ?
Try thisFormula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks