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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
Tammy,
Would you like to explain a bit more exactly whatit is you are trying to do - remember we can't see your spreadsheet. However that is NOT an invitation to post it here as an attachment. Just try to explain it in text. -- Regards, Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "Tammy" wrote in message ... 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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
I have employees that work 7 to 3:30, 3-11:30, 5 to 9, 5pm to 1:30 am. I am
trying to subtract lunch for anyone working more than 6 hours, then total all hours worked, all lunches totalled, then a total of all hours worked in the facility. My problem seems to be the people that work past midnight, although the daily totals are correct, the weekly totals for each individual does not work. "Sandy Mann" wrote: Tammy, Would you like to explain a bit more exactly whatit is you are trying to do - remember we can't see your spreadsheet. However that is NOT an invitation to post it here as an attachment. Just try to explain it in text. -- Regards, Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "Tammy" wrote in message ... 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) |
Reply |
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) |