•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Need to generate timestamps easily without using VBA. Ideas?
Our take
Are you struggling to track productivity times without relying on VBA in Excel? You're not alone. Many organizations are moving away from macros due to security concerns, leaving users like you seeking simple, effective solutions. Fortunately, there are user-friendly methods to create timestamps without complex coding. Whether you choose to enhance your Excel sheets or explore alternatives like SharePoint, this guide will highlight easy options that empower your team to log their work seamlessly. Read on to discover practical ways to streamline your timing process.
Occasionally, I have my staff do productivity timings using an extremely simple Excel sheet. Using VBA... Click this cell to generate a start time, click this cell to generate an end time. So each row is basically a widget of work... They click the start time cell, do the work, click the end time cell, categorize it with some drop-downs, move on. Easy.
However, the corporation is disabling all Microsoft macro use over security concerns, and my staff will no longer be authorized to use them. So I'm trying to come up with an extremely simple, user-friendly way for them to generate start and end times on an Excel sheet... without using VBA. And I mean... so easy a caveman could do it. But I truly have no idea where to start with something like that.
Also open to not using Excel at all if there's a better way (like SharePoint).
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Time sheet that can draw from one spreadsheet, add a value, and add to a different spreadsheet.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. submitted by /u/plumremarkabl3 [link] [comments]
- LF a simple way to have employees clock in and out (timekeeping)I am in Canada. I need a simple way to track timesheets for my (three) employees. These are personal attendants (like Personal Support Workers, for people with disabilities). Right now, since I have only three attendants, so I print off paper timesheets and they fill them out. It works well for me, but I am not comfortable with the privacy issues since every attendant can easily pick up the others paper timesheets and view how many hours the others are working. My apartment is not large enough for me to keep a locked filing cabinet so everyone can have their own sheet locked away, or anything like that. I am also not interested in me having to unlock and give them these papers every shift (and remember to lock them back up after their shift). I know I will forget at some point. I have considered asking my attendants to text me, but there are concerns about this as well, such as if an attendant forgets to text me their hours, it's on me to remind them and if I forget, it's a hassle. Plus I have to enter their information into the timesheets to submit to the bookkeeper - work I want to avoid if possible. I prefer something the attendants can see every shift as a reminder to fill out their hours (and the paper does this, if they forget to enter the time they leave one day, they will see that next time they are in so it gives them a chance to fill it in then). So I have been thinking if some sort of excel spreadsheets would work somehow - but I want it to be seamless, and as little work for me as possible. Keeping in mind I would prefer the attendants use the iPad I have in the house for them to open a task management app we use), so it would need to be "mobile friendly". I tried the Homebase app for timekeeping this morning and it was a bit of a nightmare. Way too complicated. Is there a way to make something simple in excel that the attendants could easily use from the shared iPad I supply? I hope I can password protect each individuals timekeeping sheet so they couldn't view the other employees timekeeping sheet, and I don't want them using their personal phones for this. submitted by /u/lonelyfatoldsickgirl [link] [comments]
- Need to Reformat a Negative TimeHello all! Working on a bunch of data at work, and I've got most of the nuts cracked except this one. Because I'm trying to consolidate weeks worth of data and look for patterns, I've got a 14 page workbook. My ultimate goal is to make this user friendly for others to use with only copying / pasting their data into the data sheets. The data that we're importing is bad. It's got multiple numbers and times stored as text. I've gotten them all to work (figured out how to copy a cell and select ranges of numbers and paste special multiply in VBA today, so that was cool!) except for one. The cell is a difference in time, but I don't have the original numbers, so I can't even perform the calculations myself. I've just got a cell that says (for example) -00:08:37 for 8 minutes and 37 seconds under plan. When the cells are positive, I can multiply them by 1 then format them back to hh:mm:ss, but when they are negative this isn't working. I could likely use some sort of a formula to break them down and turn them into a decimal, but like I said, I'm trying to make it where other users can paste data (up to 12 days of up to 200 rows x 25 columns) and then hit a macro button and have it fill / filter all the data for them. As such, I'd really prefer to avoid using a second column to make this happen, and that's where I'm drawing a blank. So what I'm hoping to do is use a VBA function of some sort to change -hh:mm:ss into -mm.ss or similar format, preferably within the same column. I've only seen one number where hh = 01, but it has happened. 99% of the time it's -00:mm:ss. Excel 365 desktop in English. I'm probably intermediate / advanced. I'm already using macros in this workbook. Thanks all! submitted by /u/JustPlainJef [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]