Forum Discussion
Converting numbers in decimal to hours & minutes
How can I convert the numbers I have with 2 decimal places to hours:minutes?
I know this is an old thread, but I've read through it a couple of times over the past month or so while trying to find an answer to this problem.
What I've found works for me is just dividing by 24 and then formatting the calculation to the custom format [H]:MM
example:
Decimal = 52.25
and you want this returned in the format of HH:MM:SS as 52:15:00
=A1/24
and use the custom formatting on that calculation. Simple as that! hope it helps others.
Hi all,
the suggestions do the trick but they are quite cumbersome in special mode when thinking that
one needs to go from decimal to time and back. The issue is not only of displaying things in an human way. Also the maths have to be done properly.
The fact that no negative time is possible is really restrictive.
It is incredible to me that excel is not improving (adding features or removing bugs)
the suggestions do the trick but they are quite cumbersome in special mode when thinking that
one needs to go from decimal to time and back. The issue is not only of displaying things in an human way. Also the maths have to be done properly.
The fact that no negative time is possible is really restrictive.
It is incredible to me that excel is not improving (adding features or removing bugs)