Dec 19, 2016 #1 zidol Technical User Feb 9, 2016 24 US Formula: {Hours 1} - {Hours 2} = 28 hours I want it to return the total, but maximize at 24 How do I write the formula for this?
Formula: {Hours 1} - {Hours 2} = 28 hours I want it to return the total, but maximize at 24 How do I write the formula for this?
Dec 19, 2016 #2 Charliy Programmer Aug 12, 2008 601 US if {Hours 1} - {Hours 2} >24 then 24 else {Hours 1} - {Hours 2} Upvote 0 Downvote
Dec 21, 2016 Thread starter #3 zidol Technical User Feb 9, 2016 24 US Thank you for your help! Upvote 0 Downvote