Butter7017Copper ContributorApr 21, 2021Subtract [h]:mm from 40 I am trying to subtract H2 from 40 in my attached example to separate out overtime from regular time. Any help would be much appreciated. Thanks Book2.xlsx10 KB
HansVogelaarMVPApr 21, 2021Butter7017 Don't you mean that you want to subtract 40 from the value in H2? If so: =H2-40/24
