Excel Flexi-Time Calculator: Make sure you keep track of flexible working hours

  • Home
  • Resources
  • Excel Flexi-Time Calculator: Make sure you keep track of flexible working hours

We all know that the laws and expectations surrounding flexible working are changing dramatically since the pandemic. And we know, from a show of hands at our employment law seminar, that some businesses are inundated with requests for working hours to change and flexible working to be considered.

For HR managers, especially in smaller businesses, that can mean a lot more admin work and a lot of time spent analysing how to manage flexible working hours.

That’s why we’ve designed a free downloadable Excel flexi-time calculator.

 

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).

Every business is different, which is why we’ve made our flexi-time calculator, well, flexible!

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. This free Excel flexi-time calculator is just one example.

For now, there are a few bits and pieces that may make using our flexi-time calculator a little easier:

  1. You can adjust the number of hours in your standard working day. This will automatically update the rest of the sheet.
  2. The option to ‘Tick if in debit’ is for when you owe hours from the previous month. In other words, if your flexi-time sheet from the previous month is red in cell N32, then tick the box.
  3. 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. The cell in N32 from your previous month should be green if this is the case.
  4. Always enter time in a 24 hour clock format e.g. 15:30 for half three in the afternoon. If your time is in the morning, before 10am, enter the time with a zero at the beginning e.g. 09:00
  5. Always use a semi colon (:) to separate hours from minutes when you enter your time.
  6. The column for Credit Adjustments is for when you make use of your holiday allowance, sickness, approved absences and bank holidays. Simply enter the number of hours that have been used into the column and provide a comment to fully explain why those hours were used.
  7. You can extend the number of working days in the month easily by extending the columns A to S appropriately. You will need to ensure the formula is copied into any new rows created for each of the columns. Also ensure that the Balance Carried forward formula is updated appropriately.
  8. To change the date that the flexi time sheet starts, simply enter the new date into the week commencing box.

Please note that there are formulas throughout the spreadsheet, and these all help to make the calculations work effectively and accurately. When updating the sheet with new columns, rows or cells make sure that you update any corresponding formulas at the same time.

The calculator is specially designed for both HR managers looking to manage their employees’ times, and for employees looking for an easy way to keep on top of their hours – so why not download it today?

If you’re a candidate, send us your CV or apply for one of our jobs now.

If you’re an employer, read about Our Services or see our Case Studies to find out more about why businesses love Anne Corder Recruitment.

Anne_Corder-9

Alex Smith

Recruitment Specialist

I’ve worked in recruitment for the same agency for over 12 years, covering finance, office support, construction, and engineering. Temp and perm. Previously, my line of work was within banking and estate agency.
Favourite food: “Curry (Hot)”
Favourite film: “Heat”

Outside of work

“Gym 5 days a week. Home life consists mostly of entertaining a 3 year old! (for clarification – my son)”

Alex on ACR

“Very refreshing to work for a recruitment agency that genuinely care for their candidates and clients”

E: alex@annecorder.co.uk
T: 01733 235298

Sarah-Jane Bond

Recruitment Specialist

I have spent the majority of my career working in Operational and Project Management roles. I first worked with ACR about 25 years ago as a candidate. ACR secured me a role at RNIB, where I stayed for 15 years, finishing as Head of Operations. Recruitment has always been a big part of the roles I have undertaken and is something that I really enjoy. When you match a fantastic candidate with the right client there is no better feeling!
Favourite food: “Has to be any dish from the Mediterranean”
Favourite film: “There are many, love a chick flick, especially ‘The Holiday at Christmas”

Outside of work

“I love socialising with friends, can always squeeze a bit of retail therapy in around volunteering at Deeping Rangers FC, running their hospitality on match days.”

Sarah-Jane on ACR

“I couldn’t have been more delighted when Nel asked me to join the company and have felt at home since day one. They really do care about providing the best service for their clients and candidates, building genuine relationships with both. The team culture is second to none, everyone supporting and looking out for each other. It is a pleasure to come to work every day.”

E: sarah-jane@annecorder.co.uk
T: 01733 235298

Emily Roach

Recruitment Specialist

Emily was a Primary School Teacher for 10 years, before moving into the EdTech space, as a Relationship Specialist for MATs. She joined ACR in July 2023 and particularly thrives when recruiting for Account Management, Customer Service and Sales roles.
Favourite food:
“Spag bol or pizza”
Favourite film:
“The Notebook – or any romantic chick flick really!”
Outside of work
“I have a 1-year-old, so love fun family weekends with my fiancé and son more than anything. Time socialising with friends and family is where I’m happiest.”
Emily on ACR
“The unique culture, values, and style at ACR is polar opposite to other recruitment agencies and what I believed recruitment was. Having previously been a Relationship Specialist, I feel I’m doing the same thing! No hard sell, we truly care about our candidates and clients, and the team culture is 2nd to none!”
E: emily@annecorder.co.uk
T: 01733 235298

Sign-up to an Event

Please fill out the form below to sign-up to an event

CV Quicksend

Please fill out the form below to submit your CV