You are an absolute legend this video is 5 years old and still easy to follow, we use Google sheets and even thou its slightly different. I've managed to copy every step thank you so much 🙏🏾
Excellent explanation. I hope you could do a full excel tutorial; I know there are a lot here on youtube but your explanation is one of the best. Thank you!
This was a quick and simply instruction to follow for what I need, however what if I choose to calculate vacation in hours so that we can track people take full days or 1/2 days?
First of all thank you!! I made this spread sheet worked out great. I have a question. And wondering you can help me. My company is on point system. For example if you call out sick and don’t have sick time to cover your shift it’s 1 point. If your late under 2 hours it’s .5 a point. Now what I want to do is create a column where it calculates the points. But I don’t know the formula I would use. Plus I don’t even know if I explained this right. Lol I’m trying here
Great tutorial, no bells and whistles just the KISS principle which produces the data. I've followed this through on my own and have produced the same result. Only question I have, is relating to the days of the month which vary... I guess we just manually change these? Thanks
Good day i would like to ask say for instants , i schedule a employee for the month ,is it automated so i don't make a mistake to schedule employees on the same day that must not work that specific day?
Nice video. I have a quick question. Can I add shortcuts to get certain value? For example, if i want to put someone in day off, can i just press 1 and have it changed to off with certain colour box. thank you
Thanks for the help . It could be a bit slower when you are selecting items . I have to keep rewinding . maybe say what you are selecting . thanks again
Brilliant video. I have tried to set up a spreadsheet all weekend for a shift roster. One question how do you change the months to reflect day changes for example all months will not start on a Monday
+Dave Ryan Hey Dave. Thanks for the comment. You'd have to do this manually. But it won't effect the formulas. Just change the days and move the grey weekend cells over to match the days. It will still work just fine
Thanks buddy, this was very helpful. Can you please consult me on how to add a date formula for these charts so that I dont have to do it manually? Thanks in advance :)
Hi. Thanks for the video. Do you have a video on how to create a template to manage staff availability across multiple work sites? So, I have to manage supervisors availability on 5 different work sites and need to manage capacity across these sites, show when each is on site, on annual leave and in training. The template also needs to account for weekends and public holidays. Any pointers?
This video is extremely helpful. I created a spreadsheet using this as a guide. I would like to add an option to subtract an occurrence after 365 days. Can you please assist?
Hi I've tried emailing but it keeps bouncing back. I really enjoyed your video on staff attendance rota. I love Excel, I love adding formula to make things calculate automatically. I wonder if you could help me with a roster issue that I am having in my current employment. Unfortunately I think that I’m in over my head with this one, All I want to do is put 12 maintenance guys into a 9am to 5pm 5 day rolling roster, projected for the year, the tricky part is that 6 of them do an on-call shift where they have to hand over a van to the next on-call guy. I hope that you can help with this. Thank you, in advance.
The thing you did which filled the days, "mon", "tues", "wed", didn't work for me. I had to type them in manually for all 31 days. Can you point me to a video that shows how you got that to fill in the days automatically, so in future, I don't have to do all that manually please?
This is because employees often fill weekends along when filling for holiday plan if they are not informed not to fill week end. The only solution I see is to lock or protect weekend cells.... There must be easier way?
Hi. Please make a tutorial video how to automatically extract (from schedule/ROTA) the names of staffs who will be working on night shift or day shift of a particular date. I will help me big time. Thanks.
Wow! This is super nice, great video and very close to what I am tring to find out, the thing is that I need to plan a cronogram but based on the needs or disponibility of the participants/employees instead of aplying the default company parameters equally to everyone, so for example: I have 2 participants asigned to 1 task, Participant 1 can work only on mondays from 10 am to 6 pm (8 hours) and Participant 2 can work mondays and tuesdays from 8 am to 12 md, but one of them have a certain date that will have to work less hours than he normally would do, and we don´t know yet the entry and leave time for that date, so I know that I can solve the start date and end date for the task by getting the earlier date for Start and the latest date for End between the participants, but how can I count only their efective time, days, etc? track the progress and that kind of stuff that a project manager is for?
hi, just wanna ask if u can help me i have a shift working weekly schedule and every week i need to shift workers for 4 areas but dont know how to shift them automatically..
I like this one. I was wondering if there is also a way to incorporate the hours each employee worked that day ? Please if you could give me any pointers.!
I would say that you could easily just put the number of hours worked in that day's box. Then over on the right hand side (where all the holidays, lates & sicks are), make a new column and simply add the numbers together. You could use the SUM formula. Eg: =SUM(A1:H1) and down along. It will count the sum of all the numbers you input into the boxes. Hope this makes sense!
hello excellent video i like but I would like to know how i can create a rosta for 50 people worling 5 days a week from monday to saturday please can you help please?
Saturday and Sunday will be on different dates of every month, but in your video it is on same date because you simply copy the sheet and change January to February and March. If there is any automatic formatting for months please share
Very very very helpful and excellent guide for newbies like me :) i hope u can help me making another sheet for employee memo's and violations .. :) ill wait your rely sirn thanks a lot
Just completed a staff attendance sheet from scratch. I couldn't have done it without your brilliant easy to follow tutorial. Thank you so much. Ps What was the music in the background? It sounded like Savage Garden. Would you be kind enough to give me the name of it. Again, many thanks.
This was extremely helpful but I have "Late" and "Early" which both need actual time put in the cells. Right now I have "late" which shows up as blue and uses a sum function to total in corresponding column. But how do I do that to "Early"? I need it to show up a different color and total in it's own corresponding column? Haven't been able to figure that one out. Can you help me?
Excellent explanation and very easy to follow. Yes, I would like to have it. How shall I send my email? However, in the meantime I will try it by myself. Very much appreciated!
Please could you show me how to make a daily register, based on who is due to attend? I have a list of clients, who all attend on different days. I have them listed on a separate excel sheet, with they days/sessions they attend, & I need to be able to print a day by day register, according to who is in on those days, & also be able to add names and days to the list & have the alterations to be recognised by the register. Some clients attend only mornings, some attend afternoons, some do full days, & I would like to be able to include them all on the same register.Also, is there a way of making a similar register, so I can keep a digital record of who attends. Cheers!Hank
So... eh... I expected some auto calculation per year, and x days a month. But that isn't there? Not each month starts on Monday, nor does it end at the 30th.
Yes of course. This is a tutorial. It is for people to take and adapt to their particular time/year. Fully customizable. The concept of auto calculation is explained for a quarter so the same rational applies for a year. It should be very easy after watching the video. Thanks for your comment!
🤭 🤭 🤭 🤭 Will do so, yes boss, but do happens in my company, they might just take half day holiday or mix with holiday (we called annual leave in my country) in the morning and compensation leave in the afternoon
What are you, some sort of excel wizard?!
Hahahahahaha. Thanks!
quizzlie Good evening, A great sheet and simple to use. can you please send me the spreadsheet? My email address is shams@sky.com
@@TheNightTimeEntrepreneur this could help with my staff rota, would you be able to email it to me at shanewatt1984@hotmail.com thanks 😊
I tried to send you an email but it got sent back undeliverable.
I think he is something more....
this is amazing!
I'm 5 years late, but this was the most informative tutorial! Thank you so much 😊
Always appreciated!
You are an absolute legend this video is 5 years old and still easy to follow, we use Google sheets and even thou its slightly different. I've managed to copy every step thank you so much 🙏🏾
Same lol
Like that video simple and clear
this is so so helpful! was going to give up on my school report until i saw this, you saved my life!!!
Very good and interesting best one yet. Your a life saver thanks.
Superbly presented, just an observation, some months have more days than others. Helpful before copying across multiple tabs.
Great stuff here. I wish I would have watched this 3 days ago.
Thanks for the video, it really help me
Excellent explanation. I hope you could do a full excel tutorial; I know there are a lot here on youtube but your explanation is one of the best. Thank you!
Great video. After a very frustrating search, i found your tutorial, I followed it step by step and i achieved the same results. Thank you
That's what I like to hear Anne Marie Mark! Thanks for your comment!
I want capacity management and forcasting videos pls do for us
Thank you! This video so far, is the easiest to follow and it helped me big time. Thanks!
This is a perfect video! From your explanation down to the background songs! Please do a full excel tutorial🙏🏾🙌🏽❤️🔥
wow this really amazing, thank you 🤩😇
Thank you for sharing!!! Very helpful :)
Thank you very much. If I want to add the start and end time for each employee, how can I add it?
This was a quick and simply instruction to follow for what I need, however what if I choose to calculate vacation in hours so that we can track people take full days or 1/2 days?
First of all thank you!! I made this spread sheet worked out great. I have a question. And wondering you can help me. My company is on point system. For example if you call out sick and don’t have sick time to cover your shift it’s 1 point. If your late under 2 hours it’s .5 a point. Now what I want to do is create a column where it calculates the points. But I don’t know the formula I would use. Plus I don’t even know if I explained this right. Lol I’m trying here
Very nicely explained... Btw which song is being played in the background... Super loved it.. From India🇮🇳
hello,
Amazing video.
Cloud you share the Spreadsheet???
Thank you!!
This was a lovely video but how can i make the date automatically populate based on each calendar month
Great tutorial, no bells and whistles just the KISS principle which produces the data. I've followed this through on my own and have produced the same result. Only question I have, is relating to the days of the month which vary... I guess we just manually change these? Thanks
Great work bro👍...!!
Very helpful and easy-to-learn explanation!
Good day i would like to ask say for instants , i schedule a employee for the month ,is it automated so i don't make a mistake to schedule employees on the same day that must not work that specific day?
Thank you so much for sharing your knowledge!
Very clear tutorial! Very nice voice
Please make more videos available.
You’re amazing! Thanks again.
Thank you . Need some slow for beginners. Over all good sir 👌
Awesome spread sheet I need one of these for sure
The best explanation on youtube. Thanks!
Thanks Joanne! That means a lot
Great spreadsheet, thank you for sharing!
Thank you so much. I needed this.
Love your video it help me
Nice video.
I have a quick question. Can I add shortcuts to get certain value? For example, if i want to put someone in day off, can i just press 1 and have it changed to off with certain colour box. thank you
very useful and clear explanation, Thank you !
Excel genius, thankyou for all the help.
Thanks for the help . It could be a bit slower when you are selecting items . I have to keep rewinding . maybe say what you are selecting . thanks again
Will do, thanks Mary!
Hi thank you so much..
I did it my own after following ur instructions..
Need your help for summarize by staff .
Hi I followed the video and it's great I just wanted to find out if there is a way I can have a weekly view as well as monthly
Thanks very helpful
Brilliant video. I have tried to set up a spreadsheet all weekend for a shift roster. One question how do you change the months to reflect day changes for example all months will not start on a Monday
+Dave Ryan Hey Dave. Thanks for the comment. You'd have to do this manually. But it won't effect the formulas. Just change the days and move the grey weekend cells over to match the days. It will still work just fine
Thanks buddy, this was very helpful. Can you please consult me on how to add a date formula for these charts so that I dont have to do it manually? Thanks in advance :)
Also how do i setup half day holidays so it updated the total :)
Hi. Thanks for the video. Do you have a video on how to create a template to manage staff availability across multiple work sites? So, I have to manage supervisors availability on 5 different work sites and need to manage capacity across these sites, show when each is on site, on annual leave and in training. The template also needs to account for weekends and public holidays. Any pointers?
How do i lock it so other people can enter time and holidays but they cannot play with the formula or change the layout
Very helpful information. Thank you!
Hi. maybe u know how to transfer and count used holidays in hours?
Thank you for this lesson. Will you please kindly send a copy of this spread sheet.
This video is extremely helpful. I created a spreadsheet using this as a guide. I would like to add an option to subtract an occurrence after 365 days. Can you please assist?
Hi
I've tried emailing but it keeps bouncing back.
I really enjoyed your video on staff attendance rota.
I love Excel, I love adding formula to make things calculate automatically.
I wonder if you could help me with a roster issue that I am having in my current employment.
Unfortunately I think that I’m in over my head with this one,
All I want to do is put 12 maintenance guys into a 9am to 5pm 5 day rolling roster, projected for the year, the tricky part is that 6 of them do an on-call shift where they have to hand over a van to the next on-call guy.
I hope that you can help with this.
Thank you, in advance.
A thousand times THANK YOU :)
you are such amazing Teacher
The thing you did which filled the days, "mon", "tues", "wed", didn't work for me. I had to type them in manually for all 31 days. Can you point me to a video that shows how you got that to fill in the days automatically, so in future, I don't have to do all that manually please?
I am wanting a schedule for 4 - 4 man shifts working 12 hours 6 on 2 off being doubled up. Can you assist?
Genius video! just how I did it... One thing I cant get is how can I exclude weekends eg. Frid n Sat in countif?
Noli Pugay thanks! Hold CTRL and highlight from Monday to Friday as you go along. So four lots of highlighted days Monday to Friday.
If your weekends are blank it won't matter if it's in the formula so in essence, you can count the whole row
This is because employees often fill weekends along when filling for holiday plan if they are not informed not to fill week end. The only solution I see is to lock or protect weekend cells.... There must be easier way?
Hi. Please make a tutorial video how to automatically extract (from schedule/ROTA) the names of staffs who will be working on night shift or day shift of a particular date. I will help me big time. Thanks.
Thanks the best explanation ever 👏👏
Wow! This is super nice, great video and very close to what I am tring to find out, the thing is that I need to plan a cronogram but based on the needs or disponibility of the participants/employees instead of aplying the default company parameters equally to everyone, so for example: I have 2 participants asigned to 1 task, Participant 1 can work only on mondays from 10 am to 6 pm (8 hours) and Participant 2 can work mondays and tuesdays from 8 am to 12 md, but one of them have a certain date that will have to work less hours than he normally would do, and we don´t know yet the entry and leave time for that date, so I know that I can solve the start date and end date for the task by getting the earlier date for Start and the latest date for End between the participants, but how can I count only their efective time, days, etc? track the progress and that kind of stuff that a project manager is for?
hi, just wanna ask if u can help me i have a shift working weekly schedule and every week i need to shift workers for 4 areas but dont know how to shift them automatically..
Hey brother i just took your tutorial and its a very good tutorial. do you have anymore... thank you for your service
everything is clear )) thanks a lot
I like this one. I was wondering if there is also a way to incorporate the hours each employee worked that day ? Please if you could give me any pointers.!
I would say that you could easily just put the number of hours worked in that day's box. Then over on the right hand side (where all the holidays, lates & sicks are), make a new column and simply add the numbers together. You could use the SUM formula. Eg: =SUM(A1:H1) and down along. It will count the sum of all the numbers you input into the boxes. Hope this makes sense!
The Night Time Entrepreneur thank you so much for the help. 🙌🏽
hello
excellent video i like but I would like to know how i can create a rosta for 50 people worling 5 days a week from monday to saturday please
can you help please?
Saturday and Sunday will be on different dates of every month, but in your video it is on same date because you simply copy the sheet and change January to February and March.
If there is any automatic formatting for months please share
Yes just change the date numbers. .
Very very very helpful and excellent guide for newbies like me :) i hope u can help me making another sheet for employee memo's and violations .. :) ill wait your rely sirn thanks a lot
Nice spread sheet
Just completed a staff attendance sheet from scratch. I couldn't have done it without your brilliant easy to follow tutorial. Thank you so much. Ps What was the music in the background? It sounded like Savage Garden. Would you be kind enough to give me the name of it. Again, many thanks.
Comments like yours make it worth the effort. Excellent! Well done to you Laura!!! I will double check what the music was too...
Hi, do you still have this file available? If so do you mind emailing it to me.
This was extremely helpful but I have "Late" and "Early" which both need actual time put in the cells. Right now I have "late" which shows up as blue and uses a sum function to total in corresponding column. But how do I do that to "Early"? I need it to show up a different color and total in it's own corresponding column? Haven't been able to figure that one out. Can you help me?
under the home tab, find conditional formatting and manage rules, find the rule you want to change and change the settings that way.
thank you for the hard work youre legend
Thankyou
Excellent explanation and very easy to follow. Yes, I would like to have it. How shall I send my email? However, in the meantime I will try it by myself. Very much appreciated!
Please could you show me how to make a daily register, based on who is due to attend? I have a list of clients, who all attend on different days. I have them listed on a separate excel sheet, with they days/sessions they attend, & I need to be able to print a day by day register, according to who is in on those days, & also be able to add names and days to the list & have the alterations to be recognised by the register.
Some clients attend only mornings, some attend afternoons, some do full days, & I would like to be able to include them all on the same register.Also, is there a way of making a similar register, so I can keep a digital record of who attends.
Cheers!Hank
Could I be emailed the template? How do I send my email?
I followed the steps but somehow my summary sheet is not calculating the different sheets and not figuring out the plus on this 2016 excel.
Would have been nice to see HOW to do this. Looks good but I have no idea how to get there!!!
Hi Mary, I'm not hearing this a lot. Which part did you find failed to explain how to do this?
great teaching please can you send me the spreadsheet
Please do for capacity management and forcasting videos
How do you include half days to this formula
Is it just me, it looks blurry, I'm finding it difficult to read what's on the sheets?
Can you also make one to track weekly safety meeting sign offs? :)
wow amazing, thank you for sharing. I let you know how this works out.
How do I send you my email privately??? I would like one please?? 😢
can you do a video on employee datadase with images
I dont suppose you are still sending this?
Great video ! Music made it hard to watch not bad but the instrumentals would have been better alone 👍🏾
I wish I could see the tabs you push it looks like a good video but duplicating it is hard you show the process to fast
good job
Hi! May I please have the spreadsheet emailed to me? I’d greatly appreciate it. The one I’m using at the moment is not ideal lol.
Can I get that attendance sheet emailed to me?
Can i still get it emailed to me?? PLEASEEEEEE
Create a duty roster of staff of 9 with 12 hrs per day and 48 hrs per week please how to please
I was looking to do adding up there hours lol
Does anybody knows how to create a formula with the letter V=8 hours in the attendance
great
How to calaculate for half day, can anyone plz guide
What is the Full form of ROTA ?
So... eh... I expected some auto calculation per year, and x days a month. But that isn't there? Not each month starts on Monday, nor does it end at the 30th.
Yes of course. This is a tutorial. It is for people to take and adapt to their particular time/year. Fully customizable. The concept of auto calculation is explained for a quarter so the same rational applies for a year. It should be very easy after watching the video. Thanks for your comment!
How about the staff apply holiday in the morning, sick in the afternoon?
Fire them
🤭 🤭 🤭 🤭 Will do so, yes boss, but do happens in my company, they might just take half day holiday or mix with holiday (we called annual leave in my country) in the morning and compensation leave in the afternoon
No problem, I'm just kidding. Strange as it is, I guess you would just have to add on another cell onto your page and count it in as half
do you have a email that I can email you a spreadsheet I was hoping you could help me with?
Great video however ,quite fast so ,unable to follow hopefully as I get better in excel it will become easier !
Thanks for your comment. Please feel free to start and stop throughout - it would be a very long video otherwise! :)