>
 

Flexi Time Sheet Calculator

 

Instructions for the Flexi Time Calculator

  1. Only enter data in the white cells
  2. Use the mouse or the tab key to move from cell to cell. Shift + tab to go back a cell
  3. Enter the flexi period start date in the format DD/MM/YY eg: 29/05/06 (other formats are not accepted).  The start of the working week can be any day
  4. Enter basic weekly hours eg: 35.  If you enter a fraction of an hour eg: 18 and ½ hours per week, this should be in decimals ie: 18.5  (NB decimals in this cell only!)
  5. Enter an amount in the flexi balance brought forward (optional). This cell relates to hours worked in previous weeks.  Select either a flexi credit balance (+) or a flexi debit balance (-) from the drop down menu and then enter the hours eg: + 2:25
  6. Use the 24 hour clock when you enter ‘in’ and ‘out’ times eg: 17:15
  7. Use a colon (no spaces) to separate hours from minutes
  8. You need not fill in times in every cell on every day, but you must fill in at least one ‘in’ time and one ‘out’ time (in the same block) on the days you are recording. The time sheet calculates the daily totals for you
  9. You may want to type (words) in the comments cell to remind yourself of particular activities on a particular day eg: conference 
  10. Enter (paid) holiday days and (paid) days off sick in the ‘add hours’ cell for that day  eg: enter 7 ¼ hours as 7:15 (7 hours and 15 minutes)
  11. Enter unpaid time-out on a particular day for a non work related activity in the ‘deduct hours’ cell for that day eg: 1:50 (one hour and 50 minutes)

Notes

  • Check out the Examples page for clarification on any of the above instructions
  • If you want to clear the sheet and enter different times, press ‘Clear Data’ to start again
  • The time sheet calculates your total working hours for the week and gives you a flexi balance (credit or debit) against your basic weekly hours
  • When you have entered all your times, press 'Print Page' to keep a paper record of your working week. Select 'Landscape' for best print results
  • This online Flexi Time Sheet cannot be 'saved'.
  • The Online Flexi Time Database service offers permanent recording of your working time, and automatic calculation of your flexi balance for each week and period, with 'carry forward' and built-in 'flexi rules'. Try a free 4-week trial of the Online Flexi Time Database
 

© Flexi Time Manager 2008