Any suggestions building a Gantt type presentation with an hourly timeline vs. days? Data: Task, start time, end time both in 24hr/military time.

like
Posting as :
works at
You are currently posting as works at

You can download free templates (in trustworthy sources pls) - just search for “gantt chart hours template”

You can build your own, but its easier to leverage an existing one

About the hours format, you can just change it in excel (custom format for military hours is HHMM)

like

I think office pro timeline has an option for this. I’m sure you can configure the time style.

like

Thanks everyone!

Related Posts

Question for my 401k focused advisors out there--what programs are you using that is instrumental to your 401k practice that you simply can't do without? I'm being pitched on Envestnet & im not sold.

like

Does anyone here have a Tesla? Should I do it???...

like

Thoughts on potential business ideas or investment opportunities where I can live the life I deserve now and not in retirement? I’m always trying to think of potential business ideas and come up with nothing. As far as interests, it doesn’t matter what it is. As long as it makes money I’m interested.

like

Having to call Marriott to apply a suite night award to an SPG hotel on a reservation you made before the merger and combining accounts proves to you how much is still SO WRONG with this merger.

Partners,

My firm is immature in guiding development planning. I have energy to accelerate to the next level of responsibility.

What evidence distinguishes an analyst as ready for the next level?

like

Anyone in the Bay Area? M here

like

I know this question is somewhat vague and broad but I’ll soon be joining a Banking & Finance team (in BigLaw) as a junior associate. I’d be grateful for any tips on how to thrive in this role. What characteristics make a good junior transactional lawyer?

like

Hi Fishes,

I have 3 offers in hand
Thermo Fisher Scientific , State Street and one service based company Capgemini Which one to opt? Thermo and state Street are product based. Package from Capgemini is slightly higher compared to both.

Please suggest me which one to opt to?

like

Hi, I'm working as a business analyst with 3 years of experience in insurance domain and with govtech clients as well. I am getting constant rejections from Deloitte Ireland for the jr/sr BA positions. Can someone please tell me what might be going wrong ? Thanks in advance

Joseph Golden omnicom

like

Hi need referral for few job postings at MS.

like

What’s the best or worst place to work in Portland right now?

like
like

Where can we check legitimate cutoff for Canada express entry PR?
How often do the results come out? is it every month?
After submitting your profile in how many days can one expect to get Invitation?

How do you choose which production company to work with? What are the characteristics you look for when making your decision?

like
like
like

How is the work life balance in Citi?

Here is the scenario: Have 2 offers from IT MNCs and 1 from Citi. Citi's offer is the highest. Almost 5 lakhs diff in the fixed component. Although money is important, but I am also seeking a little balance with life. I was previously in ZS Associates and to be frank, life was hell. I am not looking to relive that phase again.
What are the daily actual working hours?
Shall I join Citi or let go it for a lower package offer?

Seeking honest advice here.

likehelpful

Additional Posts in Excel Genius

Would anyone be willing to teach me vlookup?

like

How do I compare two sheets to make sure they are identical?

like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

What are your top Excel ninja tricks? Ones that few people know...

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Still don't have xlookup. #fomo

like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

Any book recommendations on excel modeling for real world business applications?

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal