Hey,
Im Jess, was wondering wheather anyone could help me figure out the formulae to my KPI report(Excel format). I was trying to search for solution on how do i calculate the number of hours with the given dates without having to include the number of public holidays as well as weekends. Eg: 15.02.2007(Thur) to 21.02.2007(Wed)
= 24hrs x 3days= 72hrs
*Having 19 & 20 as public holidays*.
Its kinda urgent so as i could help my colleagues to save time without them having to use their fingers n toes to count the total hours..
Thanks A Million..
