|
-
Mar 21st, 2002, 07:42 AM
#1
Thread Starter
Junior Member
Excel: Total Hrs b/w 2 Date/Time Stamps
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|