•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How Do You Change a Cell's Value Based on Another Cell?
Our take
Managing sales and employee hours in a spreadsheet can be tedious, especially when it requires manual calculations to convert hours and minutes. If you're entering labor totals like 2 hours and 30 minutes for Hour 1 and 2 hours and 45 minutes for Hour 2, you may find yourself doing the math repeatedly. By automating this process, you can streamline your workflow—transforming a total of 4 hours and 75 minutes into a more manageable 5 hours and 15 minutes without the hassle.
At work, we have a spreadsheet where we track sales and employee hours from another system. We manually enter the sales and the time.
However, the columns are separated in an hours and minutes value. Whenever I enter hours, I have to do the math manually. Not super hard, obviously, but I'd like to work smarter and not harder.
If Hour 1 has total labor of 2 hours, 30 minutes, I'd enter that manually. If Hour 2 has total labor of 2 hours, 45 minutes, I'd like for it to automatically set the Hours and minutes to the correct one.
So, the system would see 4 hours, 75 minutes and change the hours and minutes column to be 5 hours, 15 minutes. Again, the math is what I can do manually. I'd just like to have it be automatic.
Thank you.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
- Monthly tracking workbook I use to track employee sales metrics; Trying to find a way to make the process less labour intensiveTruly having a hard to describing my issue effectively but hoping someone can help. First time posting here and I'm by no means an expert with excel, so please be kind! I have a monthly workbook where I track each employees revenue and other metrics. Every 2 weeks for payroll, I provide a print out of these numbers, and the payroll sheet pulls data from multiple sheets in the workbook. For example, every workbook has a separate sheet for each day of the month, titled "1" through "31". I have pay period sheets, so I'll use one titled "04.02.26 - 04.15.26". Then I'll have the data for each employee pulled from multiple sheets. For example, I use the formula =SUM('2:15'!E3) to pull the sales data from each day of that period for the specific employee. This works quite well. However, when I create a new month's spreadsheet, I have to manually alter this formula for each employee and for each data point (more than just revenue, at least 6 different data points for 7 employees). Is there a way to automate this? For example, a cell or two where I'm able to enter the date range and all of the formulas update to that date range for the corresponding pages? I'm sorry of this post is confusing. Truly it's confusing even typing it! submitted by /u/Ok_Smile9222 [link] [comments]
- Time In Lieu SpreadsheetHey All, I have used Google Sheets forever but my new job uses Office and I am struggling with some of Excel's functions. I'm trying to create a spreadsheet that tracks my time off in lieu (TOIL) so I know where I'm at. I've created the bare bones of the spreadsheet ash shown in the image but I need help cleaning it up. Ideally I would like to have all of the time columns (B:H) only have hh:mm format and then all of the 0:00:00 values that haven't been used not to be shown. In cell L1 I would like it to show the most current level of TOIL, again in hh:mm format. Is this possible or am I asking too much of Excel? Thanks in advance. https://preview.redd.it/c8u5ha2cxszg1.png?width=1001&format=png&auto=webp&s=3985daa3d11541abed488f377c62e375f6ab1224 submitted by /u/Silky_45 [link] [comments]
- Small Business rounding issueHi, Can anyone identify why my spreadsheet is calculating the total to be $6133.33 instead of $6133.20? 153.33 total hours x $40/hr. I've been using the same spreadsheet for a year, the formulas are correct, this hasn't happened before, I can't figure out how to fix it. This is on sheets. Thank you https://preview.redd.it/0tzyhv5xkkxg1.png?width=708&format=png&auto=webp&s=7376ba5124c04fef83cea620b23810079a01655f https://preview.redd.it/lp1vzu5xkkxg1.png?width=702&format=png&auto=webp&s=68ca02b9d005fff97f4f69615e542d85fb02c9d1 https://preview.redd.it/5g9zi96blkxg1.png?width=1042&format=png&auto=webp&s=956143ad31c7e99cbd5551ba3f9ac9e1dff00639 submitted by /u/alicat9 [link] [comments]
Tagged with
#Excel alternatives for data analysis#rows.com#cloud-based spreadsheet applications#natural language processing for spreadsheets#modern spreadsheet innovations#machine learning in spreadsheet applications#generative AI for data analysis#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#Excel compatibility#collaborative spreadsheet tools#AI-driven spreadsheet solutions#real-time data collaboration#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#real-time collaboration#Excel alternatives#spreadsheet API integration#spreadsheet