If Formula please

[Steved]

Hello from Steved
48:36 40:00 08:36 8:00 0:36
32:10 40:00 ##### ##### 0:00

The above requires an If in cell c2 to look like below
A2 B2 C2 D2 E2
32:10 40:00 0:00 0:00 0:00

hence if cell A2 is above 40:00 it calculates

Thanks

 

[Peo Sjoblom]

No need for IF

=MAX(0,A2-B2)

 

[Steved]

Cheers Peo

-----Original Message-----
No need for IF

=MAX(0,A2-B2)

--

Regards,

Peo Sjoblom




.