chabuca1
Mar 21st, 2002, 06:42 AM
In excel the calculation in C2 is somehow not working:
col A col B col C col D col E
Txn Start Txn End Total hrs start work end work
2/27/02 22:00 2/28/02 14:01 .02 9:00 17:00
The forumla in cell C2 is:
=IF(INT(A2)=INT(B2),ROUND(24*(B2-A2),2),(24*(F2-E2)*(MAX(NETWORKDAYS(A2+1,B2-1),0)+INT(24*(((B2-INT(B2))-(A2-INT(A2)))+(F2-E2))/(24*(F2-E2))))+MOD(ROUND(((24*(B2-INT(B2)))-24*E2)+(24*F2-(24*(A2-INT(A2)))),2),ROUND((24*(F2-E2)),2))))
Can someone tell me where I went wrong?
Thank you.
col A col B col C col D col E
Txn Start Txn End Total hrs start work end work
2/27/02 22:00 2/28/02 14:01 .02 9:00 17:00
The forumla in cell C2 is:
=IF(INT(A2)=INT(B2),ROUND(24*(B2-A2),2),(24*(F2-E2)*(MAX(NETWORKDAYS(A2+1,B2-1),0)+INT(24*(((B2-INT(B2))-(A2-INT(A2)))+(F2-E2))/(24*(F2-E2))))+MOD(ROUND(((24*(B2-INT(B2)))-24*E2)+(24*F2-(24*(A2-INT(A2)))),2),ROUND((24*(F2-E2)),2))))
Can someone tell me where I went wrong?
Thank you.