Try this

=17.5/24-(A1-ROUNDDOWN(A1,0)) gives number of hours worked on 1st day

=NETWORKDAYS(A1,A2) gives number of full (8 1/2 hour) working days
(multiply by 8.5/24 to get hours)

=A2-(ROUNDDOWN(A2,0)+0.375) gives number of hours worked on the final
day

add them all up and you should have the number of days/ hours worked


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=386045