Please tell me, do I explain everything clearly in my lessons? Write your suggestions that would help improve the quality of the material. To support the author financially - www.donationalerts.com/r/semyon_solomin. Thanks
@goodmorningUG
Жыл бұрын
Where did you get the number 8 you put on calculating number of hours worked at the end of formular?
@baileyelliott7277
8 ай бұрын
Yes, thank you
@bcatcher
8 ай бұрын
When I try to copy all cells to make table, all cells turning into employee .
@zdzislawkes
7 ай бұрын
I don't know what to write. Maybe I'll start with my practice. Such or similar statements are often sent to me to make an analysis of wage costs, absenteeism or something similar. It is difficult and complex because someone does it according to what you show in the video. Why is this happening? it is simple. you have connected the data source to its presentation. Please note that there are many people willing to imitate this. If someone needs records of working time, a table with 5 columns is enough: surname and first name of the employee, date of arrival at work, start time, end time, comments. Presenting data, calculations and analyzes is easy if the input is simple tables.
@rwfrench66GenX
7 ай бұрын
@@goodmorningUGthe employees work 8 hours a day. The formula is adding up how many hours they worked. It doesn’t include sick time or vacation time.
@blueskyguy1
7 ай бұрын
Very clear and can be duplicated. If possible create a schedule tutorial that lists multiple locations that an employee would work at, for example : Employee A works at location 123 on Mon and Tuesday and location 567 on Wed, etc
@laxmandissanayake9659
16 күн бұрын
thank you for much. i learnt something new today. All the best.
@akatsukimoonlxrd
11 ай бұрын
the clam river flow sound in the background is really peacefull thanks
@pradeepielts
6 ай бұрын
Thank you! No one has explained it as simple as this! Keep it up...👍
@user-it4sp3zv8m
11 ай бұрын
This is so helpful !!! I could not have done this without you! Thank you!!!
@francispasqua9884
5 ай бұрын
Thank you very much! Love from Colombia
@elenakingsada6542
21 күн бұрын
THE BEST❤🙏
@dannellraven6023
9 ай бұрын
Thank you soooo much for this video. I am a new HR professional and making schedules will be new for me, especially calculating hours for payroll. How would I calculate hours when everyone won’t work 8 hours a day?
@karlacamarena8581
7 ай бұрын
Omg thank you soooo much I love it❤just created one. I watched so many and none worked
@Aminuibrahimsulaiman-jh8jb
11 ай бұрын
This is impressing, I learned and understood many things from this video
@notrealatall196
2 ай бұрын
Excellent!!
@user-mn5lq8vz8v
3 ай бұрын
I understood very well. I’m not computer savvy at all.
@valentinlishkov9540
8 ай бұрын
online scripys for spur gears an chain gears economical linear cut online scripys for sheet material products (cones, elbows, transition square to round section,transition rectangle to round section )
@kbetc.
5 ай бұрын
thank you so much for this, ive already successfully made my table. What formula do you use if the hours per day are different?
@StellyHubTV6065
4 ай бұрын
You teaching is excellent,pls can you teach data cleaning and validation in excel.Thank you
@FxQ23352
9 ай бұрын
its very helpful indeed and clear instruction thx you very much
@meriumwijetunga7838
Ай бұрын
Thank you
@MdRakib-dg4mq
Ай бұрын
good video
@wajeehkhalil3986
3 ай бұрын
your way of teaching is so amazing. you explain it with peacfully, straight to the point and explain the formulas very clearly. i loved it and did it in the first try which never happened with other teachers. keep teaching. I would like to know how you can make a calender for a year like this without wasting much time because for one month you can fill the series for 30/31 but for whole year do we need to do for each months or there is a magic trick, please explain. Thanks
@LearningMsOffice-dz5ng
3 ай бұрын
Hello! Thanks for the feedback) I will have another video on this topic in the future. I'll show you how you can create a work schedule for the whole year with individual shifts)
@John-3692
6 ай бұрын
This is a marvel. I read a book with similar content, and it was a marvel to behold. "Dominating Your Clock: Strategies for Professional and Personal Success" by Anthony Rivers
@Deidre749
6 ай бұрын
Thank you! Was wondering what formula would be used if there are half days of work?
@LearningMsOffice-dz5ng
6 ай бұрын
Good afternoon! I'm glad you liked it) As soon as I have free time, I will write down another lesson on creating a work schedule, which will also address your question.
@Deidre749
6 ай бұрын
@@LearningMsOffice-dz5ng Great! Looking forward to it. :)
@keithhedu-835
11 ай бұрын
Very helpful indeed
@niloofarkazemi707
8 ай бұрын
Great
@kylegurney8610
6 ай бұрын
is there a way to turn this to ICAl or ICS format so everyone can get their schedule automatically updated on their personal calendar?
@edvinadhami1
9 ай бұрын
Nice
@edvinadhami1
9 ай бұрын
Very good in learning exel
@shambalamaria7753
4 ай бұрын
The total hours didn’t work for me. Do you mind explain the formula. I’d like to have total weekly and monthly worked hours without having a column for total daily worked hours. Thx for the helpful video.
@jennsopinion3569
2 ай бұрын
When I put the day name and drag it to the end of the numbers, it doesn’t auto pop the different days of the week. Only the same day name
@ravikachwala3313
7 ай бұрын
what about if all employee work different hours every day then how do you calculate total hours for the day.
@LearningMsOffice-dz5ng
7 ай бұрын
I plan to make a separate video on this topic
@garciachristian9356
2 ай бұрын
@LearningMsOffice-dz5ng by any chance is this video out?
@fabianfredrick6720
11 ай бұрын
hi, for the total hour, why we use 2*8?? what is that for?
@LearningMsOffice-dz5ng
11 ай бұрын
Hello! It's great that you asked this question. Let's go through it step by step. I used the formula, which looks like this =COUNT(B11:AE12)/2*8. 1) The COUNT function counted all the cells with numbers, ignoring text. 2) In the range (B11:AE12), there are cells with the start time of work and the end time of the workday. So, there are two cells per working day. To get the accurate number of days, I needed to divide the result by 2. If I hadn't done this, the result would have been incorrect, as the number of days would have been doubled. 3) The next step is multiplying by 8 because the work shift, minus one hour of lunch break, is exactly 8 hours. By doing this, I determined the number of working days for the employee in a month and multiplied it by 8 hours. As a result, I found out the total number of working hours for the employee. Do you have any more questions on this topic?
@debbenson1303
7 ай бұрын
I still don't understand why you *8 what is the reason for the 8 Also can this be then shown in a graph? @@LearningMsOffice-dz5ng
@Fibbancci
8 ай бұрын
thisis what I was looking for, but I did it manualy....
@czarodoro10
Жыл бұрын
how to change the days of the week one by one instead of repeating the same day in columns? when I try to do that, the days of the week are copied the same. thanks.
@LearningMsOffice-dz5ng
Жыл бұрын
Hello! You need to click on the small square that appears at the bottom after filling in and select - fill series
@HannahBasillote-rd8du
2 ай бұрын
HOW did the time enter automatic,when I do mine still the same no change
@John-3692
5 ай бұрын
This is a revelation. I had the privilege of reading something similar, and it was a revelation in itself. "Dominating Your Clock: Strategies for Professional and Personal Success" by Anthony Rivers
@AVenomX
3 ай бұрын
can you share this for google sheets?
@Eminemsreallifewitfe23
9 ай бұрын
How do I auto fill drag the days of the week mine are all coming up Tuesday
@BuddhaLama-yp1ny
4 ай бұрын
Can we use some app in mobile for this schedule
@bcatcher
8 ай бұрын
When I try to copy all cells to make table, all cells turning into employee .
@wagachoki2059
9 ай бұрын
How do I input night shift hours. The formulae is not picking up
@watisupdockx0332
Жыл бұрын
what if the people work different hours within the week
@LearningMsOffice-dz5ng
Жыл бұрын
Just make adjustments according to your schedule
@Brock1491
7 ай бұрын
Does the algorithm change if they work less than 8 hrs for work, when calculating for hours?
@Brock1491
7 ай бұрын
Total hours worked
@Luk.s_edit
3 ай бұрын
My formula is not working that time one
@kumarrokaya6920
8 ай бұрын
How to calculate working hour per each week from a single month
@kumarrokaya6920
8 ай бұрын
Plz give some advice
@commemoratedemissie3521
11 ай бұрын
Even your vedio is not clear it becomes blurred
@LearningMsOffice-dz5ng
11 ай бұрын
Hello! "The motion blur effect" is a natural distortion that occurs when zooming in on an image because the resolution remains unchanged. However, zooming in allows you to see fine text and objects, which simplifies the learning process. Also, as a precaution, check the video resolution on the KZitem player. It should be at least 1080p.
@sukrantdahal1337
7 ай бұрын
I AM FROM NEPAL AND WHILE TYPING TIME FROM YOUR FORMULE METHOD. THIS METHODE IS NOT PICKING UP!!! like =B11+TIME(9;0;0) OR =B11+TIME(9,0,0) IT SHOW ERROR
Пікірлер: 66