Hi All!
This is my first post so lets see how it goes. I have tried searching many different forums for an answer close to what I need but haven't found one. Maybe someone here could help? I am helping my mom with creating an excel timesheet for the employees at her company (around 60). I currently have 3 spots per day to clock in/out (see attachment). I have summed the total hours per day and how many overtime hours per day. My next step is to calculate the shift differential per day. Here is what the company defines as shift differential:
"If more than 50% of the shift is worked between 6pm and 6am then the ENTIRE shift gets shift differential pay. If less than (or equal to) 50% of the shift is between 6am and 6pm NONE of the shift gets shift differential pay."
Yes, I know this is asinine. It would be much easier and more straightforward to do it the normal way. But since the rules will not be changed what is the best way to accomplish this? First, formula or macro? Next, what specific text should the best way contain? I have some decent experience with formulas but nothing with macros other than being able to tell you what a macro is.
Thanks for all your input!!!!!!!!!!
Bookmarks