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
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
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 :)
A script will sort out the datetime. I was going to make a video just about recording static datetimes from a checkbox, but your comment made me realise it makes sense to include calculating the datetimes too. I'll add that to the to-do list. 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 could I go about rounding the duration to either 30 minutes or hour. Example: I finish a shift at 7:24pm, but want to round up to 7:30pm. Or I start at 7:14pm and want to round down to 7:00pm?
Hey! To round to the nearest half hour, use the mround function. So if the time is 7:24pm in cell B4, then you can use =mround(B4,"0:30") Here's an example: docs.google.com/spreadsheets/d/11SUacAEqCEPqyhxGzjSDlFXCjDaeXj5FihOWwKAdfdI/edit?usp=sharing Just be aware, though, that in many places rounding time can be illegal if it disadvantages the employee. Check out your local laws to see if that applies to you. Good luck 👍🏼👍🏼
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!
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
You are brilliant. Thank you for the video. It would be perfect if added several workers, instead of just one
Thank you! This is lifesaver 😊
Happy to help!
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!
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 :)
Is there a way to automate the CTRL+C CTRL+SHIFT+V process for the dates and time?
A script will sort out the datetime. I was going to make a video just about recording static datetimes from a checkbox, but your comment made me realise it makes sense to include calculating the datetimes too. I'll add that to the to-do list. 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
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
How could I go about rounding the duration to either 30 minutes or hour. Example: I finish a shift at 7:24pm, but want to round up to 7:30pm. Or I start at 7:14pm and want to round down to 7:00pm?
Hey!
To round to the nearest half hour, use the mround function. So if the time is 7:24pm in cell B4, then you can use =mround(B4,"0:30")
Here's an example:
docs.google.com/spreadsheets/d/11SUacAEqCEPqyhxGzjSDlFXCjDaeXj5FihOWwKAdfdI/edit?usp=sharing
Just be aware, though, that in many places rounding time can be illegal if it disadvantages the employee. Check out your local laws to see if that applies to you. Good luck 👍🏼👍🏼
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"