How to create a work schedule in Excel
ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2024
- Dive into this step-by-step tutorial and learn how to create a work schedule in Excel. Regardless if you're an Excel veteran or just a beginner, this video will guide you through the simple steps in crafting your very own work schedule. The video includes everything from inputting data to formulating a schedule that suits your needs. Master this crucial technique that can streamline your daily operations, improve team communication, and increase productivity.
To support the author financially www.donational...
#excel
#exceltutorial
#excelforbeginners
#workschedule
#microsoftoffice
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
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
Thank you! No one has explained it as simple as this! Keep it up...👍
Thank you very much! Love from Colombia
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?
This is so helpful !!! I could not have done this without you! Thank you!!!
thank you for much. i learnt something new today. All the best.
thank you so much for this, ive already successfully made my table. What formula do you use if the hours per day are different?
This is impressing, I learned and understood many things from this video
its very helpful indeed and clear instruction thx you very much
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. :)
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)
You teaching is excellent,pls can you teach data cleaning and validation in excel.Thank you
This looks good. And is it possible to add Breaks, Lunch and Meeting, Coaching and show how many hours spent on Coaching or Meeting
pretty well.
I understood very well. I’m not computer savvy at all.
is there a way to turn this to ICAl or ICS format so everyone can get their schedule automatically updated on their personal calendar?
Thank you
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
Excellent!!
THE BEST❤🙏
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.
Very helpful indeed
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 )
good video
Can we use some app in mobile for this schedule
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?
Great
can you share this for google sheets?
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
Nice
Very good in learning exel
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 do I auto fill drag the days of the week mine are all coming up Tuesday
HOW did the time enter automatic,when I do mine still the same no change
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 .
thisis what I was looking for, but I did it manualy....
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
My formula is not working that time one
How to calculate working hour per each week from a single month
Plz give some advice
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
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 TH-cam 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