Ashley,

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

Jody

"Ashley" wrote:

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.