Spreadsheet: 852327d1702396362-how-to-create-a-rule-for-a-cell-2024test-sheet
Sheet: Jan 2018

 |  |  |  |  |  |  |  |  | NASH COUNTY 911 COMMUNICATIONS
 |  |  |  |  |  |  |  |  | EMPLOYEE TIME REPORT
 | EMPLOYEE NO:
 | Name: |  |  |  |  |  | Position: |  |  |  |  |  |  |  |  |  | Hire Date: |  |  | Yr:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Year: |  |  | Shift: |  |  |  |  |  |  |  | ON-CALL TIME RECORD
Start Pay Period: |  |  |  |  | End Pay Period |  |  |  |  |  |  |  |  |  | 2017
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOLIDAY RATE FORMULAS - CURRENT SALARY AND NEW SALARY
 |  | Regular Hours |  |  |  |  |  |  | Week |  |  |  |  | Annual/Sick Leave Used |  |  |  |  |  |  |  |  |  |  | Pay Type 700 Weekends @ $25.00/day |  |  |  |  |  |  |  |  | Pay Type 701 Holidays @ $40.00/Day |  |  |  |  |  |  |  |  | Pay Type 702           WEEK DAYS                        @ $15/day          TOTAL |  |  |  |  |  |  |  |  | Total Pay Type 702 Wk 1
Wk 1 | MON | TUES | WED | THUR | FRI | SAT | SUN | HRS | 1 day, 12:00:00 | 1 day, 20:00:00 | OT |  | Wk 1 | MON | TUES | WED | THUR | FRI | SAT | SUN | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
Date |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B15 |  |  |  |  |  |  |  |  | C15 |  |  |  |  |  |  |  |  | D15 |  |  |  |  |  |  |  |  | E15 |  |  |  |  |  |  |  |  | F15 |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | H15
Hours |  |  |  |  |  |  |  |  | Total Hrs Wkd |  |  |  | Annual
 |  |  |  |  |  |  |  |  | Total OT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 1 |  |  |  |  |  |  |  |  | WEEK 1 |  |  |  |  |  |  |  |  | WEEK 1 |  |  |  |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | 1 day, 16:00:00 | 1.666666666666667
On Call |  |  |  |  |  |  |  |  |  |  |  |  | Sick
Holiday
Holiday New Rate
Wk 2 | MON | TUES | WED | THUR | FRI | SAT | SUN | WKD | 1 day, 12:00:00 | 1 day, 20:00:00 | OT |  | Wk 2 | MON | TUES | WED | THUR | FRI | SAT | SUN | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
Date |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Pay Type 700 Weekends @ $25.00/day |  |  |  |  |  |  |  |  | Pay Type 701 Holidays @ $40.00/Day |  |  |  |  |  |  |  |  | Pay Type 702           WEEK DAYS                        @ $15/day          TOTAL |  |  |  |  |  |  |  |  | Total Pay Wk 2 Type 701 |  |  | B22 |  |  |  |  |  |  |  |  | C22 |  |  |  |  |  |  |  |  | D22 |  |  |  |  |  |  |  |  | E22 |  |  |  |  |  |  |  |  | F22 |  |  |  |  |  |  |  |  | G22 |  |  |  |  |  |  |  |  | H22
Hours |  |  |  |  |  |  |  |  | Total Hrs Wkd |  |  |  | Annual
 |  |  |  |  |  |  |  |  | Total OT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 2 |  |  |  |  |  |  |  |  | WEEK 2 |  |  |  |  |  |  |  |  | WEEK 2 |  |  |  |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | 1 day, 16:00:00
On Call |  |  |  |  |  |  |  |  |  |  |  |  | Sick
Holiday
Holiday New Rate
Wk 3 | Christmas | Christmas | Christmas | THUR | FRI | SAT | SUN | WKD | 1 day, 12:00:00 | 1 day, 20:00:00 | OT |  | Wk 3 | MON | TUES | WED | THUR | FRI | SAT | SUN | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 3
Date |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Pay Type 700 Weekends @ $25.00/day |  |  |  |  |  |  |  |  | Pay Type 701 Holidays @ $40.00/Day |  |  |  |  |  |  |  |  | Pay Type 702           WEEK DAYS                        @ $15/day          TOTAL |  |  |  |  |  |  |  |  | Total Pay Wk 3 Type 701 |  |  | B29 |  |  |  |  |  |  |  |  | C29 |  |  |  |  |  |  |  |  | D29 |  |  |  |  |  |  |  |  | E29 |  |  |  |  |  |  |  |  | F29 |  |  |  |  |  |  |  |  | G29 |  |  |  |  |  |  |  |  | H29
Hours |  |  |  |  |  |  |  |  | Total Hrs Wkd |  |  |  | Annual
 |  |  |  |  |  |  |  |  | Total OT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 3 |  |  |  |  |  |  |  |  | WEEK 3 |  |  |  |  |  |  |  |  | WEEK 3 |  |  |  |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | 1 day, 16:00:00
On Call |  |  |  |  |  |  |  |  |  |  |  |  | Sick
Holiday | 8:00:00 | 8:00:00 | 8:00:00
Holiday New Rate
Wk 4 | New Year's | TUES | WED | THUR | FRI | SAT | SUN | WKD | 1 day, 12:00:00 | 1 day, 20:00:00 | OT |  | Wk 4 | MON | TUES | WED | THUR | FRI | SAT | SUN | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 4
Date |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Pay Type 700 Weekends @ $25.00/day |  |  |  |  |  |  |  |  | Pay Type 701 Holidays @ $40.00/Day |  |  |  |  |  |  |  |  | Pay Type 702           WEEK DAYS                        @ $15/day          TOTAL |  |  |  |  |  |  |  |  | Total Pay Wk 4 Type 701 |  |  | B36 |  |  |  |  |  |  |  |  | C36 |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | E36 |  |  |  |  |  |  |  |  | F36 |  |  |  |  |  |  |  |  | G36 |  |  |  |  |  |  |  |  | H36
Hours |  |  |  |  |  |  |  |  | Total Hrs Wkd |  |  |  | Annual
 |  |  |  |  |  |  |  |  | Total OT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 4 |  |  |  |  |  |  |  |  | WEEK 4 |  |  |  |  |  |  |  |  | WEEK 4 |  |  |  |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | 1 day, 16:00:00
On Call |  |  |  |  |  |  |  |  |  |  |  |  | Sick
Holiday | 8:00:00
Holiday New Rate
Wk 5 | MON | TUES | WED | THUR | FRI | SAT | SUN | WKD | 1 day, 12:00:00 | 1 day, 20:00:00 | OT |  | Wk 5 | MON | TUES | WED | THUR | FRI | SAT | SUN | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 5
Date |  |  |  |  |  |  |  |  |  | X |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Pay Type 700 Weekends @ $25.00/day |  |  |  |  |  |  |  |  | Pay Type 701 Holidays @ $40.00/Day |  |  |  |  |  |  |  |  | Pay Type 702           WEEK DAYS                        @ $15/day          TOTAL |  |  |  |  |  |  |  |  | Total Pay Wk 5 Type 701 |  |  | B43 |  |  |  |  |  |  |  |  | C43 |  |  |  |  |  |  |  |  | D43 |  |  |  |  |  |  |  |  | E43 |  |  |  |  |  |  |  |  | F43 |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | H43
Hours |  |  |  |  |  |  |  |  | Total Hrs Wkd |  |  |  | Annual
 |  |  |  |  |  |  |  |  | Total OT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 5 |  |  |  |  |  |  |  |  | WEEK 5 |  |  |  |  |  |  |  |  | WEEK 5 |  |  |  |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | New Rate Formula below: |  |  |  |  |  |  |  |  | 1 day, 16:00:00
On Call |  |  |  |  |  |  |  |  |  |  |  |  | Sick
Holiday
Holiday New Rate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HRS / MIN
 |  |  | Annual Leave |  | [NAME] |  |  |  |  |  |  |  |  | Less than two years |  |  |  | 8:00:00
Starting Balance |  |  |  |  |  |  | <== Key in Minutes (not hundredths) |  |  |  |  |  |  | 2 but less than 5 years |  |  |  | 9:20:00
Time Used This Pay Pd
Time Earned This Pay Pd |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 but less than 10 years |  |  |  | 11:20:00
Balance
Balance |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 but less than 15 years |  |  |  | 13:20:00
Time Earned This Pay Pd
Time Used This Pay Pd |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 but less than 20 years |  |  |  | 15:10:00
Ending Balance
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 years or more |  |  |  | 17:10:00
We hereby certify that the time record of service rendered as stated is correct.       NOTE:  Time sheets must be turned in to your supervisor according to the pay period schedule.
TOTAL HOURS
REGULAR: |  |  | OVERTIME: |  |  | HOLIDAY: |  |  | ADMIN: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OVERTIME NEW RATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OVERTIME Current Rate |  |  |  |  | Regular Pay Old Rate
ON CALL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OVERTIME New Rate
700 @ $25/Day | Total # Days | 701 @ $40/Day | Total # Days | 702 @ $15/day | Total # Days | TOTAL ON-CALL PAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Current Pay |  |  |  |  | New Pay
 |  |  |  |  |  | 700 - 701 - 702 |  |  |  |  |  |  | Holiday Dates |  |  |  |  |  |  |  |  |  |  |  | Vacation Hours |  | Sick Hours |  |  | Vacation Hours |  |  | Sick Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOLIDAY Current Rate |  |  |  |  | Regular Pay New Rate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:00:00 |  |  | 8
Employee: |  |  |  | Shift Supervisor: |  |  |  |  |  | Asst Director: |  |  |  |  |  | Director: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOLIDAY New Rate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:00:00 |  |  | 8
COMMENTS: