The Leave Form calculation tool has been formulated to calculate the total leave hours from the Actual Out/In times entered. The Calculation Tool will round to the nearest quarter hour from the overall time taken. If you don't enter the information correctly the form will not accurately calculate.
Step 1 - General Data to Fill in
- Report Period Ending date (e.g. August 31, 2014)
- Name
- SF Identification Number
- Home Department Number
- Physical Work Location
Step 2 - Pay Period Date Entries
Type in the beginning date for the pay period as M/D (e.g. 8/16) starting in the first week (in grey) on the appropriate day of the week and proceed typing each date across the row. Note: You cannot "drag" the dates to auto-fill due to hidden formulated columns.
Step 3 - Record Out and In Times
- For each day of the week that you take leave you will need to type in the OUT & IN times in an "hr:min" format (e.g. 10:16 AM for 16 minutes past 10:00 am).
- When taking leave you will enter the time your leave begins as "Actual Start of Leave Time" (Row 7). Enter the exact time your work ends and you leave without adjustments for meal time.
- The time your leave ends is entered as "Actual End of Leave Time" (Row 14). Enter the exact time you begin work again if returning the same day. Enter the time your work is scheduled to end if you are not returning the same day.
- Additional rows are available if needed and these Out/In times should be entered without skipping lines or making adjustments for meal time.
- If your leave time includes your meal break, you will enter the amount of time for your meal break on Row 15 "Meal Break" (e.g. for 30 minute meal break 0:30).
- Row 16 "Actual Hours and Minutes" will indicate the amount of total leave time for each day. You will then indicate which leave type to be used by entering the total leave time in the appropriate row using the same format "hr:min" (e.g. 2:15 for 2 hours and 15 minutes). The Leave Form Calculation Tool will round all leave time to the nearest quarter hour.
- All leave types shown below "Miscellaneous" will be totaled together.
