I formatted the cell to "Time" and display hh:mm

Then when you "SUM" the column, the math is correct.

to get the totals to total a large number of hours.. like 310:20 (310 hrs
20 minutes) log book total.. you will need to pick the hh:mm:ss format. the
display will now read 310:20:00

BT

"Mal" wrote in message
...
Hi does anyone know the formula for excel so it will add the minutes after
the decimal and convert them to hours.

Need to check my log book times and make a database off information types
flown etc.

EG

1.33
1.56
=2.89

Needs to say 60 mins is one hour

so

1.33
1.56
=3.29

???????????????

=SUM(E1:E23)

=IF(A31000,TIMEVALUE(LEFT(A3,1)&":"&RIGHT(A3,2)),T IMEVALUE(LEFT(A3,2)&":"&RIGHT(A3,2)))
The formatting of the cells in column B is HH:MM.

Thanks Mal