Hey Both of you,
Thank you so much for the help on this, I do appreciate it and it did make the formula a lot simpler, I was approaching it from the wrong angle.
Much appreciated :)
Hey,
I was wondering if someone would be able to help me with this, it's a little complicated, so I do apologise for that right away.
Effectively I have two time fields for shifts, which if above 6 hours and 15 minutes will subtract a 30 minute lunch. As excel is not a big fan of calculating...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.