need help w/ formula for taking lunch & overtime out of a 9 hour
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 !!!! |
need help w/ formula for taking lunch & overtime out of a 9 hour
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) "jodee501" wrote: 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 !!!! |
need help w/ formula for taking lunch & overtime out of a 9 hour
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) "jodee501" wrote: 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 !!!! |
All times are GMT +1. The time now is 09:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com