S
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
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