0

Using this formula

=INT(([Approver Action Time]-[Approval Submission Time])*24)

But if Approver Action Time is empty I don't want a crazy negative value just a blank

2 Answers 2

0

Try:

=IF(
OR(ISBLANK([Approval Submission Time]), ISBLANK([Approver Action Time]), 
[Approval Submission Time]>[Approver Action Time]), 
0,INT(([Approver Action Time]-[Approval Submission Time])*24))
0

You can use an IF statement, very much like in Excel. Try

=IF([Approver Action Time]>0,INT(([Approver Action Time]-[Approval Submission Time])*24),"")
2
  • interesting I still get some fields with minus signs
    – user63270
    Commented Jun 22, 2017 at 12:26
  • I corrected the formula. I put the wrong field into the comparison. Now, you will still get negative numbers if the Approval Submission Time value is greater than the Approver Action Time. If that kind of entry should not be allowed, you need to use validation in the list.
    – teylyn
    Commented Jun 22, 2017 at 20:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.