spittingfire
New Member
- Joined
- Aug 27, 2014
- Messages
- 16
Hi All,
I am not sure if what I want to achieve is possible or not but I won't know unless I ask
I have data in cells A5:J5
Cells G5 has a start time and H5 has the stop time.
What I want to do is in N5 is write a formula that if H5 is less than G5 then clear the contents of A5:J5. If it is not then leave as is (do nothing).
If no such formula exists is there a way to do it via VB?
Thanks in advance for all your help.
I am not sure if what I want to achieve is possible or not but I won't know unless I ask
I have data in cells A5:J5
Cells G5 has a start time and H5 has the stop time.
What I want to do is in N5 is write a formula that if H5 is less than G5 then clear the contents of A5:J5. If it is not then leave as is (do nothing).
If no such formula exists is there a way to do it via VB?
Thanks in advance for all your help.