I need a formula that will satisfy this logic statement: If D2 = 1, subtract B3 from B2 and multiply the results by 1440. If D2 does not = 1, enter XXX. The answer goes in E2.
<tbody>
</tbody>
A | B | C | D | E | |
1 | DATE | TIME | GUARD | BUILDING | TIME |
2 | 07/02/18 | 6:28:00 | 321 | 1 | |
3 | 07/02/18 | 7:35:00 | 333 |
<tbody>
</tbody>