•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Time sheet that can draw from one spreadsheet, add a value, and add to a different spreadsheet.
Our take
Are you feeling overwhelmed trying to create a timesheet that pulls data from one spreadsheet and adds values to another? You're not alone. Many beginners find themselves in the same boat, especially when it comes to managing job numbers and hours. Fortunately, harnessing the power of spreadsheets can simplify this process. By learning how to connect these sheets effectively, you’ll streamline tracking hours and make informed decisions effortlessly.
I am not sure exactly what I am looking for. I am a super beginner in excel. Think middle school in 2008 kind of beginner. I am trying to help with building a time sheet that will allow us to have one spreadsheet that will have job numbers and the people who have been assigned to the job and take that into another spreadsheet that will add numbers based on the job. eg, Job A is worth 12 hours, Job B is worth 3 hours. I feel as though I may be entirely out of my depth with this and am more than willing to admit defeat before we even begin, but figured I would reach out to the internet before giving in so early. Thank you all for reading.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- I need a spreadsheet to know how many hours I work and how much I will chargeHello, 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... submitted by /u/nameku9 [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]
- Simplified spreadsheet solution for field staff?I work with some field staff who are not familiar with software in general. Training is very unlikely We need to get information from them. An example of this would be a time sheet. Currently this comes in multiple forms but primarily physical paperwork and text I’m looking to see if there’s a simplified solution, perhaps like a very limited Excel: just the table and rows the ability to fill in the rows. Excel is too confusing with the extraneous buttons for text size, font size, formulas, etc. Any ideas would be appreciated submitted by /u/somemumblejumble [link] [comments]
- Issue with spreadsheet containing time calculation formulasI have a new clock in/out machine which has 3 columns, 1 for clock in, 2 for clock out and a 3rd column for the total time worked. Staff can clock in/out multiple times a day. It comes to me as an xls file with all the in/out cells as 'general' format and the 3rd column is as custom hh:mm but not the subtraction formula to show the total time worked even though the numbers are right. If i change the in/out from general to custom and then hh:mm I seem to have to click each individual cell for the format to change from (ie) 09:58 AM to 09:58 without the AM but the PM cells still show PM and when i do the subtraction formula for the total time worked it comes out as an error value, no amount of trying different formulas will change it to what it needs to be. I don't mind the first 2 colums showing as AM/PM but even with them that way the subtraction for the total time calculation still comes up as with a 'value' error https://preview.redd.it/hvunwr4p58og1.png?width=512&format=png&auto=webp&s=c11e3a1b77c137a4a40544c7bb2274e813d1038c submitted by /u/Loud-Conference8055 [link] [comments]
Tagged with
#cloud-based spreadsheet applications#Excel alternatives 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#automation in spreadsheet workflows#no-code spreadsheet solutions#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#financial modeling with spreadsheets#rows.com#real-time data collaboration#time sheet#spreadsheet#Excel#job numbers