| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 !!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 !!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 !!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| end - start less one hour for lunch | Excel Worksheet Functions | |||
| =SUMPRODUCT((Overtime!$J$6:$GY$6-DAY(Overtime!$J$6:$GY$6)+1=A25)*(Overtime!$J$7:$GY $2 | Excel Worksheet Functions | |||
| Tracking overtime signups in 1/2 hour increments by day | Excel Discussion (Misc queries) | |||
| convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
| Overtime computation and lunch break formula with IF and AND | Excel Worksheet Functions | |||
Linear Mode
