No video
Create a Time Sheet - Google Sheets
Рет қаралды 27,353
Жыл бұрын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.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 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.buymeacoff...
#excel
#googlesheets
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~
@spudbud124 15 күн бұрын
Thank you, you just saved me a lot of work
@janicebarlatier2589 2 ай бұрын
Big help to a non sheets person. I was able to do my nanny payroll along with schedule!
@Pazeran Жыл бұрын
Oh man this channel is great! Need more Google sheets content asap!
@DougHExcel Жыл бұрын
Thanks!
@kattkaulitzz95 5 ай бұрын
had no idea how to add my internship hours, I used this video to create my own thank you so much! super helpful :)
@DougHExcel 5 ай бұрын
You're so welcome!
@KhadijahM97 9 ай бұрын
This has really helped me, thank you very much
@DougHExcel 9 ай бұрын
Glad it helped!
@jjgamesTS4 6 ай бұрын
I found this so helpful, thank you for a clear explanation!
@DougHExcel 6 ай бұрын
You're so welcome!
@PoshByDefault 4 ай бұрын
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?
@cameroncohen3351 3 ай бұрын
say you want all of column "g" you would write "=sum(g:g)" just remove the quotation marks and that function will do it for you
@bobedsall5625 Жыл бұрын
How about exporting weekly hours to compute payroll?
@stuttgart9000 6 ай бұрын
Looking for this, so sweet and well explained, ... thank you
@DougHExcel 6 ай бұрын
Most welcome 😊
@remedylivetraining 11 ай бұрын
What happens if you get negative numbers?
@user-ey1ow9te6r Жыл бұрын
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?
@edma06 7 ай бұрын
log all their hours and divide by 40
@abuamaar103 Жыл бұрын
how do i CHOE time as a format
@soluciones-termicas Жыл бұрын
What about your lunch break?
@cameroncohen3351 3 ай бұрын
as long as those times are recorded on the same sheet you can add up the "clocked out for lunch" with the "clocked in from lunch" together, and then take the sum of "clock in" and "clock out" and subtract that from the function in the video
@nextworldaction8828 Жыл бұрын
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.... :/
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 241 М.
SALEM EPISODES
Рет қаралды 841 М.
Code With Curt
Рет қаралды 29 М.