need help w/ formula for taking lunch & overtime out of a 9 hour

G

Guest

I have a timesheet that calculates the time then takes out lunch & if over 8
hours put overtime in a column, but if the time is less than 8 it shows
negative ot instead of -0-. help !!!!
 
G

Guest

Try this not sure if this is what your needing
The -0.5 at the end is for lunch

=IF(A1<=8,A1-A1,A1-8-0.5)
 
G

Guest

Sorry
This sould do better
what i did was change the 8 to 8.5
=IF(A1<=8.5,A1-A1,A1-8.5-0.5)
 

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

Similar Threads

Timesheet Overtime Calulations - Excel 2002 5
Overtime Calculation 2
Overtime for 8 hour and 40 hour 1
FORMULA TROUBLE! PLEASE HELP! 3
Need help with reg hrs and overtime totals please 3
Need Formula to Calculate Time/Overtime 2
formula for hours on time sheet 4
Need help with a timesheet formula 1

Top