How to Build a Time Sheet in Google Sheets from Scratch

[@HashAliNZ]

There's a lot of tips and tricks scattered all throughout this build! Which is your favourite? Check out www.SheetAnalysis.com for help building, fixing, and auditing your spreadsheets!

[@emilygray9868]

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 :)

[@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

[@michaelsglas]

Select on the column where your date is and click on format. From there select Date and Time Format and select the format that best suits your needs

[@louiseandersen4353]

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.

[@user-ej8st5fl9p]

I have the same issue.. hope he'll reveal .. I'm a new fun here.

[@lca85]

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

[@HashAliNZ]

Yes this would be an amazing addition for tracking! I'll think on it!

[@Kartik.0m]

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

[@HashAliNZ]

If you followed the tutorial it shouldn't change in your sheet. The example I showed iny videos might change because I film over several hours and sometimes days and make changes as I go before cutting it down in editing.

[@shaanmihaka]

Where did the emojis and shit come from?

[@HashAliNZ]

For the in-text emojis, start typing in a cell and hold the Window Key and press the full stop (period) key. If you're a Mac, I have no clue. This opens up the emoji and symbols options. For the ones I switched out, I have no clue where they came from. Just typed into Google "Stop emoji" and "Pause emoji"