Flexible Schedule Hours Balance Calculator
Track a flexitime hours balance: compare the hours you actually worked against your contracted hours for a period and carry the surplus or deficit forward.
How it works
required hours = contracted hours per week × weeks in the period · period change = hours worked − required hours · closing balance = opening balance + period change (positive = credit, negative = time owed)
Under flexitime you can vary your daily hours as long as you meet a contracted total over a settlement period. The balance is simply how far ahead or behind that target you are: multiply your contracted weekly hours by the number of weeks to get the hours required, subtract that from the hours you actually worked, then add whatever balance you carried in. A positive closing balance is flex credit you can take as time off; a negative one is time you still owe. Many schemes cap how much credit or debit you may carry between periods.
Worked example
Contracted at 37.5 hours a week over 4 weeks, you are required to work 150 hours. You actually worked 158, a surplus of 8 hours this period. Starting from a zero opening balance, you close +8.00 hours in credit — nearly a full flexi-day banked.
Frequently asked questions
What does a negative balance mean?
It means you have worked fewer hours than required and owe that time — a flex debit. You clear it by working extra hours in a later period, and most schemes limit how large a debit you may carry forward.
How do I count part-weeks?
Enter the weeks as a decimal. A 4-week-and-3-day period at a 5-day week is about 4.6 weeks; or work out the exact required hours another way and back-calculate. The required total is just contracted hours × weeks.
Does this include overtime pay?
No — flexitime tracks hours, not pay. Surplus hours are normally taken back as time off rather than paid. If your extra hours are paid overtime instead, use an overtime pay calculator.
Related calculators
This calculator is for educational purposes. Double-check important results before acting on them.