Question Timesheet Programme

[Elmobram22]

Hi all,

I'm trying to make a simple program to automate timesheet templates. Each of our staff members work on a 4 weekly basis (week 1, week 2, week 3 and week 4). I currently use a word document with the template in and copy and paste it into the timesheet. The timesheets run from the 23rd of one month until the 22nd of the month after. The issue is the four weekly template doesn't fit the same every month so I am after an automated process.

I'm thinking of having forms to select a staff member and change their hours on the template, if you will, and then a button to create new timesheets where admin staff would just need to add the first date (ie 23/09/2013) and the timesheet would be made for each staff member and auto filled with the four week template.

My main issue is I'm not sure how to link the dates to the weeks in a table. I have attached a word template of my own hours for a rough idea of what I mean.

Any ideas?

Cheers,

Paul

 

[spikepl]

The more interesting question is how do you collect the data? Are these paper forms that people fill out and then someone types them? What about a paperless system? Or, nowadays there are tons of things on the web, where you can even report hours via cellphone etc?

 

[Elmobram22]

The more interesting question is how do you collect the data? Are these paper forms that people fill out and then someone types them? What about a paperless system? Or, nowadays there are tons of things on the web, where you can even report hours via cellphone etc?

Hi,

Thanks for the reply. We have a very complex system and have tried some of the cloud based programmes out there but none of them meet our needs properly. What I am trying to achieve is having a 4 week template for each staff member which you would change if shifts changed (not sickness or annual leave or anything just what they should be working for the month). Then having a button that would create timesheets by adding those values in dependent on date. A very simple system that does not need to track changes as they happen.

Cheers,

Paul