Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
total ABS(L42)+12-ABS(L41)
l42=1:30AM ,l41=5:00pm lunch==IF(AND(HOUR(K43)<6,HOUR(K43)<18),0,($A1)) this should be total hours worked (5 days) but coming up with #value!=SUM(B43-12,E43-12,H43-12,K43-12,N43-12) total sum should work, but...doesn't =SUM(B39-12,E39-12,H39-12,K39-12, N39-12) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |