time tracker using google sheets / google app script

[@PierpaoloLucidi]

This solution is genius, thank You very much!

[@Codician]

Thank you 🙏

[@aljonmanahon5974]

Thank you so much and God Bless

[@jadenataylor]

It works, thank you!

[@Codician]

Thank you for your wonderful feedback. Appreciated !!

[@romanacvn]

finally one that works 👍

[@Codician]

thank you

[@ycreations5267]

Great effort

[@Codician]

thank you

[@DeepGill-dl3wj]

Thank you dear but what is that scripts which you have in your macro "edit script"? From where I can copy those 🤔

[@Codician]

you can get more info in description . or this has been moved to Add-On , where you dont need to do anything - just install the addon kzbin.info/www/bejne/kH-mpqeVpZaDb6s

[@dnawied]

Is there a way to add/sum time records for a grand total and or a total per case number?

[@Codician]

try this timetracker.dlohia.com/

[@joshuapolicarpio8807]

Hi this is a great video and this is what I am looking for. May I ask the EXACT CODING you used? So I am able to copy and past it ??

[@Codician]

yea , go ahead :)

[@jfayea7430]

This is very useful! Thank you! Just used this format!❤👍🤘👏

[@Codician]

thank you

[@joshuapolicarpio8807]

Hi JFaye.. could u send here the code ?please and thank u

[@Drones483]

How do i get the code?

[@paconogara6527]

Is it possible to capture multiple "Start time and End Time" punches if the sheet is shared to multiple users? 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?

[@Codician]

Create two sheets

[@gavincalder6652]

Great Video. This is just about everything I was looking for. I am trying to make a stopwatch for a swim race where all of the swimmer start at once and then stopping them at different times as they finish? Thank you for your video and help

[@Codician]

thank you , i hope you found a solution by now.

[@fordakot8591]

How to publish for my staff in remote area to click?

[@Codician]

Share sheet option of google

[@Masterblaster416]

Great video! Can this be done on MS Excel?

[@Codician]

Yes check time tracker in my playlist

[@vishalpatil4676]

@@Codician - can you please share link, i didn't find

[@biancalaroza7732]

Hi, this is really helpful. but can you help with this? how can i set or define where i wanted to add a record to a specific cell? lets say, i wanted to start adding the time stamp to row 7 column A? how can i do that?

[@Codician]

I hope it's working by now . there are new changes done on the tool you may reinstall and try . thanks

[@dannygarcia4573]

Thank you so much for this!!

[@Codician]

I am glad that it helped 🙏

[@adorablemollyperkins79]

This is awesome! How do i add it for multiple tabs in the same sheet. So I have sheet a, sheet b and sheet c....

[@Codician]

Grenezza Jeanne Tiongson that will b next automation currently you can merge ms excel files , check my playlist

[@Dyown1]

Thank you sooo much! You helped me a lot! 😊

[@Drones483]

How do i get the code?

[@Codician]

thank you 🙏

[@Codician]

❤ you can find code behind on github.com/deepaklohia ❤

[@rahulnaik9536]

Hi Deepak thanks for such a great video and contribution, but I see time and date not the same specific to my country so should i do anything else to get the exact time and date relative to my country!!

[@Codician]

you can change the time in the settings . more info timetracker.dlohia.com/

[@ishwarjaiswal3361]

Hi. Can you pls tell me what codes u have entered for start, split, stop and end

[@Codician]

Its a google addon now

[@ishwarjaiswal3361]

Hi. So if mujhe abhi ye bnana hai then from where i can get the formula

[@Codician]

Excel P 😝

[@ishwarjaiswal3361]

@@Codician pls explain.. As I need to build it.

[@ronventocillo2660]

Hi, What code and where I can insert it to your codes that show a total?, just like you extension add-on in google sheet. BTW Its a great video.

[@Codician]

thanks , there is a total button already on the latest addon published.

[@ronventocillo2660]

@@Codician Hi, I just want to use the manual version in googlesheet. I want to create my own button. but in your tutorial it doesn't have a caculate total. Thank you in advance

[@hnag1907]

Thanks for sharing. How can I change it to show date and time?

[@Codician]

Select the column and change format

[@jyokumaryash1390]

Wow Sir Excellent. . . I'm owing to You . . . Excellent Sir . . . Every 5 Minutes data update is possible sir ??? Please reply sir . . .

[@Codician]

I hope you have found the solution by now . more info timetracker.dlohia.com/

[@raishamaesape6135]

Hello, the code works perfectly; however, I'd like to protect rows B-D so that no one can change the value. Do you have any code for it? Thank you so much!

[@Codician]

if we protect it might stop the tool from entering data. i will keep that as a suggestion for the next built. support.google.com/docs/answer/1218656?hl=en&co=GENIE.Platform%3DDesktop

[@prakashsharma5225]

Thank you bro .. it's very helpful for me , one more thing I want to ask you how can sum all the defference I'm getting error while sum them bzc it is in text format and I'm unable to change it into duration .. plz plz reply my comment

[@Codician]

prakash sharma i am not sure where exactly u r getting error . just google “google script char to int” if its a cell then use if error

[@prakashsharma5225]

@@Codician I want to sum the Time difference but not able to do it can you help on that ??

[@Codician]

Time2 - time1 and format as time (google time format in google sheet)

[@jadevillanueva2074]

Hi where can I copy the functions please I've tried to follow on the video but cant follow the functions.

[@Codician]

this sheet creates its own formulas . you can see what all gets clear and then use ur functions accordingly

[@ayk8692]

it does not work on my google sheets..even though I followed exact steps and exact same codes..does anyone know why?

[@Codician]

I hope it's working by now . thanks

[@tradewithsahani]

How to stop macro? My macro running automatic in every 1 minute. But I don't know how to stop this macro.

[@Codician]

It should not. Try classic version on same page of google sheets addon.

[@jomarapostadero5957]

Hello, can you share the exact coding to me please? I find this very helpful and tried to re-create but it's giving me error and won't let me save. feel like I messed up in one of the lines. Thanks!

[@Codician]

❤ you can find code behind on github.com/deepaklohia ❤

[@sangeetaingle9818]

Hi, could you share the time & motion script in here,please? as I am unable to GitHub with your name

[@Codician]

have a look at github you may get ideas there

[@neelamgrg4196]

Can u pls share the code that u using

[@Codician]

you may look at the git hub you can get some code idea over there.

[@khushalsarafe6374]

thanks! .... where do I found code??

[@Codician]

❤ you can find code behind on github.com/deepaklohia ❤

[@srfudhaya]

Sir, How to use this function on mobile

[@Codician]

not sure if google supports that on mobile . you can try on browser

[@vishalpatil4676]

Hi- Can i get this code for VBA macros?

[@Codician]

You can check time and motion tracker on github under my name

[@Drones483]

Can't find the code

[@Codician]

❤ you can find code behind on github.com/deepaklohia ❤

[@jorgemendoza5403]

Great job, but can i get the code ?

[@Codician]

❤ you can find code behind on github.com/deepaklohia ❤

[@nikkicamba2422]

This is really helpful. Can you send me the code as well? Thank you so much! ❤❤

[@Codician]

❤ you can find code behind on github.com/deepaklohia ❤