I making a spread sheet for work to track total hours worked on days off.. I am in need of a formula to add only X/16 and X/8 to equal 24, etc. I am trying to keep track of overtime hours for the entire year.

example

8

8

X/16

X/8

8

8

X/4

total hours worked on days off = 28

thanks

example

8

8

X/16

X/8

8

8

X/4

total hours worked on days off = 28

thanks

Last edited: