How To Create a Stop Watch in Google Sheets

Подписаться 6 тыс.

Просмотров 10 тыс.

50% 1

Create a Stop Watch in a Google Sheet. Start and stop time stamps, add up duration once you click. This is a sweet Google Sheet to make and you can see it step-by-step.
🔔 Subscribe for more free Google Sheets tips: ru-vid.com?...
🕰️ Time Saving Tips, Tricks and Techniques
bettersheets.co/topics
🤖 Add AI to Your Sheets
bettersheets.co/courses/adven...
🚀 Tools and Templates For YOU:
Generate Google Sheets Formulas:
bettersheets.co/google-sheets...
100 Free Business Ideas - Lead Magnet, product, and business ideas you can make in a Google Sheet to validate your business ideas.
Free at bettersheets.co/tools/100-bus...
Tiny Sheets - Easily delete unnecessary rows and columns
Free Add-on: tinysheets.bettersheets.co/
Sheet Styles - Change your spreadsheets style to match your mood.
Get it now: sheet-styles.bettersheets.co/
Atomic Sheets - 100 Spreadsheet elements you can add to your spreadsheets immediately.
30 free: atomicsheets.com/
Generate REGEXMATCH formulas to clean data
bettersheets.co/regexmatcher
Generate SPARKLINE formulas to make cool charts inside of cells.
bettersheets.co/sparkliner
😎 Most Popular Tips and Tricks
Extract Urls from Google Sheets
blog.bettersheets.co/extract-...
⚙️Automate Your Sheets:
Spreadsheet Automation 101, get started making your sheets work for you, while you sleep
Start Automating: bettersheets.co/courses/sprea...
Learn to Code in Sheets - A quick course to get you started on Apps Script. Coding in sheets makes automating your sheets so much easier!
Learn here: www.udemy.com/course/learn-to...
📺Step-by-Step Tutorials
Find EVERYTHING you need to make your spreadsheets better on my website BetterSheets.co
Disclaimer: Some of these links go to one of my websites and some are affiliate links where I'll earn a small commission if you make a purchase at no additional cost to you.

Опубликовано:

9 апр 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 37

@emilyzeigler4641 Год назад

Thank you for creating this video!! My dad has asked me to help him with his small business and I needed a free way to conveniently and accurately keep track of my hours. I've never used Apps Script, but it was so easy to follow along your instructions. I also like how you included your thinking process (and even mistakes!) in your final edit for this video -- it's very relatable and gives me hope that I can improve at my Google Sheets skills! This is one of the most helpful videos out there!

@BetterSheets 9 месяцев назад

Glad it helped!

@kendrastockton4698 9 месяцев назад

Thanks for this, it is so helpful! Now, I might be getting overly ambitious, but is it possible to put more than one stopwatch in a sheet by basically duplicating this code in with a different A1? Also, I would love to change the color of the "button" in addition to the start/stop as another visual reminder. I hope I can figure out how to do that without messing up the lovely creation you helped me make so far! You've inspired me.

@RogerClubv 3 месяца назад

Thank you! This is exactly what I needed.

@BetterSheets 3 месяца назад

Fantastic!

@zadolbalopridumivat 9 месяцев назад

that's really awesome

@BetterSheets 9 месяцев назад

You are awesome!

@nathancox6605 11 месяцев назад

It won’t save and gives me an error message sayin var is an unexpected token on line 14.

@BetterSheets 9 месяцев назад

where are you running the script from?

@SeanClarke 4 месяца назад

Where can we find written instructions for this? You go so fact I can't even tell what you clicked and can't possibly keep up to try and follow the video! Thanks!

@BetterSheets 4 месяца назад

Transcripts available here and on better sheets. Also the sheets are available for download for Better Sheets members.

@SeanClarke 4 месяца назад

@@BetterSheets thank you

@Hgames_RBLX Год назад

Nice! Also, is it possible to have the stopwatch run as a stopwatch on a phone (with decimals)?

@BetterSheets Год назад

Not in a live update kind of way. Maybe each minute can. With iterative calculations

@user-lx5qk3mn5s 9 месяцев назад

Does this only work with Workspace account?

@BetterSheets 9 месяцев назад

as long as you have google sheets... you can do it. in Apps Script. Every sheet has Apps Script. go to the menu: Extensions > Apps Script

@nazirafatxullayeva 8 месяцев назад

sorry can you help me When chescbox is enabled, the formula should stop working

@BetterSheets 5 месяцев назад

Try going through the whole video

@DJSemEvents 10 месяцев назад

Man, please slow down when you do your videos, how can anyone learn if you are speeding through the features in the video :(

@BetterSheets 9 месяцев назад

can't slow down the speed of the video? or pause?

@urbantekgames 9 месяцев назад

Usually, you'd be correct, however, I noticed at least one instance in your video above where I couldn't figure out what you'd done and that was because you didn't slow down and address it. Where you changed e.range.row to e.range.getRow. You made this change and then said it worked, however when you flashed back to the screen briefly I noticed you'd actually then added () at the end as well as adding .getColumn() and fixing the editColum var. For newbies, that can make it incredibly hard to follow your steps, especially if you're not providing the code in a document for them to access and you're expecting them to follow along. You might find for future videos that if you split your screen and keep your code on screen the whole time you're talking people following step by step can then slow down if required but can always view it. I really appreciate your efforts and this has been really handy however I did find following this extremely frustrating at times due to your speed and you editing out some of the changes you'd made. That said, keep up the great work mate.@@BetterSheets

@mikec9261 4 месяца назад

I just love when tutorial videos move at lightning speed. Might be good to know your audience. Just sayin.

@BetterSheets 4 месяца назад

Appreciate the feedback!

@kelseychemistry 7 месяцев назад

This is literally impossible to follow. Why not just show the code from top to bottom? You back track and refill old rows over and over

@BetterSheets 7 месяцев назад

Did you watch whole video?

@WhatKelsLoves 7 месяцев назад

Uh yeah. And then I asked AI. And it got it done in a fraction of the time with no back and forth.

@ImmZ69420 6 месяцев назад

I agree without a doubt

@user-cd6yn5ny7j 3 месяца назад

That's almost what I want to do, but so sad, that you didn't explain those functions and classes better. It's really hard for me to understand...

@Mike_0325 10 дней назад

Same thought. Just provided an idea but not how to really do it. So thumbs down for this video.

@user-cd6yn5ny7j 3 месяца назад

Why didn't you do that step by step? First one with the usual check box, without changing any start/stop labeles? After you've mixed different tasks in one code, it's almost impossible to follow your way of thinking and coding... for non professional, like me😢 I'm rewatching this video again and again and can't find the solve of my problem. I just need to add time without additing any new rows, labels and checking logs...

@BetterSheets 3 месяца назад

So you want to add time... based on a click?

@TrueOpinion99 11 месяцев назад

What if there's nothing in my "executions?"

@BetterSheets 11 месяцев назад

It may take a moment to show up or no executions even happened.

@Mike_0325 10 дней назад

After carefully reviewing your video, one thing I realized. You intend to mess up things because your intention is clearly not to teach at all but more on views so as others will rewatch your videos many times, and not really to be educational at all. Bad tactic. You deserve my thumbs down button.

@BetterSheets 9 дней назад

Thanks for the review.

@davidwatts2190 7 месяцев назад

Just did this in a fraction of the time with GPT.⌛ Create a button shape with Insert > Drawing. Click on the three dots by rolling over your new image and select assign script. Add this code (below)🔽🔽 and save. Job done! function startStopTimer() { const sheet = SpreadsheetApp.getActiveSheet(); const now = new Date(); const formattedDateTime = Utilities.formatDate(now, Session.getScriptTimeZone(), "MM/dd/yyyy HH:mm:ss"); const buttonCell = sheet.getRange("A1"); const buttonState = buttonCell.getValue(); if (buttonState === "Start Timer" || buttonState === "") { // Start the timer buttonCell.setValue("Stop Timer"); const nextRow = sheet.getLastRow() + 1; // Get the next empty row sheet.getRange("B" + nextRow).setValue(formattedDateTime); } else { // Stop the timer buttonCell.setValue("Start Timer"); const lastStartTimeRow = sheet.getLastRow(); sheet.getRange("C" + lastStartTimeRow).setValue(formattedDateTime); } }

@BetterSheets 7 месяцев назад

Not sure that is going to work for everyone.