Time Format not working with multiple ranges

[BrianExcel]

I found the following formula online which basically converts times greater than 60 minutes into hours. So if someone entered 65 minutes, the cell would show 1:05 instead .65.

=TEXT(TIME(INT(A1),MOD(A1,1)*100,0)+TIME(INT(A2),M OD(A2,1)*100,0),"[hh]:mm")

My problem is that I need the calculation above to take cell ranges into account, not just individual cells. Using the above formula as an example, I would want to do the following:

=TEXT(TIME(INT(A1:A5),MOD(A1:A5,1)*100,0)+TIME(INT(B1:B5),M OD(B1:B5,1)*100,0),"[hh]:mm")

Any thoughts?

 

[Gerald Higgins]

What's in A1:A5 and B1:B5, and what exactly do you want the results to be ?