FORMULA TROUBLE! PLEASE HELP!

  • Thread starter Thread starter Ashley
  • Start date Start date
A

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.
 
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
 
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
 
Back
Top