Re: excel問顥或有冇媽咪是在工程公司做會計，urgent!!!
Debbie媽 寫道:
[quote]
lovebbmom 寫道:
USE THE E.G. BEFORE,
SIMPLY SET
12:00:00($A$1)
17:00:00($A$2)
20:00:00($A$3),
THEN, THE FORMULA AS
=(HOUR(IF(B6>$A$1,(IF(C6>$A$2,$A$2-B6,0)),0))*1+(HOUR(IF(B6>$A$1,(IF($F$5>$E$5>C6,$A$3-C6,0)),0))*1.5))*100
FOR ANY CHANGE, SIMPLY APPLY THE CONCEPT AND TRY...
我根據你的 formula, 但 $F$5, $E$5是沒有數字，所以amount=0,我想問點解? [/quote]
ic...我尋日趕住d 野打錯左...
should be
=(HOUR(IF(B6>$A$1,(IF(C6>$A$2,$A$2-B6,0)),0))*1+(HOUR(IF(B6>$A$1,(IF($A$3>$A$2>C6,$A$3-C6,0)),0))*1.5))*100
busy...努力!!!
心裡平安, 想住進一個寜靜小島...
好好珍惜過去, 活在當下...
發表於 
返回列表
