Time Tracker Google Sheets: How to create an app using Google Apps Script

In this video, I will show you how to put together a time tracker to clock in and out multiple users using google apps script on google sheets.

Video, Code, and Documentation can also be found at:

[AdminAtlas]

Amazing, you just made my life easy to track hours for my employees without paying anymore memberships
THANK YOU SO MUCH

[tanveerhussain]

World's Best Teacher
Best Quality
Learn Easy and Understand
I Love And Like All Video

[ronmariani]

Brilliant and to the point !! Well Done Sir

[AG-qcek]

WAW COOL I'm a new cs student, 43 yo I'm much more excited!! thank you bro !!! :))

[Nate-ixmo]

Was looking for something like this, thank you!

[DevonTheInspiredFilmmaker]

This worked GREAT! This is exactly what I needed! Thanks for the tutorial!

[nitanew]

Great video...you are AWESOME!! Can you manually edit the time entry? For scenarios in which they begin work but forgot to clock in, thus need to adjust the time.

[eqsvyco]

Okay got this working... MOSTLY.... what about editing the clock in and out times? the total hours does not properly adjust

[kristinemoffett]

How did you get all the codes? I followed your video and don't know how you found them

[nurazizah]

Hi, I have implemented the code and it's awesome. I'm just wondering, I've tried several "test" and it goes until row 19, if I wanted to start using it, how to delete all of the previous data since it is not gone even though I deleted it. Waiting for your answer, thanks!

[Cloud-movv]

Can you add a code where the employees can see what time they need to return? Something like a 15minutes break tracker, and they need to clock back in before the 15minute break time

[chrissharpe]

When i fill out the rest of the sheet with formulas or drop boxes it resorts to the last cell is there anything i could change so it only focuses on A, B, C?

[centralcomputer]

i was try, but At Total Hour Not Replace, please Can you help me

[asramakiis]

how to change the total hours into minute ?

[kyleelizaespinoza]

Is there a way, that an employee can only click the In and out, only for his/her name?
and not for the other employee?

[biancalaroza]

how can set the code if i wanted my time stamp to be started on a specific column and with a column freeze from A to J. I wanted to start the Clock In and Out in Colum K onwards because columns A-J will be used for a different data and that is where i will freeze the column. i have data from A to J columns and rows, since we are using the lastrow script it will time stamp to the last row i used from A to J column but i wanted to record the time at the starting rows of columns K to Z. Can you help me?

[paconogara]

Is it possible to capture multiple "Start time and End Time" punches if the sheet is shared to multiple users using different devices/PC? Like for example user1 punches 1:00am then user2 punches his start time at 1:02am is it possible that their punches will be recorded at the same time?

[raimondas]

How to restrict to only one employee clocked in at any given time? Before next can clock in the active one needs to clock out.

[sarahgolder]

Mine just brings up apps script and then says clockin and clockout cannot be found

[mimitv]

Thank you so much :) but how can i show an error box that says OVERBREAK when you clock out and the result is beyond 45 mins. and it will also ask a question "Reason for overbreak:"