subtraction

I am trying to figure out how many minutes an employee was late. however when i use a basic subtraction formula, and they are not scheduled to work, but work anyways the formula is adding those hours in a strange way and it shows they are late. when they work but are not scheduled those hours do not need to show as late hours.

Hi,

you should subtract the smaller value from the bigger value. If you're after how many minutes they were late, subtract the scheduled start time from the actual start time.

If that gives you a negative, because they were early, use something like this

=MAX(0,H3-C3)