Worksheet for Calculating Average Weekly Work Hours Per Calendar Year Calculate the weekly work hours for teaching duties, student supervision (includes service as a dissertaion chair), and other required duties Enter into the green shaded cells only The Average Weekly Hours will appear Row 25, Column J Adjunct Faculty Name Adjunct Faculty N # Completion Date Credit Hours Number of Weekly Work Hours Weekly Work ...
Sheet 1 Mini Lesson 1 Mini Lesson Payroll Register Revised August 2016 No Prerequisites Sheet 2 Activity 1 Activity 1 Calculating Gross Pay for Hourly Workers Calculate straight time Hours Hourly Rate (straight time) Wages for the Period 40 125 35 775 26 113 40 18 Total Calculate overtime at time and one half Hours worked in excess of 40 Hourly Rate (straight time) Overtime ...
HOURLY RATE CALCULATION Type Full time Type FTE hours in Type Actual Equivalent salary in cell B4 working hours of Cell A4 (it can vary between work in cell C4 375 and 42) 31000 39 15 HOW TO CALCULATE THE COST CHARGED TO THE BUDGET OF ONE EXTRA HOUR 1 extra hour costs Casual staff only Holiday accrued for each hour of work (use calculator ...
Sheet 1 Calculation Options LAST RESORT FTE CALCULATOR OPTION #1 If you have the number of credit hours, use the Academic FTE Chart (Open FTE tab) (This chart is based on the information found at httpswwwohioeduprovostapaaoverloadscfm) OPTION #2 If you do not have the credit hours, determine the FTE by the amount of time or effort expected for the payment Example You are paying someone ...
Sheet 1 All Excel Formula to Calculate Hours Worked Minus Lunch 12 Hours Format Start Time Lunch Starts Lunch Ends End Time Total Time of Work (Hrs) Formula 900 AM 100 PM 200 PM 600 PM 8 SUM((C6B6)(E6D6))*24 915 AM 115 PM 200 PM 615 PM 825 SUM((C7B7)(E7D7))*24 Start Time Lunch Starts Lunch Ends End Time Total Time of Work (Hrs) Total Time of Work ...
Whole Time Equivalent Calculator To calculate the full time equivalent of multiple part time employees please complete the green fields below Use each row of the table to enter the number of staff working a particular number of hours, the yellow box at the bottom corner will then display the number of wholefull time employees for the purposes of your ArbAC Application How many hours ...
Sheet 1 INSTRUCTIONS GRANVILLE COUNTY NONEXEMPT TIME SHEET BASIC INSTRUCTIONS Read this worksheet in its entirety before beginning use of this timesheet and refer back to it if you have questions regarding how specific items are calculated Enter data in blue cells only Other cells containing formulas, etc have been locked to prevent accidental deletion START HERE All employees must begin on the & ...
XLS - Excel | 0.02 MB | Free Download
