Forum Discussion
Help with performing a task
based on what you described it is not possible to use column 2 as reference and also make changes to it, it will create a circular reference error.
if you want to put the result in third column then you can do that with
so lets say your column 2 value is in B2 and Column 1 is in A2 and you put this formula in C2
=IF(B2-A2<TIME(0,3,0),B2+TIME(0,3,0),B2)
based on what you described it is not possible to use column 2 as reference and also make changes to it, it will create a circular reference error.
if you want to put the result in third column then you can do that with
so lets say your column 2 value is in B2 and Column 1 is in A2 and you put this formula in C2
=IF(B2-A2<TIME(0,3,0),B2+TIME(0,3,0),B2)
Thank You. I will do that and then just paste values over.
You are welcome. Thanks for the feedback.