Not sure what yr workbook looks like, but I assume there will be some kind of table holding the hours worked of employees per month.
The attached sample shows some formulas using IF to calculate what you need (as far as I understand).
Not sure what yr workbook looks like, but I assume there will be some kind of table holding the hours worked of employees per month.
The attached sample shows some formulas using IF to calculate what you need (as far as I understand).
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks