LF a simple way to have employees clock in and out (timekeeping)
Our take
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.
[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]
- Creating an auto-populating visual calendar for multiple departments to view?I coordinate student schedules across multiple hospital units. I log the shifts in an hours log spreadsheet (date, start time, end time, unit, student name, etc.). Every month, I need to send each unit a schedule showing who is coming in and when so they can review and plan coverage. Right now, this part is very manual, and does not lend to tracking any data like how many students on each units, hours, etc., which we need as a department. We have over 100 students each month, so as much automizing as possible would be helpful as its a big process. Ideally, I’d like something that: Pulls directly from the hours log (no retyping or copy/paste) Is easy to read at a glance for unit managers Can handle many units, many months, and many students Lets me filter by unit + month I'm not really an excel genius, and I've been using copilot to help me with some of this and formulations, but It's not providing me with accurate formulas for the actual calendar conversion. If there are any resources on what formulas to use, what platforms that I could maybe look into for how to do this, or just honestly any advice at all. We've gotten the data tracking mostly drafted up and it's able to pull from pivot tables and show the analytics, but the calendar is my biggest hurdle at the moment. submitted by /u/JuggernautFlashy6489 [link] [comments]
- 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]