How to create a work schedule in Excel
HTML-код
- Опубликовано: 1 июл 2023
- 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.donationalerts.com/r/semy...
#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
Thank you! No one has explained it as simple as this! Keep it up...👍
Omg thank you soooo much I love it❤just created one. I watched so many and none worked
This is impressing, I learned and understood many things from this video
Thank you very much! Love from Colombia
This is so helpful !!! I could not have done this without you! Thank you!!!
its very helpful indeed and clear instruction thx you very much
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?
I understood very well. I’m not computer savvy at all.
You teaching is excellent,pls can you teach data cleaning and validation in excel.Thank you
Very helpful indeed
Excellent!!
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
good video
thank you so much for this, ive already successfully made my table. What formula do you use if the hours per day are different?
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)
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
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 )
Great
is there a way to turn this to ICAl or ICS format so everyone can get their schedule automatically updated on their personal calendar?
Nice
Very good in learning exel
How do I auto fill drag the days of the week mine are all coming up Tuesday
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.
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
How do I input night shift hours. The formulae is not picking up
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
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
Can we use some app in mobile for this schedule
can you share this for google sheets?
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
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?
When I try to copy all cells to make table, all cells turning into employee .
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
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
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