CODEWITHSUNDEEP
excelexcel-formula
Nic
Nic

Reputation: 227

Convert Decimal to Hours in Excel

I'm using excel to sum up all the hours that my team worked on. However, the hours are displayed as 31.60 or 31.70

I want to convert 31.60 = 32 or 31.70 = 32.10. Just need the numbers, no formatting text.

Upvotes: 0

Views: 109

Answers (1)

Alexandru Cimpanu
Alexandru Cimpanu

Reputation: 1069

You could take the decimal part like A1-INT(A1) where A1 is your data and divide it by 0.6. The integer result that you get is added to the integer part of your cell. And finally add the rest of the division. I didn't manage to keep it short.

=INT(A1)+ INT((A1-INT(A1))/0.6)+ MOD((A1-INT(A1)),0.6)

Upvotes: 1

Related Questions