If you have a start time/date in A2 and an end time/date in B2 you can
calculate the working hours between them with this formula

=(NETWORKDAYS(A2,B2)-1)*("17:00"-"09:00")+MOD(B2,1)-MOD(A2,1)

format as [h]:mm

note: the above is only guaranteed to work if your "time stamps" are
within working hours, post back if not, you'll need a more complex
formula.....


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