Date function

[Matt S]

I need to put together a function or formula that lets me work out how many
working hours there are between now and a given date.
Has anybody got any suggestions as to the best way of doing this?
It seems like the sort problem that someone must have encountered before.
Any assistance gratefully received.

Thanks

[daddylonglegs]

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