Subtract [h]:mm from 40

%3CLINGO-SUB%20id%3D%22lingo-sub-2280745%22%20slang%3D%22en-US%22%3ESubtract%20%5Bh%5D%3Amm%20from%2040%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280745%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20subtract%20H2%20from%2040%20in%20my%20attached%20example%20to%20separate%20out%20overtime%20from%20regular%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20much%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2280745%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2280761%22%20slang%3D%22en-US%22%3ERe%3A%20Subtract%20%5Bh%5D%3Amm%20from%2040%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280761%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F832289%22%20target%3D%22_blank%22%3E%40Butter7017%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDon't%20you%20mean%20that%20you%20want%20to%20subtract%2040%20from%20the%20value%20in%20H2%3F%20If%20so%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DH2-40%2F24%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

1 Reply

@Butter7017 

Don't you mean that you want to subtract 40 from the value in H2? If so:

 

=H2-40/24