Hi guys,
I'm working on a scheduling/payroll sheet and I've stumped myself. I have one sheet that displays the shifts (12-8, 8-4, 4-12 format). The next sheet pulls off the schedule and calculates and totals hours worked. Employees who work between specific hours get incentive pay. I would like to have the sheet pull the data off the schedule sheet and calculate the total accumulated hour worked between 12am & 8am for each employee. Any ideas?
Please could you post a small file showing expected results.Thank you.
Hi, welcome to the forum
Perhaps this will help you get started...
What you need to understand about dates and times in excel is...
a date is just a number representing the number of days passed since 1/1/900...and then formated in a way that we recognise as a date. So, for instance, today (Fri Jul 2015) is actually 42188
Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks