Excel Magic Trick 565: Excel 2010 Daily Gantt Chart
Loading...
Loading...
21,275
Loading...
Uploader Comments (ExcelIsFun)
see all
All Comments (16)
-
you are awesome!
-
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
-
hi
Loading...
8:33
Excel Magic Trick 564: Daily Gantt Chartby ExcelIsFun16,016 views- 5:00
Excel Magic Trick 566: Conditional Format A Chart Student Gradesby ExcelIsFun5,058 views
- 2:31
Excel Magic Trick 567: Collapsible Expandable Cell Rangesby ExcelIsFun3,881 views
- 15:54
Excel Magic Trick 626: Time Gantt Chart -- Conditional Formatting & Data Validation Custom Formulasby ExcelIsFun22,111 views
- 9:15
How to Project Dashboard Excel Templateby ExcelTutorials44,107 views
- 2:45
Gantt Chart in Excelby mizhiro378,747 views
- 1:35
How to make Gantt Chart with Excelby gestionprojetauto23,126 views
- 9:55
Excel 2010 Magic Trick 661: AGGREGATE function Contains 19 different functionsby ExcelIsFun6,377 views
- 9:57
Create a Gantt Chart in Excelby COPADEGO12380,482 views
- 8:52
Construction Schedule using Excel Templateby Queegebo07187,563 views
- 6:17
Sales Forecasting with Excel 2010by wowmsft15,098 views
- 2:46
Chart Gantt Excel Template Demonstrationby rentalcarexcess4,491 views
- 9:45
Excel Magic Trick 584: Dynamic Range for Periodic Data Dumps into Excel OFFSET & Defined Namesby ExcelIsFun6,159 views
- 9:06
Excel Magic Trick 568: SUMIFS function Monthly Running Total from Transaction Databy ExcelIsFun7,983 views
- 7:16
How to create a Gantt Chart in Excel 2007 (In Plain Language)by cawad33,016 views
- 4:31
Excel 2010 Tips and Tricks - Part 2 CPE Link Webcast Preview (David Ringstrom)by CPELink1,890 views
- 12:12
Excel Magic Trick 574: Array Formula For Filtering Data With Categories of Criteriaby ExcelIsFun3,559 views
- 11:21
Excel Magic Trick 576: Dynamic Break Even Chart using INDEX and MATCH functionsby ExcelIsFun13,031 views
- 3:44
Excel 2010 | Projekttermine als Gantt-Diagrammby axelbecker426,644 views
- 3:00
Excel 2010 Preview #1: New Rank Function RANK.AVEby ExcelIsFun17,858 views
Mr. I might be wrong, but i think the formula is not working properly from rows 4 to 7
renelielwero 9 months ago in playlist Excel Conditional Formatting Tricks
How is the formula not working?
ExcelIsFun 9 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 9 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