hi,
Here is a table I made, where I tried to convert hours to decimal numbers.
As long as I stayed under 24 hours it worked fine,
but when I reached the higher numbers it seems to have divided the number in 24 and show only the remainder....
Here's what I wrote:
Here is a table I made, where I tried to convert hours to decimal numbers.
As long as I stayed under 24 hours it worked fine,
but when I reached the higher numbers it seems to have divided the number in 24 and show only the remainder....
Here's what I wrote:
hours | decimal | |
01:30 | 1.5 | The formula I used is: =hour(A2)+minute(A2)/60 |
13:15 | 13.25 | The same formula is used on all rows. |
25:30 | 1.5 | Why does it show 1.5 and not 25.5? How can I fix this? |