If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
fx for vacation
I need to compute the vacation earned by an employee. Each employee earns
3.08 hrs every two weeks. How would write that as a formula. |
#2
|
|||
|
|||
fx for vacation
If a1 has the number of weeks the employee has worked, you use:
=3.08*a1/2 Regards, Fred. "Ray" wrote in message ... I need to compute the vacation earned by an employee. Each employee earns 3.08 hrs every two weeks. How would write that as a formula. |
#3
|
|||
|
|||
fx for vacation
Hi,
Well, that depends. Are you trying to figure out how many vacation hours they have accumulated over their entire employment history, or within the current year, or within the current fiscal year, and do you count all days (365) or only weeks in which they were not on vacation, leave, or whatever. And what if they started after the first of the year? Suppose you enter the start date in column A, this could be their start date in the current year, fiscal year or employment. In column B you could use the following formula to calculate there vacation: =3.08*(TODAY()-A2)/14 Format as Number. Note this does not take into account what day of the week is the beginning of a week. For example if they start on Friday do you give them credit for the whole week, or do you go from Friday to Friday, or do you round down to the nearest whole week? As you can see there are a lot of unanswered questions. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Ray" wrote: I need to compute the vacation earned by an employee. Each employee earns 3.08 hrs every two weeks. How would write that as a formula. |
Thread Tools | |
Display Modes | |
|
|