User Profile
KevinCommunitas
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
- 1.7KViews0likes0Comments
Re: Help With Dates in Excel
It shows all of the dates! However, as soon as I either change the year in K2 or the day of the week in K3 (one or the other or both), all of the other cells say #NAME? which is the problem I was coming across myself. I can't seem to figure out how to make the formula work if I change the day or year.1.7KViews0likes4CommentsHelp With Dates in Excel
I've attached a copy of the Excel Spreadsheet that I'm using. There's a 3rd tab that I included in there as an example of how I want the dates to be returned. When I type in the Year in K2, and select from the drop-down list the day of the week in K3, I want for cells C8, E8, G8, I8, and K8 to show me only the dates for Tuesday in January (represented by cell A8). I also want cells C10, E10, G10, and K10 to show me only the dates for Tuesday in February (represented by A10). This would continue down the calendar. I've tried a bunch of different formulas and even tried using one of those AI Excel Formula generators to help me.Solved1.9KViews0likes6CommentsRe: Time Sheet Help
Unfortunately I'm having to work within the constraints of how they've always organized it. Before they were manually calculating the hours, and I'm wanting to make it to where they don't have to do that anymore without changing the formatting (they're resistant to change). The formula you came up with is pure brilliance!! It works within the constraints I have. There is only one problem. For some reason it's not calculating half-hours. For example, if someone has a total of 35.5 hours worked, it's rounding down to 35 hours for some reason. I'm still digging into this to see if I can figure it out. Thank you so much for your help.2.6KViews1like0CommentsTime Sheet Help
I'm going crazy here. I've been working on this Excel spreadsheet for 4 hours and I can't seem to figure this out. All I want to do is calculate hours. I have example Start and End times entered already. I want to calculate day by day the number of hours they worked, then tabulate the total hours worked in the Total Hrs column. Or, if it's possible, I'd prefer to NOT calculate day by day, remove the "Hrs" columns after each day, and just use the Total Hrs column to tabulate all of the hours worked for a given week. Both options seem to be beyond my abilities. I've been searching online for different types of formulas to potentially use, but nothing is seeming to work. I got VERY close once, but the hours coming up were negative hours, and when I tried correcting it to not be negative hours, the formula (MOD) wasn't working for me like it was for others. Can anybody help me stop pulling my hair out here? I'm already bald as it is, so there's not much left and I'd like to keep what I have haha.Solved2.8KViews0likes5CommentsRe: Excel Formula Help for $0.00 Value
I'd already tried the first option, and it didn't change anything. The 2 new options you gave me also have had no effect (I'd already tried similar formulas). I don't understand what is happening. Even when doing conditional formatting it's changing nothing.19KViews0likes5CommentsExcel Formula Help for $0.00 Value
I am in need of help with a formula again. This time it is for Conditional Formatting (at least I think). So I've tried every method I can think of, as well as using Google, to get cell D5 to show blank when the returned value is $0.00. Nothing I have tried seems to work. I've attached the spreadsheet. Any help would be greatly appreciated!! I've spent so much time trying to think of a proper formula to get it to work. I don't know what I am doing wrong. There seems to have been a change done where I cannot upload files directly here anymore. I don't know if I'm doing something wrong but I consider myself to be rather tech savvy. Below is a link to the OneDrive version of the spreadsheet to hopefully get around the fact that I can't upload the file directly here anymore. https://communitas123-my.sharepoint.com/:x:/g/personal/kdfox_communitas_org/EYUhfjmx0NJIln4VrDCRXV0BqCywptUG2NDhNH9rTxlk7Q?e=me657j20KViews0likes7CommentsFormula Help
I'm having difficulties figuring out a formula. I thought I'd figured it out but then it didn't work and so I am at a loss. I've attached a modified copy of the spreadsheet I've been using. What I'm seeking on the "Vendor Sheet" tab: I want to create a formula where if Cell E2 is Blank, it displays red like it currently does The formula in Cell E2 also needs to check the "Values" tab, and if C2 = Green, it'll display Walmart in Cell E2 on the "Vendor Sheet" tab The formula in Cell E2 also needs to check the "Values" tab, and If D2 = Green, it'll display Safeway in Cell E2 on the "Vendor Sheet" tab Maybe there is an easier way to accomplish what I'm attempting too. Basically if on the "Vendor Sheet" tab, Cell B5 is blank, I want cell E2 to be Red. If Cell B5 has 1-6 characters, I want E2 to display "Walmart". If it's 7-8 characters, I want E2 to display "Safeway". Any help is greatly appreciated. I thought I'd figured it out but my expertise in Excel is limited to what I learned in High School back in 2005. It's driving me crazy being unable to reconcile the formula like I thought I could.Solved1KViews0likes2Comments
Recent Blog Articles
No content to show