COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Srik on 18 Feb 2008 09:16:45 AM

Title: working hours in month
Post by: Srik on 18 Feb 2008 09:16:45 AM
Hi
I'm wondering if anybody know how to calculate "total working hours in the month" excluding business holidays.

Thanks,
Kanth.
Title: Re: working hours in month
Post by: COGNOiSe administrator on 18 Feb 2008 09:30:21 AM
Maybe this article, for Excel, will help: http://www.cpearson.com/excel/DateTimeWS.htm (http://www.cpearson.com/excel/DateTimeWS.htm)