Thats done the trick, most grateful for your help !!

Regards Tony C
------------------------------

"daddylonglegs" wrote:


I was assuming that your start time/date and end time/date would be
within work hours. If not you probably need to use a more complex
formula, i.e.

=(NETWORKDAYS(A2,B2,)-1)*($E$5-$E$4)+IF(WEEKDAY(B2,2)5,$E$5,MEDIAN(MOD(B2,1),$E$ 5,$E$4))-IF(WEEKDAY(A2,2)5,$E$4,MEDIAN(MOD(A2,1),$E$5,$E$4 ))

where A2 contains start time/date, B2 contains end time/date, E4
contains daily start time (e.g. 08:00) and E5 contains daily end time
(e.g. 18:00). This allows for your time/dates in A2 and B2 to be any
time, even at weekends


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=525903