Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Function help please
I am working for a company in Africa that employees many
nationalities, unfortunately for me each nationality has a differing leave pattern, and I have to keep track of days worked and days leave, I am having a problem finding a suitable function to calculate leave and work days, bearing in mind we work 365 days per year. Nationality 1 works 6 weeks on and 2 off Nationality 2 works 12 months then 45 days off Nationality 3 has every Friday off and also gets 45 days leave per year I really need to keep track of date start work, date start leave, days worked, leave taken, and balance, I am having trouble getting the calculation to work, any help would be very much appreciated. Brian Women and cats will do as they please, and men and dogs should relax and get used to the idea. |
#2
|
|||
|
|||
That sounds like a nightmare to manage. Why don't you break it down into
small pieces. Work with Nationality 1 first. I assume you have a column in your data set for Nationality. I'd probably do a calculation to determine what they are eligible for. The challenge is including where they are to date. "Brian" wrote in message news:1121321287.a6e192d20ec845fd6742bfc7d30dc1ec@t eranews... I am working for a company in Africa that employees many nationalities, unfortunately for me each nationality has a differing leave pattern, and I have to keep track of days worked and days leave, I am having a problem finding a suitable function to calculate leave and work days, bearing in mind we work 365 days per year. Nationality 1 works 6 weeks on and 2 off Nationality 2 works 12 months then 45 days off Nationality 3 has every Friday off and also gets 45 days leave per year I really need to keep track of date start work, date start leave, days worked, leave taken, and balance, I am having trouble getting the calculation to work, any help would be very much appreciated. Brian Women and cats will do as they please, and men and dogs should relax and get used to the idea. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |