After Hours

Ask something
Question Locked

Urgently Need help

0 helpful
2 replies

by odyssey_myth9

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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..

2 replies

by tony hopkinson

as such.
You need a list of holidays, then query out the number of non working days in the range and subtract that from the number of full days.
All the solutions I've seen for this were around databases, some even beefed for adding in personal holidays as well for looking at available resources for a project etc.

You can prepopulate the table with traditional bank holidays always 25th Dec, and last friday in april etc.

This discussion is closed to new replies.