Forum Discussion

SeanC1970's avatar
SeanC1970
Copper Contributor
Nov 20, 2018

Need help with formula

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 !

Resources