Need help with formula

New Contributor

I'm sure this will be a simple one for most, but since I'm no expert with Excel I'm reaching out. I need to calculate hours for overtime once a condition has been met. The condition is 40.


If cell data is greater than 40, display value


Cell data = 42

Output would = 2


After this, I have a more difficult one I'll need help with as well. 

Thanks all !

1 Reply
if A1 = 42 and output cell is in B1 , formula in B1 = if(A1>40,A1-40,"")
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies