Need a function that separates over-lapping work shift hours.
We have temporary employees; sometimes an employee's hours will run over into
the next shift. Based on noting the employee's hours, I need a function that will automatically sort out which hours are First Shift, which are Second Shift, and so forth. Furthermore, I want the function to provide the actual number of hours worked on that shift in a separate cell. I'm thinking this will probably be a nested function, I haven't been able to locate a function that will allow me to do the intial calculation. Any suggestions? Thank you. |
All times are GMT +1. The time now is 09:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com