Search results for query: *

Sorry - but I have no idea how to do what you just requested. I know my ignorance is showing - is there some place that describes this? Thanks, Jeanie

This will never be a very large spreadsheet so the slowdown will probably be OK :) Thanks, Jeanie

Thank you! That works. I appreciate your help :) Jeanie

I have a spreadsheet where I have data such as shown below: Name Case Date Number John 123 01/01/2016 ABC12345 Judy 567 01/02/2016 DEF56789 Jo 912 01/15/2016 HIJ12345 Jo 789...

THank you for your help! I think this will work great! Jeanie

Hmmmm...Nothing fills in? I did change the path because I'm working at a different location today so don't have access to that path. Maybe I entered it incorrectly? the path reads as: (G:)CS8909(\\hhs-hlncg\Users)>Jackie. I entered it as: \\hhs-hlncg\Users\Jackie. I put all the files into the...

I do not currently have all the workbook names. And yes, they will all be in one folder on a shared directory. That directory is (I:) PMB(\\hhs-pmbshare\Shared\DIR\Systems A few of the workbook names: AWACS Sweetgrass CHIMES KIDS SEARCHS Thanks, Jeanie

Sorry about being so unclear! I do not know how to upload more than one workbook to this thread so I have combined the different workbooks into different sheets. But, in "real life" they will each be a stand alone workbook. To clarify, every time AC1 is listed it will have the exact same...

I have no idea how to do what I need. Excel is probably not the best place to do it, however, everyone in my office has excel so that is where I was hoping to get it accomplished if possible. Any help anyone can give me would be greatly appreciated! I have workbooks where I am tracking some...

Thanks 1726 - I would have never figured that out! Jeanie

Thanks, everyone. Yogia's suggestion works perfectly for my situation! Jeanie

I am using Excel 2003 if that makes a difference. I do not think protecting the sheet will work because it is being forwarded to others to manipulate. thx

I am actually not using a formaula. My input is just 00:03:37 - which is what the cell shows, but the bar up at the top that shows the data (the formula bar - I think) shows it as 12:03:37 a.m. They want the bar to actually show 00:03:37. Sorry to be so confusing!

I am trying to format a report that shows the length of time an action took. I want the format to be in hours:minutes:seconds (00:03:37). I can get the cells to show this, but the formula bar at the top show 12:03:37 a.m.). This confuses the users. Is there anyway to get the bar to actually...

Thanks again - I think that it works exactly as I hoped now! Jeanie

Oops....in further review I find it is not counting how I want it to. Below is an example: File # Start Date End Date 12345 4/24/2006 7/31/2006 23456 6/23/2006 9/30/2006 34567 8/4/2006 8/31/2006 45678 9/13/2006 9/30/2006 Should count the following: April 0 May 1 June...

Thanks both Skip and Rofeu - this works perfectly!! Jeanie

That works great! For the ease of my users I am wanting to make the range for both the start date and end date 100s of lines longer than the records we currently have (so they can add to it and not worry about the formula). When I expand the range to include these totally blank records, it...

One more question on this. How would I modify the formula to account for blanks in the End_Date range? Some of the records do not yet have an end date, but need to still be counted. Thanks, Jeanie

Thanks! I love this site and all you brilliant people...I don't come out here often but ALWAYS get a quick response - and it usually works....as this one did. Thanks again! Jeanie