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