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!
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
Hi, Thank you so much for this video, I learned a lot. However, can I suggest that, if possible, make the "Go to current date" a button? instead of text only and clicking the hyperlink. Also Night Differential, eg. starting at 10pm until 6am, night differential would be calculated. Thank you, morepower
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 :)
Great video... very easy to understand, i've been looking for this for a while. Is there a way to easily select different pay rates tho? I work for multipul companies and they all pay different rates, also, I have minimum hrs contracts so I always get paid for 8 or 10 hrs depending on who I work for... which makes this a bit more difficult for me to follow. Thanks
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.
LOL Just figured out what he did.....for D5, at the 6:40 mark in the video.....Highlight Cell, command + C, then he pastes the value only by using shift + command + V. Clever!
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
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
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.
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"
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!
Thank you! This is lifesaver 😊
Happy to help!
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
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
Hi,
Thank you so much for this video, I learned a lot.
However, can I suggest that, if possible, make the "Go to current date" a button? instead of text only and clicking the hyperlink. Also Night Differential, eg. starting at 10pm until 6am, night differential would be calculated.
Thank you, morepower
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 :)
Great video... very easy to understand, i've been looking for this for a while. Is there a way to easily select different pay rates tho? I work for multipul companies and they all pay different rates, also, I have minimum hrs contracts so I always get paid for 8 or 10 hrs depending on who I work for... which makes this a bit more difficult for me to follow. Thanks
The best option is to make multiple tabs for each company. This will help with organization of your data
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.
I have the same issue.. hope he'll reveal .. I'm a new fun here.
Same here, @HashAliNZ any suggestions?
LOL Just figured out what he did.....for D5, at the 6:40 mark in the video.....Highlight Cell, command + C, then he pastes the value only by using shift + command + V. Clever!
That would be paste values only.
@@gueneverreeleserio3696 Yea, he pastes values only then is able to alter the time manually without typing on the formula
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
Yes this would be an amazing addition for tracking! I'll think on it!
Also, it's been asked before, but how do you manually type a time into D5 and keep your formula?
You can't. It's either manually entered data or a formula, not both
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
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.
Where did the emojis and shit come from?
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"