How to Build a Time Sheet in Google Sheets from Scratch

This tutorial is perfect for freelancers, contractors, or anyone looking to easily track their work hours using Google Sheets. It guides you through creating a professional-looking time sheet that works both on a computer and phone. You'll learn how to format your sheet, input your work times, and use formulas to calculate hours worked, including overtime.

The video covers advanced tips like setting up conditional formatting for a cleaner look and how to make your time sheet automatically adjust to the current date for easy tracking. Whether you're a spreadsheet expert or a beginner, this tutorial offers valuable insights into managing your work time more efficiently with Google Sheets.

All Products and Gear Mentioned in this Video:
Excel Software
Google Sheets

🔗 Subscribe to Our Channel for More Excel and Google Sheets Tips:

WORK WITH ME:

DISCLAIMER
This video is not sponsored. Some product links are affiliate links which means if you buy something we'll receive a small commission.
----------------------------------------------------------------------------------------------------
⏳ TIMESTAMPS
----------------------------------------------------------------------------------------------------
0:00 Intro
0:24 Part 1
3:06 Part 2
8:44 Part 3
14:42 Part 4
20:59 Part 5
23:42 Part 6
----------------------------------------------------------------------------------------------------

💬 GOT A QUESTION?
↓↓↓ Leave a comment down below ↓↓↓

[HashAliNZ]

There's a lot of tips and tricks scattered all throughout this build! Which is your favourite?

[andreaguerri.educational]

thanks so much for your simple example... but I have a problem displaying the date in the format like in your video at 28:55. To me it shows this view 44562 - 44568. What's wrong? Thank you

[ianssix]

Great video... very easy to understand, i've been looking for this for a while. Is there a way to easily select different pay rates tho? I work for multipul companies and they all pay different rates, also, I have minimum hrs contracts so I always get paid for 8 or 10 hrs depending on who I work for... which makes this a bit more difficult for me to follow. Thanks

[emilygray]

Hey, for when you select current date, can you instead ask it to return certain drop downs?So could I chose which drop down I want and then it just return those? Thanks :)

[louiseandersen]

How can you manually edit the date/time on start/end, when you have a formula to add the timestamp?
When I try to do it, I can only edit the formula, and not the actually timestamp.
Hope it makes sence.
BTW I love your video.

[lca]

I really love this video. Thank you for doing it.

However, I have a wish.
It would be very useful if you could make an addition where you can register sick days, holidays, closed days and the like.
I live in Denmark, and often we get the same "salary" on sick days and vacation days, but it might be good to be able to register these days anyway.
With best regards
Louise

[ianssix]

Also, it's been asked before, but how do you manually type a time into D5 and keep your formula?

[Kartik.m]

I really very much appeciating your Start and End Time is Updating in every 5 minutes then how come it is a perfect Time is changing always...which results whole sheet with errors...please look into it

[shaanmihaka]

Where did the emojis and shit come from?