# Calculate employee hours for employee evaluation?

1. ## Calculate employee hours for employee evaluation?

Hi ~

I've been asked to construct a timesheet where hours are tracked at 480
hour intervals. At each 480/hr interval, the employee is due for an
evaluation. I'd like something like "Evaluation Due" to come up in the
cell next to the YTD hours. Can anyone help please?

Here's the setup I have so far:

Week1 Week2
Week3 Week4 Week5

Jan06 Weekly hrs 19 19
19 7 3
Ttl monthly hrs 67
Year to date 67

TIA!

Patricia

2. ## Re: Calculate employee hours for employee evaluation?

Triesha,

It may be that the hours never add up to a multiple of 480. Say the total
was 470 and the person works 19 hours that week. The total would jump over
the 480 target and so would not trigger your message. I would therefore
suggest triggering the message if the total was within a certain range:

=IF(MOD(G20,480)<20,"Evaluation due","")

It will however have the disadvantage that it will trigger the message for
20 hours either side of the target.

--
HTH

Sandy
sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

"Triesha" <pmanzella@gmail.com> wrote in message
> Hi ~
>
> I've been asked to construct a timesheet where hours are tracked at 480
> hour intervals. At each 480/hr interval, the employee is due for an
> evaluation. I'd like something like "Evaluation Due" to come up in the
> cell next to the YTD hours. Can anyone help please?
>
>
> Here's the setup I have so far:
>
> Week1 Week2
> Week3 Week4 Week5
>
> Jan06 Weekly hrs 19 19
> 19 7 3
> Ttl monthly hrs 67
> Year to date 67
>
>
>
>
>
> TIA!
>
> Patricia
>

3. If your YTD hours all total in one cell you can try this....

=if(A1>=480,"Evaluation Due","")
Maybe this will help.

4. ## Re: Calculate employee hours for employee evaluation?

Sandy ~

Thank you for such an elegant solution. It's just what I needed. Give
me a shout if you ever need a librarian!

Triesha

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1