FORMULA TROUBLE! PLEASE HELP!

[Ashley]

Ok, i'm trying to create a formulas to calculate overtime hours for a
timesheet. 8 hours starts overtime so I have L11(total hours)-8/24. Now if my
total hours are over 8 this works perfect but if there not I get a result of
infinate #### and yes my column is wide enough! I have no idea what to do.
I'v tried everything from IF statments to conditional formatting, I can't
seem to figure this one out. Please help me or give me some ideas as to what
to try. Thank you.

 

[JodySmithPharmD]

How about this (or a version of this);
=if(l11>8,(l11-8)/24,l11)

 

[Billy Liddel]

Time values willl not except negative values. Use something like:

=IF(L11>0.3333,L11-8/24,0)

This returns zero when hours worked are less than 8.

HTH
Peter

 

[JodySmithPharmD]

Ashley,

If you want to only display the result if the hours are greater than 8, then
use:
=if(l11>8,(l11-8)/24,"")

Jody