Hey there,
I tried to create a a file that can return me the hours made during a shift. There are 4 différents possibilities:
- day hours (6:30 to 18:30. Max 9h)
- night hours (18:30 to 6:30. Max 9h)
- overtime day (6:30 to 18:30 on weekends and if days hours>9)
- overtime night (18:30 to 6:30 on weekends and if night hours>9)
You can see on the worksheet in the first line the formulas that i came up with but they don't take into account saturdays and sundays. But the idea is there
For the twist I would need to substract 30 minutes for lunch break only by checking a box. My problem here is that I don't know how to choose where to substract the 30 minutes. On normal day or night shift it's pretty easy but when they cross each other i just don't know. If y'all have an idea i would appreciate. Mine would be to add another box so I can decide if its a day or night meal but i would prefer only one box. Maybe a formula taking account if time during day or night is the bigger.
Anyway since i will probably have to modify later to add that feature, it would be nice if the 4 différents possibilities weren't linked with each other (unlike what I did haha).
Thanks