TECH-018 - Compare Estimated Time vs Actual Time in a Time Line (Gantt Chart) in Excel
Вставка
- Опубліковано 25 сер 2024
- YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelcha...
Learn how to compare Estimated Time vs Actual Time in a quick and simple Time Line (Gantt Chart) in Excel.
In a previous video I showed how to create a quick and simple Time Line (Gantt Chart) in Excel and here is the link to that video: • TECH-005 - Create a qu...
In this video I continued where I left off in the previous one, and I used the IF formula, the AND formula, as well as 'Greater Than' and 'Less Than' conditions to create the Actual Time Line (Gantt Chart) in your spreadsheet. I also used Conditional Formatting to enhance the looks of the Time Line.
I hope this concept is something you can use in your daily routine so you get more with less effort.
I hope this concept is something you can use in your daily routine so you get more with less effort.
If you have an Excel challenge that you need help with, whether it is at work, at home, or at school, please write it in the comments below. I try to resolve common Excel challenges from our viewers and subscribers.
Thank you for watching.
Check out some of our previous videos in the links below:
* TECH-017 - Create a presentation in Excel and navigate through it like a website
• TECH-017 - Create a pr...
* TECH-016 - Create a countdown calendar and combine it with conditional formatting for each task
• TECH-016 - Create a co...
* TECH-015 - Count total days by day of the week in a calendar in Excel
• TECH-015 - Count total...
* TECH-014 - Create a progress tracker with check box buttons in Excel
• TECH-014 - Create a pr...
Thank you so much. This is one of the best tutorials ever.
I am one of the people who really thank you so much for your help and showing very clear steps. You the best
Thanks for your comment Salem. It’s nice to hear you find my videos helpful. Stay tuned for more.
Thanks for watching.
T-E-CH
how to we automatically exclude the weekend? let's say the allowed working days are monday to friday?
Excellent video it really help to clear my concepts of Gantt chart and how effectively we can prepare the same chart using MS excel tool too. Thankyou so much.
This was probably the best Excel video I have seen, AWESOME!
Great solution. I´d spent ages trying to modify the IF(AND... formula, but couldn´t get it to work. So this is a really practical solution. Nice one.
Many thanks. It looks very professional and nice. I just followed your instruction to finish my report.
I don't know how to thank you but the info you have put here was very great and from the bottom of my allow me say thank you very much.
Challenge - I have sheet1, sheet2, sheet3, sheet4 and sheet5, every sheet contains date and time of the 12months, for example Sept. 09, I put an agenda on the 9am, then in sheet 2 I put agenda on 12nn, next sheet, 2pm, sheet 4 3pm and sheet 5 5pm. Then in Sheet 6 it shows all the activity I made on different sheet. I hove you notice my comments, because It is very big help to manage the class activity of 5 section handle. Thank you so much :) very helpful videos you always content :)
You are a life saver bro! Thank you so much
Thank you for such an easy and quick Gantt Chart technique in Excel. I have a question related to the above video. What if we want our project to start from Monday ? Also how can we highlight the weekends(Saturday & Sunday) and other holidays during the project tenure? Would appreciate if you can come up with a solution. Thanks once again for your efforts.
in actual condition, im working from monday to friday, could you tell me how to make off day on the timeline, and make calculate correctly sir ?
Good video. How would you create one that avoids weekends and only does work M-F?
Thank you for the tutorial, I have a question, how do you automatically exclude weekends from Row 5? Hope you can help us with this one. thanks
One of the Top Rated Video.. great
Thank you very much for clear explanation.....very usefull video
Thank you so much for such clear instruction - and for the template...soooo useful!!!!
Oh thank you very much bro for the shot valuable and educative video. I am still thinking about how to establish the critical path on the schedule?
Thank you very much
Thank you so much for sharing this helpful tips！
Hi, good work. I have 3 questions. 1) I would like to make friday as weekend, so in duration it will deduct Fridays. Saturday to Thursday are working days. 2) Highlightng bar for Actual, it doesnt get hilighted till we put end date. what i want to see is it highlight based till todays date from actual start, till i dont put end date. once i put end date, it should highlight from actual start to actual end date. 3) i want to add % colum, for plan and actual. Please assist me on this, appriciated.
this is your last video. I hope you comeback making videos because yours are better than the rest.
trust me I’ve checked them all.
Awesome thanks for sharing, this is going to great for my task list
Hi Sir! I really appreciate the tutorial ❤ Can you also make a video on how to apply Scurve for this ?
You are life saver !!Thanks a ton.
Thank you. much helpful..
Actually helpful.
This is a great video. Can you explain how to level this schedule with available manning? For example; maybe you only have 4 people to complete all of these tasks.
Awesome , you made it look so easy,
Exactly what I was looking for. Thank you.
I want to do this in Google sheets too. Don't know how it works out.
Sir I appreciate you're hardwork, you are doing very will, Sir I kindly request u to create a tracking sheet for expenses of a project.
You are in my mind, thank you
Thanks Arteo. Glad you liked it.
Superb really excellent Job to explain and is really very useful. Finally I got it . Thank You so much Bro!
this is very helpful. thank you very much. makes my work easier so much.
You are a gem Sir!
This will only work if you have an actual finish date, how can you keep a running bar on the actual till its complete, for activities that have a longer duration. Like your tutorials, so informative and easy to follow.
This is awesome
You saved my absolute bacon. Thank you sir!
I want to be able to use hours and minutes with dates. I'm using it to track manufacturing processes.
Hope you find solutions
Amazing❤
Thank you Sooo much !! Thats sooo Awesomw !! Ofcourse I will try it
Thank you
Thank you... This is the Idea I was looking for...
great job
I've set up a Gantt Chart like the one you created and wonder now if it is possible to set up so that planned and actual duration can exclude weekend dates?
Thanks a lot
Thanks a lot for this video. SUPER USEFUL. One follow up Question though. Is it possible to highlight the amount a task slips in a different color(say RED) to flag the amount of delay in days ?, especially in the ACTUAL row. Sounds like this might need a slightly more complicated conditional formatting.
Impressive！Great to watch these videos👍😊
Wow I wish you upload more..
Your methods are amazing and simple to implement, is there a way you create Critical path method(CPM) from project management point of view
Thank you for the very informative gantt chart but Please will you include a progress percent for this gantt chart.
Why are you not active nowadays..?
You're doing great brother..!
is there a way to still include all Sundays? great video BTW!
Hi sir,
Your presentation is amazing but i notice something in your duration vs the number of bar which is not thesame for example in ID # 1 ,the duration is 4 but the bar showing is 5 which is not matching,what i did is i minus 1 in formula for the End date to have 4 bar .Thank you
Thank you so much for this tutorials it is very helpful .How can we combine to create a yearly plan in one spreadsheet.
Thanks for the sample time plan in excel.
Awesome & Tqsm
This was very useful, thank you!
hi ' thanks for this amazing explanation ! what if I add a holydays and days off ?
Hello. Thanks for the video. Do you have something similar but with tasks which are taking few hours, not days? I want to prepare something for my job, taking in consideration that i am working 8h/day and consider this 8h one day. Did you got my point? I want to track all my tasks and by the end of the month to see if I am doing my job better than the estimation. Let's say I estimate one task for 5h and i will finish in 4h, then I have cost saving for 1h. Thank you for your response!
Thank you for the tutorial, I have a question, how do you automatically exclude weekends from Row 5? Hope you can help us with this one.
Appreciate video content! Excuse me for the intrusion, I would love your thoughts. Have you heard the talk about - Weydaniel Organized Dominator (probably on Google)? It is a smashing one of a kind product for getting 7000 plus project management and business templates without the headache. Ive heard some amazing things about it and my work buddy after many years got cool results with it.
Excellent make more videos
Thankyou for your tutorial.. it means a lot..
but can u help me, for controlling inventory, when to reorder, how long that inventory enough to use until it runs out..
Could you please let me know how you would like us to mention the plan progress and actual progress? kindly advise and make a video regarding this
Nice...Please make a video on Daily, weekly and monthly plaaner in xls.
Thanks for this. But how best can you help me as a beginner? I have a project assignment for a duration of 15months. It's a construction project
Thank you for sharing. can you show sample of FTTH fiber deployment template ?
Can we add the progress percentage to the Gantt chart along with the responsible person
Thanks this video is really helpful
Appreciate video content! Excuse me for the intrusion, I would love your thoughts. Have you heard the talk about - Weydaniel Organized Dominator (probably on Google)? It is a smashing one of a kind product for getting 7000 plus project management and business templates without the headache. Ive heard some amazing things about it and my work buddy after many years got cool results with it.
super thank you - i added this too to the Gantt chart - thank you.
I was able to take out the weekend dates in the calender - but i dont know how i should do so that taskduration takes in conderation weekend dates - now if i have 3 days and 1 of them would fall on a saturday or sunday it doesnt show the 3th day - would be great to get some help on this too - in any case i am very thankfull for this video!
Hello sir, thanks for sharing your knowledge, but it seems the formula you use in the dates ( start and end dates) need to be rectified, example in ID#1, Demolition duration is 4, but when you count the timeline it has 5 days, and so on ... you need to add 1 in start date and deduct 1 in your end date.
Thank you, I was wondering also
Thank you form Pakistan
just going through your tutorials, which are great by the way; on this one (TECH-018 - Compare Estimated Time vs Actual Time in a Time Line (Gantt Chart) in Excel) how would you proceed to populate the chart, if you had one or more tasks that could be performed at the same time as others, meaning that they are not dependent one from each other? thank you in advance.
Hi. That is what I'm looking for but to be 100% happy I looking to add for your planer some like:
I'm handyman,
Example I'm add kitchen project when I know that will be around 3 weeks. I want type kitchen on my task and excel should automatically mark this 3 weeks on my calendar. That will give me batter look of my free time to arrange next project. Are this criteria will be possible to put in your sheet.
Thank you.
useful vedio thanks
Great videos!!! Looking forward that you make more of them =)
Thank you mate for the useful explanation. Could you please explain how to do searchable employee name with their total working amount. if one employee work variable production department. if you explain this, it will helpful for me. Advance thank
Hi...Thanks for the video. I have one query. How to do provision for weekend (Saturday and Sunday). When I am saying 10 days is my duration one task then I should consider only working days.
Please help
Thank you very much.. can you help to show if we want to get percentage(%) for the planned vs actual? Thank you in advance..
very usefull
very good video, thanks for helping me to make my timeline, but just a doubt how does it work with two different months on the same timeline? as soon as i change the date it seems not to work. thanks
Super sir clear we want More updates
@The Excel Challenge Thanks for your great advise. I have an excel challenge for the Gantt Chart. I wanna add the manpower in each cell with the conditional formatting and manpower graphic below the Gantt Chart. Please help me find a solution. :)
thanks from Oman
Great
Hey Thanks for this video this is very Useful.
But I should have need a bit more detailing in it, like I have to track the schedule and find out how many days I delay in my work, then how will they do it?
Please can you Help me?
Nice
Wow it is great but can you please post example this table weekly plan vs actual
hey,
every time for a new activity, I have to copy formula for planned and actual row. is there any formula or coding like whenever a new activity adds up, formula itself applied to that row looking/searching for planned and actual keyword? do tell
Hello, thank you for showing this. Can you let me know how we can show time and date in the Gantt chart? I want to see a breakdown down to the time, but do not how to show that. Thank you
Very nice sir
So helpful
This excellent presentation, the demonstration is easy to understand!!! I learned a lot.
What I want to know if we can combined the value of the actual completion in PERCENTAGES with same in the time line.
Excellent! How can we adjust the formula to make more than 1 “start/end” date in the same row. Please help!
Hi - This is really good work! Is it also possible to show someway the dependencies in the Gantt chart which probably are or could block any activity and its impact on the baseline vs actual?
Please let know how to formulate the percentage of task completion in the gantt chart
How to work on dates with formula for working days excluding weekends and public holidays?
How to add comulative percentage? Thanks
hello sir,
is there any formula which we can apply for the planned and actual row so that planned and actual formula ( X and Y )applied itself ,,we dont have to copy formula or to drag it ? please reply . its necessary.
How do you incoperate percentage progress using this Time
Duden awesome work !
Thanks Zirael !!
Thanks for the video. So helpful
I am finding it difficult to create timeline between two 4 months using a weekly interval. Can you help me please?
1. Hw to change the dates to working days only? 2. If there are multiple people working, say 3, how does duration work?