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.

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.

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.