I would like to set up the formula based on three cells. I have data as
follows:

A B
10:34 Yes

In column C I would like to set up formula to get the differance between
column A1 and 11:00 based on the column B1. If B1 has yes then the
calculation has to happen, if B1 has No then the value in C1 should be equal
to A1. I have about 800 rows to calculate. Once I set the formula then I can
copy and paste.

Thank you in advance for your help.
Kimti