Sort by time | Sort by thread (beta)
- Your queue is empty. Add videos to your queue using this button:
or sign in to load a different list.
Loading...Saving...
Loading...Saving...
you are awesome!
okishai1987shulsen 4 months ago
say my office working hours is 9:00 am to 5:00 pm ( 8 hours)
I have 10 hours allocated to a task (column B)
start time is say 12-July Tue 9:00 am (Column A)
I want to add these both (A+B)
I am expecting the output to show as 13-July Wed 11:00 am.
can you help....can't get my Gantt Chart without this..
reg....narayan
4496gopi 7 months ago
hi
4496gopi 7 months ago
Mr. I might be wrong, but i think the formula is not working properly from rows 4 to 7
renelielwero 8 months ago in playlist Excel Conditional Formatting Tricks
How is the formula not working?
ExcelIsFun 8 months ago
How is the formula not working?
I think if you do not type weekends or holidays into the start date, it will always work. If you type weekends or holidays into start date (like in row 5) then you get incorrect answer. I have another video that shows how to add Data Validation to prevent weekends and holidays. See this video at the 48:41 minute mark:
Excel Magic Trick 787: Conditional Formatting Basic To Advanced (30 Examples)
ExcelIsFun 8 months ago
Fantastic! Your information is right on the dial. Thanks.
Marcoseagle7 10 months ago
I am glad that you like the video!
ExcelIsFun 10 months ago
@ExcelIsFun Do you have a video on creating a gantt chart to manage projects within 24 hours using minutes and hours as opposed to days?
Marcoseagle7 10 months ago
No I do not. Sorry about that. Maybe sometime in the future, but I have been really sick for two months...
ExcelIsFun 10 months ago
hey, I need to create a gantt chart where the bar in the chart only changes colour when an option is chosen where that particular task is completed. Please advise on how to do this! Thanks
badman1877 1 year ago
I like you, can't wait for 2010. I just purchased new PC for home and got 2007 and can download 2010 for free once it comes out.
krn14242 1 year ago
When can I buy Office 2010?
highonhayek 1 year ago
They say about May. But we will see... I can;t wait, myself!
ExcelIsFun 1 year ago
Love these charts. Now it's just so much easier. Thanks Mike!
mikeyroro 1 year ago
This is much much easier with Excel 2010! There are some really awesome new functions in Excel 2010.
ExcelIsFun 1 year ago