Hi everyone. I am a high school track coach in the U.S. and we are now going to start measuring our field events in metric rather than imperial. Since both myself and my coaching staff are so used to imperial, metric measurements don't mean a whole lot to us until we get used to them. So I'm creating a spreadsheet for my staff for quick reference. In column A I have meters and in column B I want to it to show the distance in feet and inches and I'd like the format to look like: 15' 7 ½". I want to round down to the nearest ½". Is there a way to do this? I can convert the meters to feet using the CONVERT formula, but then I get a decimal. I'm looking to do this:
I don't know if this is possible. Thanks for your help.
Meters | Feet |
1 | 3' 3" |
1.05 | 3' 5 ½" |
1.10 | 3' 7" |
I don't know if this is possible. Thanks for your help.