Formulas combined with text

%3CLINGO-SUB%20id%3D%22lingo-sub-987383%22%20slang%3D%22en-US%22%3EFormulas%20combined%20with%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-987383%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20help%20with%20a%20formula%20I%20am%20trying%20out%20for%20the%20very%20first%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20is%20regarding%20a%20production%20process%20concept.%3C%2FP%3E%3CP%3EI%20get%20the%20following%20info%3C%2FP%3E%3CP%3E1.%20The%20the%20number%20of%20hours%20each%20machine%20was%20on%20per%20shift.%3C%2FP%3E%3CP%3E2.%20The%20total%20number%20of%20units%20manufactured%20in%20that%20time.%3C%2FP%3E%3CP%3ETotal%20production%20%2F%20number%20of%20hours%20%3D%20Production%20rate%20per%20hour%3C%2FP%3E%3CP%3Ebasically%20I%20want%20my%20output%20to%20look%20something%20like%20this%3A%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B200%2Fhr%3C%2FP%3E%3CP%3EWhere%20the%20200%20will%20be%20from%20the%20formula%3A%20%3Df2%2Fg2%3C%2FP%3E%3CP%3Ethe%20text%20will%20be%20the%3A%26nbsp%3B%20%26nbsp%3B%2Fhr%3C%2FP%3E%3CP%3EI've%20tried%20the%20single%20and%20double%20aphostrephe.%20tried%20the%20formula%20in%20brackets%2C%20tried%20the%20text%20in%20brackets.%3C%2FP%3E%3CP%3ECan't%20seem%20to%20get%20it%20right.%3C%2FP%3E%3CP%3EThis%20is%20probable%20something%20simple%3F%20Can%20you%20assist%20me%20please%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-987383%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcell%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-987474%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20combined%20with%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-987474%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20I%20got%20your%20issue%20correctly%20this%20should%20do%20the%20trick%3A%20A1%2FB1%26amp%3B%22%2Fhr%22%3CBR%20%2F%3E%3CBR%20%2F%3ELet%20me%20know%20how%20it%20goes.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-987541%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20combined%20with%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-987541%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F119994%22%20target%3D%22_blank%22%3E%40Ricardo%20Viana%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26amp%3B%20that%20is%20all%20that%20was%20missing%20-%20Gonna%20slam%20my%20head%20against%20the%20wall.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanx%20it%20works%20great.%20just%20had%20to%20add%20the%20round%20function%20cause%20I%20was%20getting%20a%20very%20long%20point%20something%20something%20ect%20number.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAgain%20thank%20you%3C%2FP%3E%3CP%3EEnjoy%20your%20day%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Greetings

 

I need help with a formula I am trying out for the very first time.

 

this is regarding a production process concept.

I get the following info

1. The the number of hours each machine was on per shift.

2. The total number of units manufactured in that time.

Total production / number of hours = Production rate per hour

basically I want my output to look something like this:             200/hr

Where the 200 will be from the formula: =f2/g2

the text will be the:   /hr

I've tried the single and double aphostrephe. tried the formula in brackets, tried the text in brackets.

Can't seem to get it right.

This is probable something simple? Can you assist me please

2 Replies
Highlighted
Hi,

If I got your issue correctly this should do the trick: A1/B1&"/hr"

Let me know how it goes.
Highlighted

@Ricardo Viana 

& that is all that was missing - Gonna slam my head against the wall.

 

Thanx it works great. just had to add the round function cause I was getting a very long point something something ect number.

 

Again thank you

Enjoy your day