Do you want to consider times or just dates?

If the latter then

=NETWORKDAYS(NOW(),A1)

will give you the number of working days from today until the date in
A1 (including both today and A1) so if you have a working day of 8
hours you just need

=NETWORKDAYS(NOW(),A1)*8 to give the number of hours.

You can make it more complicated and include times if you wish.....

note: NETWORKDAYS requires Analysis ToolPak add-in


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