FORMULA TROUBLE! PLEASE HELP!

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.
 
B

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top