I did my research. Really! But my scenario seems to be slightly out of the box than the other remediations I read. So, here it is:
I have a small field crew that works on a job. They bill each of their hours, per job, per day. OVERTIME is calculated as 1.5 ANY TIME work is conducted between the hours of 1700 thru 0800. Now, that computation is strictly for billing purposes, not the actual employee. I'm pretty certain it requires an IF statement, but as I am merely an EXCEL apprentice myself, the computation eludes me.
PLEASE HELP!
Bookmarks