How do you convert hours and minutes to decimal in excel?

Answer 1

If A1 contains the hours & minutes (ie, 2:15) then use this formula:
=HOUR(A1)+MINUTE(A1)/60
Be sure to format the cell with the formula as a number.

Answer 2

RE: How to convert hours and minutes to decimal time in excel? Hi. In my excel spreadsheet, I have someone who has worked a total of 39:45 hours (39 hours and 45 minutes). I have a cell with this number, formatted with [h]:mm, so it will show up as 39:15 when entered. Now I need to figure out how to take that cell and convert it into decimal time. In...

Answer 3

example:

hours: minutes: decimal equivalence:
2 15 ___________

for example of 2 and 15 minutes is 2 and 1/4 hours. so
type:
=(hours + minutes/60)

this will give you 2.25