I'm building an Excel program to replace employees just using MS Word to submit time sheets. We are paid on the 15th and the last day of the month. Our time periods run from the 11th through 25th and 26th through 10th. Time sheets are due on the last day of the pay period.
I am working on an Excel which each employee will fill out (on a shared network drive). My goal is to have our HR person open a master time sheet that shows names of each employee and the hours for that pay period. No time calculations are needed; we just enter (in decimal format) how many hours we work each week.
I have built this program and it's quite complex, but I'm having some issues. Most pay periods have 15 days. Some have 14 and more have 16. This causes my totals to be off. I'm attaching the Excel 2007 file so you can see what I mean (that's the only way you'll be able to).
I'm open for recommendations, even a PHP-based timesheet app as long as it will allow users to just go in at the end of the pay period and enter all the time in (without IN/OUT times). We need it to be simple for EUs to enter.
Don't worry about how it looks; it'll be cleaned up (cols hidden, etc) when it's ready.
2 things I'm asking here: 1) How can I make it work the way I need to? 2) How do I build a master file that links and updates a multitude of these files?
Why do you care? Your messages are still E2E-encrypted, those won't show ads. Why do you care if you see a promoted channel once in a while or during status updates? I see a bunch of random s**t all the time on those, anyway, so I really don't pay attention.
So, do you expect to be given something in exchange for nothing? They answer to shareholders, and I'm sure they want to see WhatsApp generating revenue in some way. We'd do the exact same thing, come on...
You see ads on everything because you don't want to pay them money. YouTube, Facebook, Instagram, Netflix, Google Search, Reddit, everything follows the same economics, why are they different?
Question
ttam
I'm building an Excel program to replace employees just using MS Word to submit time sheets. We are paid on the 15th and the last day of the month. Our time periods run from the 11th through 25th and 26th through 10th. Time sheets are due on the last day of the pay period.
I am working on an Excel which each employee will fill out (on a shared network drive). My goal is to have our HR person open a master time sheet that shows names of each employee and the hours for that pay period. No time calculations are needed; we just enter (in decimal format) how many hours we work each week.
I have built this program and it's quite complex, but I'm having some issues. Most pay periods have 15 days. Some have 14 and more have 16. This causes my totals to be off. I'm attaching the Excel 2007 file so you can see what I mean (that's the only way you'll be able to).
I'm open for recommendations, even a PHP-based timesheet app as long as it will allow users to just go in at the end of the pay period and enter all the time in (without IN/OUT times). We need it to be simple for EUs to enter.
Don't worry about how it looks; it'll be cleaned up (cols hidden, etc) when it's ready.
2 things I'm asking here: 1) How can I make it work the way I need to? 2) How do I build a master file that links and updates a multitude of these files?
Master_Timesheet_Template.zipFetching info...
Link to comment
https://www.neowin.net/forum/topic/764610-excel-time-sheet-bi-monthly-time-calculating-overtimeheadache/Share on other sites
8 answers to this question
Recommended Posts