Productivity

by Jonathan Jonathan No Comments

FREE Excel Spreadsheet Template – Recording Hours Worked

“Recording Worked Hours” (by Client/Project)

We all like free stuff don’t we? Especially if it proves useful! Here on this page, I’m offering you free of charge a useful spreadsheet template I created for recording hours worked.

“Recording Hours Worked.xlsx”

It’s a spreadsheet I’m using myself so I’m getting first-hand experience of using the file. In that way, I hope you also find it beneficial.

No strings attached!

Though coffee and a doughnut would be nice!

If you like it, let me know. If you share it with others, please let them know where the spreadsheet came from!

It’s probably most useful for those self-employed people out there who need a simple way of recording hours worked. It’s intended for recording hours worked for their clients, but it can be used for other business scenarios such as projects. If you use it in larger scenarios, I’d be very interested to find out how. Would you let me know? 

All I ask is that you sign up to the Anything I.T. mailing list or Like our Facebook Page. We don’t spam with numerous emails. In fact, you will likely only get between 1-2 a month! I’m not even going to force you to provide an email address. The file is just there, at the bottom of the page, ready to use.

Disclaimer/Warning

To make this work, you may need a basic understanding of Excel documents. if you break your copy, you can ask me for help, but please don’t blame me!

Explaining the Document

Summary sheet

Below are a couple of screenshots of the SUMMARY sheet of the spreadsheet (or workbook whichever you like to call it). You will notice there are a number of sheets, all named the months of the year, as well as the SUMMARY sheet.

Recording Worked Hours spreadsheet

Recording Worked Hours spreadsheetIn this example, we have a sheet that summarises the data across the year and the individual months.

On this, the SUMMARY sheet, we enter the client/project on the left-hand side. These names are automatically populated to the other individual sheets. This is important as it ensures no typing mistakes are made by the user (and thereby providing accurate data).

The SUMMARY sheet provides not only a, ermmmm, summary, of hours worked each month and for each client/project, but money made (if you use this as the basis for your invoicing).

The financial aspect is optional and for me at least, it is primarily used for giving me an idea of where I am with certain clients.

You will also note the columns which I hope are self-explanatory:

  • Total Hours
  • Total £
  • The individual months (each with Hours and £)

On the far right-hand side, you will see a list of rates. Enter your own here. These rates are used on the individual month sheets (more on this below).

Recording Worked Hours spreadsheet

The ‘Month’ sheets – Entering in your hours worked

On each ‘month’ sheet, you should see on the left, the area where you need to enter four pieces of data:

  • Date (the date of course!)
  • For Whom/What (See below for an explanation)
  • Description (Whatever you want in here to describe the work carried out)
  • Hours (The number of hours obviously. Can work in parts of hours too, such as ‘1.5’.

Recording Hours Worked

For Whom/What

Your client name or project name. Clicking into this cell reveals a dropdown arrow which picks up the client names/project names you entered in on the SUMMARY sheet. Adding a client name or project name on the SUMMARY sheet automatically adds it to the dropdown options.

Recording Worked Hours spreadsheet

This cell is configured so that you must enter in (or select from the dropdown) an exact match from the list. Trying to type in ABC1234lhalhdlahdl (if it doesn’t exist on your SUMMARY sheet) will produce an error.

Type in a description and enter how many hours work, or indeed a decimal of an hour (0.1 would be 6 minutes, 0.25 would be quarter of an hour, 0.33 would be 20 minutes, 0.5 half an hour, and so on).

The ‘Month’ sheets – Client/Project auto-summarisation

On the right-hand side, you will notice the client names (or your project names) automatically populated.

Important: Do not try to type into these cells. Only the rate column of cells is editable (but you will still need to enter valid data).

Additionally, the hours worked for each client/project is auto-calculated based on the data on the left-hand side so do not try to edit this directly.

Option: You can also choose a rate for this client/project. If you do, then the amount in currency is automatically calculated. It could be useful for you if you need to generate invoices based on time worked.

Recording Hours Worked

The rate is also chosen via a dropdown menu. The rates are configured on the SUMMARY sheet to the far right-hand side.

Like the other dropdown, you must select a valid option otherwise it will display an error.

Protected Cells

In the blank version below, some cells are protected. This is because we don’t want anyone accidentally overwriting the formulas within the cells by mistake and wondering why it’s not working!

If you feel competent enough, you can unlock the cells via unlocking the spreadsheet by clicking the ‘Review‘ tab on the Ribbon and clicking Unprotect Sheet and entering the password doughnut5 (hint hint).

 

Ribbon

Potential Future Enhancements

I’m considering adding the following columns on the ‘month’ sheets next to the amount (£) column:

  • Invoice #
  • Sent (date)
  • Paid (Amount £) – Colours Red (Unpaid), Orange (Partially paid), Green (Fully paid)

Colours of cells would change depending on invoice status, Sent, and Paid column.

Summarisation and Downloads

So, I hope you find this spreadsheet useful. I certainly do!

There’s a blanked out version to download below as well as one containing some sample data.

If you have ideas for improvements feel free to send a message via the contact page on this site, or via the Anything I.T. Facebook, or by directly emailing me: support@anythingit.net.

The files

Recording Hours Worked – with sample data.xlsx

Recording Hours Worked.xlsx

 

by Jonathan Jonathan No Comments

Who the heck are Anything I.T.?

We at Anything I.T. are certainly driven to succeed. We work hard to build business that can sustain a high level of client service and expertise.

Our expertise covers a wide range of technical knowledge and at a high level too.

But skills alone don’t cut it. The driving force behind building our business is:

“If we can help our clients grow, become more professional, be more efficient, and succeed; then we in turn will succeed.”

Jonathan (Founder)

Jonathan first got involved in the technical side of computing when his Uncle brought him a new PC back in 1994!

Unfortunately (or perhaps fortunately!), the PC was in pieces so Jonathan and his Uncle spent hours and hours putting it together, installing Windows 3.11 and troubleshooting problems (no Google in those days!).

Now, Jonathan is super keen on the ethos of working creatively (not competitively) with clients, and like-minded associates.

Check out his person blog at jonathanburrows.co.uk


Adam (Full Stack Developer)

With a fantastic First in Bsc Computing, Adam is a talented developer with web and data skills to die for.

Since finishing his degree, Adam has been eager to start new projects, learn new skills, and take his career one step further.

What does ‘Full Stack Developer’ mean to you our client? In a nutshell it means someone who can work on ALL things web. From the behind the scenes coding to the HTML that makes the actual visible page. Therefore, you can have faith that Anything I.T. area capable of working on your project, whatever your requirements.

Adam also loves football and coffee!


Alex (E-Commerce/Support)

Alex joins the team in 2019 and specialises in customer support, organisation, and setting up e-commerce online stores.

Alex has a history in retail and has recently set up his own gaming stream on Twitch.tv.

He brings an energy into the team that is freshening and full of belief that we can help our customers succeed.

It’s fair to say he picks up the pieces that others may miss.


Neil (Comtec ICT Services Ltd.)

Neil is our trusted associate from Comtec ICT Services Ltd. Comtec specialises in Internet and Telecomms solutions but with tremendous Computer Support and Training experience too.


You can find more about who the individual members of the team are on the About Us page.

For now, you can be assured that our technical and business experience will ensure a fantastic result for you and a great business relationship.

by Jonathan Jonathan No Comments

The Wonderful World of Workflowy

Workflowy is a productivity app (web and for phones). I love Workflowy and use it heavily when I want to ‘get things down “on paper”‘.

Workflowy is different to other productivity apps in that it’s all about Lists.

You create a List, then drill into the List to create sub-lists and so on.

What I like about it is the fact that you can focus on one specific list (or sub-list). You don’t have your screen cluttered with dozens of other related or semi-related lists or projects.

If you want to spend time thinking about what you need to do for your summer holiday, you can create a list (perhaps under a main list you created called ‘Personal’?) and focus just on that list. Maybe you will create sub-lists under ‘Summer Holiday’ of ‘Travel’, ‘Costs’, ‘Clothing’, and so on.

Perhaps you are an Under 19’s football coach? Well, why not create a list under ‘Personal’ called ‘Sports’. And inside that list one called ‘Under 19’s Team’. You could then focus on what needs to be done for that team by creating sub-lists for ‘Players’, ‘Matches’, ‘Practice’. You get the idea

Check out the video to see how it works!

Please let us know by email, Facebook Messenger or in the Comments any questions you might have.

stay informed!

Subscribe to receive exclusive content and notifications