Forum Discussion
Help with performing a task
Hi
In the attached picture is two columns both which contain times. I need to format the second column such that if Column 2 - Column 1 is less than 3 minutes then add 3 minutes to column 2. Any suggestions?
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)
3 Replies
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)
You are welcome. Thanks for the feedback.