Forum Discussion
Solved
How to work out hours from number answer?
Hi, I am doing a service swap with a client. So I owe him £250 but I charge £35 per hour for my work. How many hours do I owe him?
When I work it out in excel it 250/35 = 7.142857143 but what formula would I need to turn 7.14... into hours? For example, I know 7.25 would be 7 hours and 15 minutes but what would the .14 be?
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.
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.
- Thanks so much, that's worked great 🙂
