Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Excel Frequency Function Example
  • How to calculate average last N values in a table in Excel
  • Working With Tables in Excel
  • Conditional Formatting Icon Sets Examples in Excel
  • How to Sort by Color in Excel

References

  • Last row number in range
  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel MATCH Function
  • Extract data with helper column in Excel
  • Vlookup Examples in Excel

Data Validations

  • Excel Data validation exists in list
  • Excel Data validation require unique number
  • Excel Data validation date in next 30 days
  • Excel Data validation allow uppercase only
  • Excel Data validation must contain specific text

Convert inches to feet and inches in Excel

by

To convert a measurement in inches to inches and feet (i.e. 53 to 4′ 5″) you can use a formula based on the INT and MOD functions. See illustration below:

Formula

=INT(A1/12)&"' "&MOD(A1)&""""

Explanation

In the example shown, the formula in D5 is:

=INT(B5/12)&"' "&MOD(B5,12)&""""

How this formula works

This formula converts a numeric value in inches to text representing the same measurement in inches and feet. To get the value for feet, the INT function is used like this:

=INT(B5/12)&"' "

Inside INT, the value in B5 is divided by 12 and INT simply returns the integer portion of the result, discarding any decimal remainder. The result is then concatenated to a string with a single quote and space character.

Worked Example:   Sum every nth column in Excel

To get a value for inches, the MOD function is used like this:

MOD(B5,12)&""""

where number comes from B5 and the divisor is 12. Configured in this way, MOD returns the remainder after division. The result is concatenated to two sets of double quotes. The outer pair indicates text, and inner pair is needed for Excel to output a single double quote.

Worked Example:   Get days, hours, and minutes between dates in Excel

Finally, the INT code and MOD code are concatenated together and Excel returns the final text value.

Worked Example:   Highlight every other row in Excel

With complete labels

To output a value like “8 feet 4 inches”, you adapt the formula like this:

=INT(B5/12)&" feet "&MOD(B5,12)&" inches"

Post navigation

Previous Post:

How to generate random date between two dates in Excel

Next Post:

Popularly Used Excel Functions and their examples

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to use Excel AND Function
  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • Check multiple cells are equal in Excel
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • NOT function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Sum race time splits in Excel
  • Calculate date overlap in days in Excel
  • Two ways to sum time over 30 minutes in Excel
  • Convert decimal minutes to Excel time
  • Get date from day number in Excel

Grouping

  • Group arbitrary text values in Excel
  • Running count group by n size in Excel
  • Calculate conditional mode with criteria in Excel
  • How to randomly assign data to groups in Excel
  • Group times into unequal buckets in Excel

General

  • Mark Workbook as Final in Excel
  • How to generate random times at specific intervals in Excel
  • How to generate random number between two numbers in Excel
  • How to get Excel workbook path only
  • 231 Keyboard Shortcut Keys In Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning