A
Andrea
I am trying to calculate my cell labeled regular time to subtract any
personal time taken and give me a subtotal (also without overtime hours). If
a person was to take a week of vacation, I would like for the cell to read 0
regular time.
For example, this is what I would want the regular time cell to read in each
situation:
Total hours: 40
sick hours: 8
regular time: 32
also
total hours: 50
sick hours: 8
regular time: 40
overtime: 2
also
total hours: 0
vacation: 40
regular time: 0
What formula would I use in regular time cell in order to calculate the
correct hours for each situation? Any help would be greatly appreciated!
personal time taken and give me a subtotal (also without overtime hours). If
a person was to take a week of vacation, I would like for the cell to read 0
regular time.
For example, this is what I would want the regular time cell to read in each
situation:
Total hours: 40
sick hours: 8
regular time: 32
also
total hours: 50
sick hours: 8
regular time: 40
overtime: 2
also
total hours: 0
vacation: 40
regular time: 0
What formula would I use in regular time cell in order to calculate the
correct hours for each situation? Any help would be greatly appreciated!