3 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#big data management in spreadsheets
#real-time data collaboration
#real-time collaboration
#rows.com
#AI-native spreadsheets
#large dataset processing
#predictive analytics in spreadsheets
#cloud-native spreadsheets
#enterprise data management
#timekeeping
#timesheets
#personal attendants
#Personal Support Workers
#privacy issues