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.
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!
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?
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?
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?
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
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:"
I want the output of hours to be in a duration format or hh:mm:ss how do I do that, I trie changing .setNumberFormat("#0.00") to .setNumberFormat("hh:mm:ss") but its giving me an incorrect total of hours
Below is the replacement code to get HH:MM:SS For Function clockOut() var totalTime = (mainSheet.getRange(j,3).getValue() - mainSheet.getRange(j,2).getValue()); mainSheet.getRange(j,4).setValue(new Date(totalTime).toISOString().substr(11, 8));
For Function TotalHours() var rate = mainSheet.getRange(j, 3).getValue() - mainSheet.getRange(j, 2).getValue(); mainSheet.getRange(5+i,7).setValue(new Date(totals[i][1]).toISOString().substr(11, 8)).setFontSize(12);
@@CodeWithCurt I tried this replacement, but it turned out that the "starting interval line is too short" In the cell of hours, the time appears correctly in the format hh: mm: ss, but in Total Hours nothing appears in the name of the cell to the right of it
@@CodeWithCurt Hello Sir, good day.. do you have codes for In and Out but will be reflected on the column H (In), column I (Out), column (J) for calculated duration of time (h:mm:ss)?? please help. this is my assignment. I would like to change the reference to column C (instead of column B1). thank you so much...
Good day, Sir, why is the script won't add a new record every time it read on this part? and sometimes it takes more than a minute running the script. // ADD CLOCK IN RECORD mainSheet.getRange(lastRow+1,1).setValue(mainSheet.getRange('B1:B1').getValue()).setFontSize(12); mainSheet.getRange(lastRow+1,2).setValue(new Date()).setNumberFormat("MM/dd/yyyy hh:mm:ss A/P").setHorizontalAlignment("left").setFontSize(12);
Amazing, you just made my life easy to track hours for my employees without paying anymore memberships
THANK YOU SO MUCH
World's Best Teacher
Best Quality
Learn Easy and Understand
I Love And Like All Video
WAW COOL I'm a new cs student, 43 yo I'm much more excited!! thank you bro !!! :))
Brilliant and to the point !! Well Done Sir
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.
Did you ever figure this out? When I edit the time the total hours dont adjust properly
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!
Google Apps Script Code used in Video Below:
function clockIn() {
//DEFINE ALL ACTIVE SHEETS
var ss = SpreadsheetApp.getActiveSpreadsheet();
//DEFINE MAIN SHEET
var mainSheet = ss.getSheetByName("MAIN");
//LAST ROW ON MAIN SHEET
var lastRow = mainSheet.getLastRow();
for (var j = 5; j
copied and pasted this but im getting this error
TypeError: Cannot read property 'getLastRow' of null
Exactly what I was looking for.
Was looking for something like this, thank you!
Okay got this working... MOSTLY.... what about editing the clock in and out times? the total hours does not properly adjust
This worked GREAT! This is exactly what I needed! Thanks for the tutorial!
Hello, can u please help me with the code
Please Help! I don't know what to do next.. this is the error after I run the codes..
TypeError: Cannot read property 'getLastRow' of null
@@brig9087 hi! did you resolve yours? i just tried it now and got the same result. what did you do to fix it?
How did you get all the codes? I followed your video and don't know how you found them
same problem
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?
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?
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?
It works in a smart phone with the app of google sheets?
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
Can it handle days count also means if out time in next day ...if yes please update...
what if I wanted to separate the date and time? That would result in totals the name and time and the total accumulated hours?
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:"
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.
kindly help me out, it keeps saying that the lastRow is not define, line 12 base on your turial. what should i DO?
if you know how plz tel me
Name your sheets exactly like the video and also the pages
Has anyone gotten this to work on a tablet or mobile with the sheets app? OR does this have to be run on a desktop/laptop?
i was try,but At Total Hour Not Replace, please Can you help me
how to change the total hours into minute ?
how to change the timezone?
Mine just brings up apps script and then says clockin and clockout cannot be found
do you have a link to a template??
Quick question, to clear all the information, just delete the boxes?
Yes to start over just clear the google sheet cells
If the script concatenates time values instead of summing them. Where can be an error?
One subscribe from Indonesia
Hi ,
I have typeError
Cannot read property 'getlastrow' of null
Name the sheet and pages exactly as in the video
Kindly share the functions? 😊
Posted Code in Comments
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?
Yes, adjust the code to enter id & password
Can you post the code in the comment plz
Hi can anyone share the code? It's not in the comment. TIA for the reply 😊
On the RHS top there is a button "Share" Click there and send
I typed everything. But getting "typeerror : cannot read property 1 of undefined. "
Please help
Posted Code in Comments
WHY can't I find what in excel
why is the total hours not summarized, even though the code entered is exactly the same, thank you
I want the output of hours to be in a duration format or hh:mm:ss how do I do that, I trie changing .setNumberFormat("#0.00") to .setNumberFormat("hh:mm:ss") but its giving me an incorrect total of hours
Below is the replacement code to get HH:MM:SS
For Function clockOut()
var totalTime = (mainSheet.getRange(j,3).getValue() - mainSheet.getRange(j,2).getValue());
mainSheet.getRange(j,4).setValue(new Date(totalTime).toISOString().substr(11, 8));
For Function TotalHours()
var rate = mainSheet.getRange(j, 3).getValue() - mainSheet.getRange(j, 2).getValue();
mainSheet.getRange(5+i,7).setValue(new Date(totals[i][1]).toISOString().substr(11, 8)).setFontSize(12);
@@CodeWithCurt I tried this replacement, but it turned out that the "starting interval line is too short"
In the cell of hours, the time appears correctly in the format hh: mm: ss, but in Total Hours nothing appears in the name of the cell to the right of it
@@RaneeA dit you manege to fix this problem?
@@CodeWithCurt Hello Sir, good day.. do you have codes for In and Out but will be reflected on the column H (In), column I (Out), column (J) for calculated duration of time (h:mm:ss)?? please help. this is my assignment. I would like to change the reference to column C (instead of column B1). thank you so much...
Drop down not working on Mobile device
where is the coding?
Where is the Code??
IDK y i get getlastrow error like i did everything to the letter
I did the same and I caught an error on line 12. Couldn’t figure it out.
Name the sheet and pages exactly as in the video
Can you do an app version ? Will pay for it:)
do you still need?
Good question
man its not working
I hope he shares the code so we don't have to type everything
I typed everything. But getting "typeerror : cannot read property 1 of undefined. "
Please help
I typed everything. But getting "typeerror : cannot read property 1 of undefined. "
Please help
@@akashtakvani4864 had the same error too
Syntax Error
@@noeme17 what will next if u can help me
Code not shared :( too much disappointed.
Posted Code in Comments
@@CodeWithCurt I couldn’t find it 🥺
Good day, Sir, why is the script won't add a new record every time it read on this part? and sometimes it takes more than a minute running the script.
// ADD CLOCK IN RECORD
mainSheet.getRange(lastRow+1,1).setValue(mainSheet.getRange('B1:B1').getValue()).setFontSize(12);
mainSheet.getRange(lastRow+1,2).setValue(new Date()).setNumberFormat("MM/dd/yyyy hh:mm:ss A/P").setHorizontalAlignment("left").setFontSize(12);
Hi. How fix total hours? if gigured this: 0.000.010.000.04
Thanks for script
do you have a link to a template??