•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I need a spreadsheet to know how many hours I work and how much I will charge
Our take
Managing your work hours can be challenging, especially with fluctuating schedules. Creating a simple spreadsheet can help you track your hours, calculate total earnings, and account for different rates such as night or extra hours. By inputting your start and end times, the spreadsheet can automatically calculate the hours worked and categorize them accordingly. This tool not only streamlines your record-keeping but also empowers you to confidently manage your income and deductions. Let’s explore how to set up this effective solution for your needs.
Hello, I don't know anything about Excel or I have a PC, but well, I have the app.. but I need help, I work on demand, they call me when they need and they change my schedule.. that's why controlling the hours is sometimes cumbersome (for topics such as night hours etc.) could someone help me with tips on how I can make a spreadsheet that adds up the hours? In other words, the idea is to set the schedule I work and that the spreadsheet adds up how many hours I worked and then the total..
The criterion would be to be able to put the date, the schedule for example from 14 to 22 and that the form says how many hours there are and adds them in total, if it is possible to specify more as hours after x quantity that counts them separately (extra hours) or that the hours after a certain schedule are counted separately (night hours)
I just want to put the schedules and know how many common, extra and night hours I did so I can calculate what I should charge and deduct taxes etc...
I know I ask a lot and maybe it's not possible to do this in the app, if you could help me I would appreciate it.
Even if no one helps, thank you anyway.
If it reads weird it's because it's automatic translation...
Repost translated because for some reason reddit deleted it.. although it was in English...
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- Formatting question for automating data entryIm going to try to articulate what I need and if it’s possible to do inside excel. At my job I have to record the amount of patrons using our facilities. and specify what particular services are being used. at the end of each quarter. (3 month period) I must tally up all the numbers and provide a total for each aspect of our facility as well as the total overall. For example. 1st quarter numbers. 100 patrons used theatre. 250 patrons used Game room 450 patrons used computer lab so on and so forth. Now that you have the gist in your head. Imagine a spreadsheet where the first form is just a data entry sheet. it’s essentially just a box that never changes. You input the numbers for the week, and that data gets automatically moved to a different cell that has the total amount. so that at the end of the quarter I can easily see my total without having to backtrack or tediously add. if anyone has some insight on how I can do this Please reach out. If you have any questions about my wording or understanding exactly what I mean please also reach out. If you read all this I appreciate your time. submitted by /u/Beneficial-Yard-9006 [link] [comments]
- How Do You Change a Cell's Value Based on Another Cell?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. submitted by /u/ChronoKeep [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]
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#spreadsheet API integration#Excel compatibility#Excel alternatives#rows.com#financial modeling with spreadsheets#spreadsheet#hours