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)
|