It's a bit tricky but can be done.
It's based on the fact that Excel calculates dates and time from
running numbers but it looks like it's date and time. Anyhow...
Here is one of the formulas, but best is to view example file -
attached.
=IF(NETWORKDAYS(B8,C8,$E$2:$E$4)-10,(C8-(INT(C8)+$C$2))-(B8-(INT(B8)+$C$3))+(NETWORKDAYS(B8,C8,$E$2:$E$4)-2)*$C$4,C8-B8)
The formula calculates hours - used - and deductes weekends and -
customized - holidays. You can also change helpdesk open hours.
Hope it can give you some ideas
Ola Sandström
Example zip-file:
http://www.excelforum.com/attachment...tid=3647&stc=1
+-------------------------------------------------------------------+
|Filename: Book5.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=3647 |
+-------------------------------------------------------------------+
--
olasa
------------------------------------------------------------------------
olasa's Profile:
http://www.excelforum.com/member.php...o&userid=17760
View this thread:
http://www.excelforum.com/showthread...hreadid=390684