The column for Credit Adjustments is for when you make use of your holiday allowance, sickness, approved absences and bank holidays.Always use a semi colon (:) to separate hours from minutes when you enter your time.If your time is in the morning, before 10am, enter the time with a zero at the beginning e.g. Always enter time in a 24 hour clock format e.g.The cell in N32 from your previous month should be green if this is the case. If you are in credit of hours (you have worked extra hours in the previous month) then leave the ‘tick if in debit’ box unchecked.In other words, if your flexi-time sheet from the previous month is red in cell N32, then tick the box. The option to ‘Tick if in debit’ is for when you owe hours from the previous month.This will automatically update the rest of the sheet. You can adjust the number of hours in your standard working day.For now, there are a few bits and pieces that may make using our flexi-time calculator a little easier: This free Excel flexi-time calculator is just one example.

Here at Anne Corder Recruitment we like to nurture our relationships with clients, which is why we try to offer as much added value to our services as possible. Our flexi-time calculator and spreadsheet is different from others online: you can download it and edit it as and when you need (that means you can change the number of working days in the month, add in your own company logo, make changes to core hours and much, much more).Įvery business is different, which is why we’ve made our flexi-time calculator, well, flexible!

Hours worked calculator excel template