Create a Time Sheet - Google Sheets
Вставка
- Опубліковано 8 лис 2022
- Do you track time sheets for people? Want a quick way to track and add up hours worked? Also want to be able to share or collaborate on the sheet?
A good solution is to use Google sheets. The calculations are easy to do, and the sheet is all in the “cloud” and easily shareable.
I’ve cover two ways you can track time spent either in decimals so you can multiply by some rate like 10 bucks and hour. Or you can get the time spent in duration like 8 hours 10 minutes.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to
www.buymeacoffee.com/dough
#excel
#googlesheets
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~
Big help to a non sheets person. I was able to do my nanny payroll along with schedule!
Oh man this channel is great! Need more Google sheets content asap!
I found this so helpful, thank you for a clear explanation!
had no idea how to add my internship hours, I used this video to create my own thank you so much! super helpful :)
This has really helped me, thank you very much
How about exporting weekly hours to compute payroll?
What happens if you get negative numbers?
how do i CHOE time as a format
Looking for this, so sweet and well explained, ... thank you
How do you autofill the entire column - not just the boxes that have values? Does this not mean we have to manually drag from the top box after every single entry?
I need to track accrual of sick time for employees based on actual hours worked. For every 40 hours worked, they accrue 1 sick hour. How do I do this in google sheets?
What about your lunch break?
Ugh... Not really explaining things here. Way too fast and not breaking it down. Quite frustrating actually. I guess you're expected to already know how to do the other things that are in the sheet when you start.... :/