B
Boenerge
I have set up a worksheet calculating employees time worked. As the data
inputted is shift type e.g. e, l, n. I have setup a formula to work out each
shift by its time length e.g. e = 7.5 hrs etc. As my employees do not all
work set convenient hours some work overtime. How can I set a formula for
excel to report back if someone works 9hrs 22.5 minutes that they have either
worked more or less than their contracted hours in a time vale and not as a
part of 100?
inputted is shift type e.g. e, l, n. I have setup a formula to work out each
shift by its time length e.g. e = 7.5 hrs etc. As my employees do not all
work set convenient hours some work overtime. How can I set a formula for
excel to report back if someone works 9hrs 22.5 minutes that they have either
worked more or less than their contracted hours in a time vale and not as a
part of 100?