How to Calculate Hours Worked In Google Sheets

  Рет қаралды 46,358

Hash Ali

Hash Ali

Күн бұрын

Пікірлер: 57
@hempgeneration
@hempgeneration Ай бұрын
I like the way he shows his logical thinking progress and advances to newer and better thinking
@HashAliNZ
@HashAliNZ Жыл бұрын
Follow along with the spreadsheet used in this tutorial ➡docs.google.com/spreadsheets/d/1b8vW2_zeVjV-JQyHWrK7_mFkZLr4H3fVlNIpUFpyjL8/copy
@Amphiartstudio
@Amphiartstudio 2 ай бұрын
This was incredibly helpful and the first time I didn't hardcore struggle with formulas, thank you!
@HexdTwilight
@HexdTwilight 2 ай бұрын
I really appreciate and like your methods of explaining the process. My favorite part was how you would put the keybinds to quickly do that action on screen.
@andrewnewcombe1908
@andrewnewcombe1908 11 ай бұрын
Ive been trying to sort adding time for days. Youve just nailed it in five minutes
@HashAliNZ
@HashAliNZ 10 ай бұрын
Perfect!
@witwi_connor
@witwi_connor Жыл бұрын
Thank you, this was so helpful! I never considered using an inequality to get around the negative numbers.
@AlejandroWu-s8w
@AlejandroWu-s8w 8 ай бұрын
Hey brother this is great! I have a question tho, during every shift my employees take 30min brakes and sometimes when they do double shifts their brake is for 60min, how do i add it into the formula so it understand when it goes over 8h of work it needs to substract 60min pauses and when it's below 8h it substracts 30min from the total of hours worked. thanks !!
@Hawk2phreak
@Hawk2phreak 8 ай бұрын
Can you make a personal budget sheet that deals with multiple revenue streams and compares it to a set of budget targets etc? I'm new to sheets in any meaningful way and the way you lay forth your content is masterful!
@luisashambo4087
@luisashambo4087 2 ай бұрын
Simplicity and amazingly helpful!
@corksstrokes9970
@corksstrokes9970 Жыл бұрын
This was excellent, but when you got to the last page with all the workers on it and the delimiter....you broke my brain! LOL
@HashAliNZ
@HashAliNZ Жыл бұрын
Yeah that part is advanced and takes a lot of work to get you're head around it all. I like to think of the textjoins and splits as 'wrappers' around what we already have. You might've noticed we create our formula, then 'wrapped' the formula we created in the textjoins and the split. It takes some getting used to, but try to break apart the formula like an onion - read the innermost part first (inside the innermost brackets) and work your way outwards.
@corksstrokes9970
@corksstrokes9970 Жыл бұрын
@@HashAliNZ Thank you. Even just the first part is saving me hours of work each payday!
@Moirahwimmer
@Moirahwimmer 7 ай бұрын
This video is very easily understood!! Thank you!
@HashAliNZ
@HashAliNZ 6 ай бұрын
You're very welcome!
@Redearedslider
@Redearedslider 8 ай бұрын
Thanks! Very clear explanation.
@PGhai
@PGhai 6 ай бұрын
👏Thanks for creating shot and cut to point video
@BaiMalehaEsmael
@BaiMalehaEsmael 15 күн бұрын
Amazing video. TYSM
@HashAliNZ
@HashAliNZ 13 күн бұрын
You are so welcome!
@BxWorkstation
@BxWorkstation Жыл бұрын
Amazing, you should be one of Google Sheets programmers :D
@HashAliNZ
@HashAliNZ Жыл бұрын
Thanks so much for the kind words!
@themanagement69
@themanagement69 7 ай бұрын
Super helpful bro. Subbed
@pierrebertram5555
@pierrebertram5555 10 ай бұрын
Thanks for the video, very useful.
@KitKat-is5qg
@KitKat-is5qg 9 ай бұрын
Thank you so much for this!
@TheNaturalFarmerNOFA
@TheNaturalFarmerNOFA 9 ай бұрын
SO HELPFUL!!
@LBird7299
@LBird7299 11 ай бұрын
Thanks for the easy Guide!
@HashAliNZ
@HashAliNZ 11 ай бұрын
Glad to help!
@RachaelGoodwin-on7yh
@RachaelGoodwin-on7yh 6 ай бұрын
very helpful, thanks
@thomassand7520
@thomassand7520 2 ай бұрын
I still is having problems with my simple calculation. But with you it looks so easy. 🙂
@HashAliNZ
@HashAliNZ 2 ай бұрын
Copy and paste the formula and I can try figure out the issue
@thomassand7520
@thomassand7520 2 ай бұрын
@@HashAliNZ My google sheets is just in this case driving hours for July 2024. So a line per date in July 2024 (31 lines, as we have 31 days in July 2024). I have created the same formula as you have shown for each of the days (some days the total drive time is 0, because I was not working). BUT the issue is when Iwas to SUM up all 31 days to see how many hours I have been working totally per month. When I make the sumup I get the issue, and cannot make it work. I want to make the sum of F3 to F33. Like you in your video (Time stamp 3:45 in your video). Each cell from F3 to F33 (F coloum is the total hours) and is formatted as "Duration" and each cell has this formula [(=E3-D3+(D3>E3)]. D is start time and E is stop time. My sum formula is looking like this (=SUM(F3:F33), i have tried many different versions, but none has worked. Also "arrayformula" ect., but cannot make it work. In this case it come with a result 5,69 total hours, but it should be 148 hours with is the correct number. If you can tell me what my errror is, or how to solve this you will become my Goolge Sheets NINJA 🙂
@thomassand7520
@thomassand7520 2 ай бұрын
@@HashAliNZ In my sheet the column D is start time and E is ending time: Line 3 to 33 is all the 31 dates of the month (July 2024). Column F is the total daily hours where I have made the formula as per your video: =E3-D3+(D3>E3) My issue is that II am trying to calculate all the hours for the month, here my formula is per your video (timestamp 3:34) =SUM(F3:F33) I have tried many different versions (including arrayformula), but I will not be correct. The correct number is 148 hours, but in this case the result is 5.69. All the cells in between F3 and F33 is all formatted as “Duration” Do you need any other info? If you can solve this you will be my Google Sheet NINJA 🙂
@HashAliNZ
@HashAliNZ 2 ай бұрын
Is the sum formatted as a duration too?
@KellyRoberts-uy3wj
@KellyRoberts-uy3wj Жыл бұрын
I use software that exports time in the following format, but cant figure out how to tally it. 18h 56m 25s 1d 15h 30m 17s 11h 32m 35s 22h 44m 19s 1d 8h 1m 44s 1d 9h 30m 9s 1d 18h 34m 10s
@momokola6411
@momokola6411 Жыл бұрын
Is there a way to format the minutes to show up as decimals? Like rather than 10:30(duration) it would be 10.5
@pierrebertram5555
@pierrebertram5555 10 ай бұрын
In the case of the cell E3 you could use in an other cell =HOUR(E3)+(MINUTE(E3)/60) + (SECOND(E3)/3600)
@SheebaShezneen
@SheebaShezneen 24 күн бұрын
How can I calculate overtime in that type of data overtime of employees
@DanceAway152
@DanceAway152 4 ай бұрын
Is there a way to calculate into 2 separate columns - One shows regular hours worked so anything 8 hours or less, and the other showing overtime hours (the amount of hours over 8) - using the start and end times?
@HashAliNZ
@HashAliNZ 4 ай бұрын
Yeah, one way is shown at 9:36 of this video, or another method (well say method but different layout) is shown here: kzbin.info/www/bejne/aJfMo4ysht6irLMsi=EKfmCfn0d-p12xWO
@sweetmask1690
@sweetmask1690 5 ай бұрын
Hi! If 8:11pm - 5:00 am is 8.49 hours how can I make it to exact 9 hours? And how to calculate night diff from 10:00PM - 6:00Am if the employee enter to 1:00am to 10:00am Please
@HashAliNZ
@HashAliNZ 5 ай бұрын
For the first question, you can use the ROUND function or the ROUNDUP or the MROUND. Totally dependent on the way your workplace works, just make sure you're not breaking laws by short-changing your employees (a few people I've helped out didn't realise that in many jurisdictions rounding timesheets comes under wage theft and the company can be penalised very heavily). For the second question, I'm not sure what you mean. 10PM - 6AM should give you 8 hours as shown in the video, and 9 hours for 1AM - 10AM. If they are two different shifts in the same day then they should be entered on different rows.
@sweetmask1690
@sweetmask1690 5 ай бұрын
@@HashAliNZ how can i get the night shift differential of 1:00am to 6:am using google sheet formula sir?
@HashAliNZ
@HashAliNZ 5 ай бұрын
Let's say 6am is the end time and is entered into D5, and 1am is the start time and is entered into C5. Then it would be simply =D5-C5 The result will give you 5AM, so go up to the Format and change the format to Duration instead of Time.
@sweetmask1690
@sweetmask1690 5 ай бұрын
@@HashAliNZ hi sir thank you for your response Can i ask one more pls. I need it so much. How to combine the formula stated on the video and the formula that you’ve been said to me now? Thank you so much for your upcoming reply
@MusicGirl114
@MusicGirl114 Жыл бұрын
Hello, quick question. I am trying to calculate my wage per hour x my total number of hours worked in Google Sheets. I am using this formula: =C2*B2. It keeps giving me the wrong number. I'm not sure why. Thank you.
@HashAliNZ
@HashAliNZ Жыл бұрын
Hi Erin, I'm guessing it's because your hours are written as hours and minutes. You first need to change it to decimal hours. Check this video for how: kzbin.info/www/bejne/noLCZ5V6f8SWhrc The pertinent info is at about 3:10
@MusicGirl114
@MusicGirl114 Жыл бұрын
@@HashAliNZ Hello, thank you for your response. My apologies, but I still do not understand. Do I use the HOUR, MINUTE, and SECOND Functions to do this? Is there a way to quickly convert my time to decimal hours? I'm not the best at math. Thank you for your help.
@mindful2897
@mindful2897 5 ай бұрын
thanks
@renzgiocapulong454
@renzgiocapulong454 7 ай бұрын
Hello! How can you compute for the average hours worked?
@HashAliNZ
@HashAliNZ 7 ай бұрын
In the last section I show how to do the analysis showing the SUM of the values. In the pivot table sidebar, simply change SUM to AVERAGE and it'll do it for you!
@khunaung_ca
@khunaung_ca Жыл бұрын
thank you
@HashAliNZ
@HashAliNZ Жыл бұрын
You're very welcome
@dream71it
@dream71it Жыл бұрын
❤❤❤great❤️
@ShubhamSharma-gh1pq
@ShubhamSharma-gh1pq Жыл бұрын
Helped a lot brother... Keep it up
@HashAliNZ
@HashAliNZ Жыл бұрын
Thanks so much Shubham!
@ross3131
@ross3131 Жыл бұрын
Hey there, i need some help with redoing my sheet, having difficulty when it comes to adding up the total hours. think you could help me out ? do you have discord?
How to Build a Time Sheet in Google Sheets from Scratch
31:00
How it feels when u walk through first class
00:52
Adam W
Рет қаралды 26 МЛН
Wait for it 😂
00:32
ILYA BORZOV
Рет қаралды 7 МЛН
VAMPIRE DESTROYED GIRL???? 😱
00:56
INO
Рет қаралды 9 МЛН
How to Free up Google One (Drive) Storage
18:31
dottotech
Рет қаралды 237 М.
Google Sheets - Timesheet, Formulas, Time Calculations - Tutorial
31:04
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 243 М.
How to Calculate Hours Worked in Excel (Midnight Span)
5:07
Excel Tutorials by EasyClick Academy
Рет қаралды 276 М.
Create Free Staff Tracking Attendance with Scanning QR Code
15:52
How to Calculate Hours Worked in Excel
3:26
TEKNISHA
Рет қаралды 604 М.
Google Sheets - Timesheet, Overtime, Holiday Hours, Logical MAX & MIN Functions
22:11
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 38 М.
10 HIDDEN SECRETS of Checkboxes in Google Sheets!
17:33
Hash Ali
Рет қаралды 23 М.
How it feels when u walk through first class
00:52
Adam W
Рет қаралды 26 МЛН