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? |