Formula

[Steved]

Hello from Steved
Okay 1525 using the below formula will return 91500 seconds

=((TRUNC(D4)*60)+(D4-TRUNC(D4))*100)
E4/6000
91500/6000 will give me 15.25

What I require is a formula that if >72000 then minus E4
the value will return 3.25

91500-72000=19500
19500/6000 will give me 3.25

Something like this =E14/6000=IF(E4>72000,(E4-72000),E4)
give me False

Please Help

Thankyou in Advance

 

[Steved]

Got it
=IF(E14>72000,(E14-72000),E14)/6000