How to work out hours from number answer? (2024)

@lionheartva

To convert the decimal portion (the .14 in your case) into hours and minutes, you can use the following Excel formula:

Assuming that your decimal value is in cell A1, you can use the following formula to convert it into hours and minutes:

=INT(A1) & " hours and " & TEXT((A1-INT(A1))*60,"0") & " minutes"

Here's how it works:

• INT(A1) extracts the whole number part, which represents hours.
• (A1-INT(A1))*60 calculates the decimal part (in minutes) by subtracting the whole number part from the original value and then multiplying by 60 to convert it from hours to minutes.
• TEXT(...,"0") formats the decimal part as a whole number, ensuring it displays as minutes without decimal places.
• The & operator concatenates the whole number part (hours), the text "hours and," and the formatted decimal part (minutes) into a single string.

So, if you enter 7.142857143 in cell A1, the formula will return "7 hours and 8 minutes," which is the equivalent of 7.14 hours.

The proposed steps/solutions are untested. The text and steps were edited with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.