converting hours higher than 24 to decimal numbers

tali

New member
Joined
Sep 20, 2012
Messages
2
Reaction score
0
Points
0
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:
hours
decimal
01:30
1.5
The formula I used is: =hour(A2)+minute(A2)/60
13:1513.25The same formula is used on all rows.
25:301.5Why does it show 1.5 and not 25.5? How can I fix this?
 

tommyt61

New member
Joined
Mar 26, 2011
Messages
153
Reaction score
0
Points
0
Excel is converting 25:30 to 1:30 that is why you are getting 1.5

Try this and see if it works. Format the Cell(s) as general where you will put the formula.

=INT(A2)*24+HOUR(A2)+ROUND(MINUTE(A2)/60,2)
 

tali

New member
Joined
Sep 20, 2012
Messages
2
Reaction score
0
Points
0
Thank you!

it worked, thank you!
and sorry for the (very) late response....


Excel is converting 25:30 to 1:30 that is why you are getting 1.5

Try this and see if it works. Format the Cell(s) as general where you will put the formula.

=INT(A2)*24+HOUR(A2)+ROUND(MINUTE(A2)/60,2)
 
Top