Replies

Cool! That works.
Now, how can I bring the formatting with the data in a lookup. I want the result to look just like the source. It has both text and cell formatting.

Thanks for the quick response. The cell is formatted as general. I’ve tried different formats but no change. And there are many formulas on the page, only this one displays and it only displays since I changed it to include the IF

Weird. I’d tried that before using the paste icon dropdown and special wasn’t there, but with a right click in the cell it is!

Thanks. I was trying to format to wingdings as part of the conditional formatting. That works now. Doesn’t do what I wanted it to do yet, but it’s enough for now!
Thanks!

Hi Maria,
Well I tried it. I have two problems. (1) I can’t get it to display the wingding font you have showing. AAMOF when I chose font they are all grey and I can’t choose one. (2) I’m hoping to use graphics (or text) for three choices, red, green, yellow.

Thanks! I’ll give them all a try. Not sure why my tests didn’t work last night.

I have exactly the same problem for years, even after a complete rebuild.
HP Pavillion DV-7 Win7 iTunes/iPhone, no VM
29302-_2011-11-01_06-51-32

Two more questions.
1. If a customer has a project plan that uses some of our resources can they use our resource pool for our people and their own (of just resources added directly into their project file) for the people we don’t track. The goal is that changes they make to one of our resource tasks will be reflected in our reporting and reduce or increase that resource availability to our other projects.
2. How does MSP use the resource pool physical file. We would store it on box.net so everyone can access, but don’t know if project updates that file with anything other than new/change resources. Does it track assignment there? How and what does it update?

one project, 400 tasks with 15 resources, 6 months. excel, project, access, no QB

Does anyone know about this?

Visio 2010

Mine too, but the next time I open it it’s not sorted the way I left it. Windows puts the most recently accessed folders on top.

Seeet!!

I think this is everything I need. I’ll work with it for the next week, and also study the formulas. thank you so much!

Bryan

There are several ways to get to a Summary. Take a look at the attached. Using this method, the daily data would be placed on the appropriate “Day #” tab.

Any thoughts?

Thanks Tim,

You’re right that that data for Duration isn’t a formula but it’s part of what’s copied from Outlook and I decided not to use it as I didn’t know how to add it up. But I figured there’d be a way to calculate the duration and then those columns could be summarized for the summary sheet. You provided those formulas thank you very much. So, to answer your questions for the summary, there are currently 9 categories, but that could change. There are currently 5 days to track per week and that’s just fine to say will stay stable. Some of those fields already have simple formulas to do exactly what you describe below.

My goal is to be able to grab the data from the first sheet and instead of having to manually summarize and populate, for the day actuals for each category to be filled in automatically.

Thanks!

Thanks for the example workbook.
On the tab named “Daily Time Log” in the Column named “Duration” it looks like the data is input manually.
To automate that process, try this formula beginning in cell E8 and copy down…….
=IF(ROUND(((D8-C8)*24)*60,0)<60,ROUND(((D8-C8)*24)*60,0)&" minutes",ROUND(((D8-C8)*24),2)&" hours")

There are several approaches for the Summary.
How many Categories will there be?
Will there be only 5 days of info?
It looks like the goal is 5 day average for Category and Category % by day?

For sure there will be more questions !!

OK. So I started over and this time copied data from the Outlook Journal instead of the Calendar, and it worked! Thanks so much. So now I’m excited to try the next step. I have the first data like I mentioned before, but there are more columns

Type Category Start End Duration
Task e-Myth Systems 6:30:00 AM 6:49:00 AM 19 minutes
Task e-Myth Leadership 7:00:00 AM 7:05:00 AM 5 minutes
Task Personal 7:15:00 AM 8:45:00 AM 1.5 hours
Task e-Myth Systems 8:45:00 AM 9:10:00 AM 25 minutes

I want to on a different sheet be able to group this time log by day by category. Now, I can send the day/time instead of just time from Outlook by changing the format of the list view in Outlook (or perhaps it’s embedded anyway in that time?) but my final Excel row should look something like.

Category Day1 Day2 Day3 …. Average time spent per category

I’ve attached the spreadsheet I’m starting with that has this as the “Time Log Summary” sheet.