Break Entitlement

[HappyChappy]

Hope you can help

Have a time sheet cell 05 =11:15 o5 looks up cells g3+m3 which have two times in them respectively.
Cell p5 needs to look at 05 and if it is >8.75 deduct .75 from cell but if it's < 8.75 just return it's value

 

[Fluff]

How about

=O5-0.75*(O5>8.75)

or

=IF(O5>8.75,O5-0.75,O5)

 

[HappyChappy]

How about

=O5-0.75*(O5>8.75)

or

=IF(O5>8.75,O5-0.75,O5)

Tried both formula's both return same time of 11:15 checked formatting and that doesn't make any difference result should be 10:30

 

[Fluff]

Ok, how about

=IF(O5>TIME(8,45,),O5-TIME(0,45,0),O5)

 

[HappyChappy]

Ok, how about

=IF(O5>TIME(8,45,),O5-TIME(0,45,0),O5)

exel corrected formula to =IF(O5>TIME(8,45,),O5-TIME(0,45,0)) which works but if 05 is populated by 0:00 then it returns a FALSE can i get rid of the FALSE

 

[HappyChappy]

Ok, how about

=IF(O5>TIME(8,45,),O5-TIME(0,45,0),O5)

=IF(O5>TIME(8,45,),O5-TIME(0,45,0),O5) works great thankyou very much

 

[Fluff]

You're welcome & thanks for the feedback.