Hi Jonny,
I started this and somehow (i think) I made it overcomplicated,
But as there are no other answers - see mine.
Macro is rather long (algorithm is rather strightforward - my coding was far from perfect and made it so long) but I used made some comments inside, to make it easier to understand.
As for results: note especially:
- row 15 (changed data to simulate special case of "start" Monday before real starting hour)
- row 85 - here start is in Sat previous week
- row 216 and some motre with green background - start in overtime but before 6am corected
Also have a look on Overtime sheet - 3 columns format has to be followed - date start_time end_time
And as I wrote in comments - only hours are calculated (but located in T at the moment to easily spot difference), other columns you shall correct yourself (of course, this macro).
Bookmarks