I have a date in column A1 which is the start of a task.
In column B1 I have and option 2 phrases, stating whether the task is 'open' or 'closed', obviously there is only one of those phrases that goes into column B.
In column C I want to have the time that the task took to complete displayed in hours if the case is open in column B. If the case becomes closed in column B, then the time will stop to be whatever time that is was currently at, and for it to stop continuing the hours count.
I currently have this formula, can someone help develop this situation for me please
=IF(C139(SEARCH(Open,C139)), (NOW(B139*24), (Value if false)