gizmo
New member
- Joined
- Jul 18, 2021
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 16.5 IOS
Hi, Extremely new to creating my own excel sheets and am self-taught so please bear with me on this. I am trying to get the highlighted cell to show as blank if the number on the corresponding row under "shift length" is less than 5 hours.
I have the cell highlighted to show the formula I used to achieve the number under the column "lunch".
I have tried to use "conditional formatting" to create a new rule, which was:
=IF(C2>B2+TIME(5,0,0),"")
That was unsuccessful and I am at a loss. Any help is greatly appreciated, thank you!
I have the cell highlighted to show the formula I used to achieve the number under the column "lunch".
I have tried to use "conditional formatting" to create a new rule, which was:
=IF(C2>B2+TIME(5,0,0),"")
That was unsuccessful and I am at a loss. Any help is greatly appreciated, thank you!