Dear All, can anyone help me prepare an Excel sheet for Head Office employees only, including their names and joining dates? Any employee who has not completed one year with the company will not be entitled to a ticket fare now. They will be entitled when they complete one year.
For employees entitled to Family tickets (family members should be staying in the UAE), we need to include the names of family members, children's names, and ages, and calculate the ticket fare accordingly. Children between the ages of 0 and 2 years will get 10% of the total ticket rates, and children between the ages of 2 and 12 years will get 75% of the ticket rate.
For employees entitled to Family tickets (family members should be staying in the UAE), we need to include the names of family members, children's names, and ages, and calculate the ticket fare accordingly. Children between the ages of 0 and 2 years will get 10% of the total ticket rates, and children between the ages of 2 and 12 years will get 75% of the ticket rate.