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
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.
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
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?
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.
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
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
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)
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 )
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.
I have a doubt for making duty roaster We have 90 staff in a unit for a month I want to put 3 shifts as morning ,afternoon , night but I want to calculate each day hw many staffs in each shift
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
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?
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.
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 RUclips player. It should be at least 1080p.
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
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
Where did you get the number 8 you put on calculating number of hours worked at the end of formular?
Yes, thank you
When I try to copy all cells to make table, all cells turning into employee .
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.
@@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.
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
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?
Thank you! No one has explained it as simple as this! Keep it up...👍
Thank you very much! Love from Colombia
thank you so much for this, ive already successfully made my table. What formula do you use if the hours per day are different?
the clam river flow sound in the background is really peacefull thanks
Omg thank you soooo much I love it❤just created one. I watched so many and none worked
This is so helpful !!! I could not have done this without you! Thank you!!!
Thank you! Was wondering what formula would be used if there are half days of work?
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.
@@LearningMsOffice-dz5ng Great! Looking forward to it. :)
thank you for much. i learnt something new today. All the best.
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
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
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)
This is impressing, I learned and understood many things from this video
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 )
its very helpful indeed and clear instruction thx you very much
This looks good. And is it possible to add Breaks, Lunch and Meeting, Coaching and show how many hours spent on Coaching or Meeting
You teaching is excellent,pls can you teach data cleaning and validation in excel.Thank you
is there a way to turn this to ICAl or ICS format so everyone can get their schedule automatically updated on their personal calendar?
THE BEST❤🙏
I understood very well. I’m not computer savvy at all.
Excellent!!
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.
good video
Thank you
I have a doubt for making duty roaster
We have 90 staff in a unit for a month I want to put 3 shifts as morning ,afternoon , night but I want to calculate each day hw many staffs in each shift
Very helpful indeed
pretty well.
Great
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
Nice
Very good in learning exel
I wish I had James Brown as a colleague
what about if all employee work different hours every day then how do you calculate total hours for the day.
I plan to make a separate video on this topic
@LearningMsOffice-dz5ng by any chance is this video out?
Can we use some app in mobile for this schedule
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
can you share this for google sheets?
thisis what I was looking for, but I did it manualy....
HOW did the time enter automatic,when I do mine still the same no change
How do I auto fill drag the days of the week mine are all coming up Tuesday
hi, for the total hour, why we use 2*8?? what is that for?
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?
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
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.
Hello! You need to click on the small square that appears at the bottom after filling in and select - fill series
How do I input night shift hours. The formulae is not picking up
When I try to copy all cells to make table, all cells turning into employee .
How to calculate working hour per each week from a single month
Plz give some advice
My formula is not working that time one
what if the people work different hours within the week
Just make adjustments according to your schedule
Does the algorithm change if they work less than 8 hrs for work, when calculating for hours?
Total hours worked
Why did he put B11?
Even your vedio is not clear it becomes blurred
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 RUclips player. It should be at least 1080p.
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
Thank you