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

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),"")
  • interesting I still get some fields with minus signs – pinkstonmatt Jun 22 '17 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 Jun 22 '17 at 20:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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